Autimatic Backup at any DAY

[expired user #7331]'s profile image [expired user #7331] posted 11 years ago in Import/Export Permalink
Huy Guy,
i need help to setting automatic backup of the my database any day at 6:00 pm.
I using on server: HeidiSQL 8.0.0.4401 and on local machine Mysql Browser.
MySql Browser have a schedule of backup, this setting I not find in HeidiSQL.
I can't access at the Data Base form local machine to server
ansgar's profile image ansgar posted 11 years ago Permalink
HeidiSQL is a GUI and started manually by the user. So, there is no scheduler in HeidiSQL.

I recommend doing that with an automatic Windows task and mysqldump.exe from the MySQL server.

By the way, you should update your HeidiSQL to the latest release.
[expired user #7331]'s profile image [expired user #7331] posted 11 years ago Permalink
Ok, thanks
Can you send me the syntax for the backup on mysqldump.exe?

thanks
ansgar's profile image ansgar posted 11 years ago Permalink
mysqldump.exe -hYourIpOrHost -uYourUserName -pYourPassword yourdatabase >c:\path\to\backupfile.sql
[expired user #7331]'s profile image [expired user #7331] posted 11 years ago Permalink
ok,
Thanks

Myeschool
nortitec's profile image nortitec posted 2 years ago Permalink

[code]mysqldump.exe -hYourIpOrHost -uYourUserName -pYourPassword yourdatabase >c:\path\to\backupfile.sql[/code]

Hello Can you post the command or how to restore it then? I can backup successfully but the I can not restore it. thanks

ansgar's profile image ansgar posted 2 years ago Permalink

For importing an sql file per command line you normally use mysql.exe, from the same folder where you have mysqldump.exe . Here's an example how you use it:

mysql.exe -hlocalhost -uroot testdb < C:\path\to\backup.sql

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