Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

# Autimatic Backup at any DAY

[expired user #7331] posted 9 years ago in Import/Export
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 posted 9 years ago
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] posted 9 years ago
Ok, thanks
Can you send me the syntax for the backup on mysqldump.exe?

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

Myeschool
nortitec posted 1 month ago

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 posted 1 month ago

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