How to do automatic mysql db backup using mysql workbench

Question

How to do automatic mysql db backup using mysql workbench?

Is it possible?

Answer 1

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

Answer 2

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

It supports:

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