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

Autimatic Backup at any DAY

User, date Message
Written by myeschool
11 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
11 months ago
5023 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
11 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
11 months ago
5023 posts since Fri, 07 Apr 06

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

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

Myeschool
 

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