"Export database as SQL" automation

21 posts
Tadas's profile image Tadas posted 6 months ago in General Permalink

Is there possibility initiate periodical "Export database as SQL" execution non-interactively (by some command line keys)? The need is to build/update sql script as an export of database on daily basis.

10163 posts
ansgar's profile image ansgar posted 6 months ago Permalink

No, you cannot automate the SQL export with HeidiSQL.

I always recommend the mysqldump utility for doing that. It's highly configurable per command line options and available on all operating systems.

21 posts
Tadas's profile image Tadas posted 6 months ago Permalink

Thanks. I wouldn't be asking, if I haven't faced a bug in mariadb-dump, while HeidiSQL went correct for the same DB.

Please login to leave a reply, or register at first.