Can you schedule an automated "Export database as SQL" command in HeidiSQL?
I am using WAMP and HeidiSQL and I need a way to automatically backup the data.
Is this possible? Is there a workaround?
Thank you. NJ
Can you schedule an automated "Export database as SQL" command in HeidiSQL?
I am using WAMP and HeidiSQL and I need a way to automatically backup the data.
Is this possible? Is there a workaround?
Thank you. NJ
Not with HeidiSQL, as you can read in the help section for command line parameters.
You can use mysqldump.exe from the MySQL server download instead:
c:\>"Program Files\MySQL xyz\bin\mysqldump.exe" -hlocalhost -uroot --opt --result-file=mybackup.sql mydatabase
The Windows Task Scheduler lets you then schedule any command line program:
Taskschd.msc
See the Microsoft Technet doc: https://technet.microsoft.com/en-gb/library/cc721931(v=ws.11).aspx
Please login to leave a reply, or register at first.