Autimatic Backup at any DAY

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

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.

Ok, thanks
Can you send me the syntax for the backup on mysqldump.exe?

thanks

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

ok,
Thanks

Myeschool

[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

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