distal-attribute
distal-attribute
distal-attribute
distal-attribute

# Autimatic Backup at any DAY

myeschool posted 3 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 3 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.
myeschool posted 3 years ago
Ok, thanks
Can you send me the syntax for the backup on mysqldump.exe?

thanks
ansgar posted 3 years ago
mysqldump.exe -hYourIpOrHost -uYourUserName -pYourPassword yourdatabase >c:\path\to\backupfile.sql
myeschool posted 3 years ago
ok,
Thanks

Myeschool