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

Autimatic Backup at any DAY

User, date Message
Written by myeschool
9 months ago
Category: Import/Export
3 posts since Wed, 16 Oct 13
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
Written by ansgar
9 months ago
4936 posts since Fri, 07 Apr 06
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.
Written by myeschool
9 months ago
3 posts since Wed, 16 Oct 13
Ok, thanks
Can you send me the syntax for the backup on mysqldump.exe?

thanks
Written by ansgar
9 months ago
4936 posts since Fri, 07 Apr 06

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

Written by myeschool
9 months ago
3 posts since Wed, 16 Oct 13
ok,
Thanks

Myeschool
 

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