Reputation: 23317
How to do automatic mysql db backup using mysql workbench?
Is it possible?
Upvotes: 6
Views: 33188
Reputation: 66
If you have a webserver with PHP I'd suggest MySqlDumper
It supports:
Upvotes: 5
Reputation: 2075
ATM scheduled backups are not plannned in Workbench: http://bugs.mysql.com/bug.php?id=50074
At the same time Workbench is designed to have powerful scripting shell, so you can try to investigate what commands can be used for backup and call them directly from shell. (But I agree this is too general idea):
http://dev.mysql.com/doc/workbench/en/wb-extending.html
Upvotes: 1
Reputation: 47331
Mysql bench is not required for automatic backup,
setup a crontab and use mysqldump (or equivalent) will do the same job and is easier.
example:
crontab -e
/* backup every day at 00:00:00 */
0 0 * * * mysqldump -u root -ppassword YOUR_DATABASE > /backup/YOUR_DATABASE.sql
Upvotes: 10