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

Autimatic Backup at any DAY

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

thanks
ansgar posted 1 year ago

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

myeschool posted 1 year ago
ok,
Thanks

Myeschool

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