Wern Ancheta
Wern Ancheta

Reputation: 23317

How to do automatic mysql db backup using mysql workbench

How to do automatic mysql db backup using mysql workbench?

alt text

Is it possible?

Upvotes: 6

Views: 33188

Answers (3)

nathan kelly
nathan kelly

Reputation: 66

If you have a webserver with PHP I'd suggest MySqlDumper

It supports:

  • Automatic backups
  • Emails backups
  • Compresses backups
  • Rotates backups
  • etc.

Upvotes: 5

noonex
noonex

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

ajreal
ajreal

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

Related Questions