Select Page
This entry has been published on 2012-06-13 and may be out of date.

Last Updated on 2012-06-13.

MySQLDump doesn’t create a full backup of a whole database by default. If you use MySQL triggers, views, events etc., they are not dumped.

Use these parameters for including everything:

mysqldump –routines=true –triggers=true –events=true -u backup -pBackupPW –result-file=meow.sql testdb

Don’t give the database backup user too much permissions. Basically, it only needs to select data without writing anything.

In phpMyAdmin:

 

See the next post for using VBScript to dump all databases into separate files and compress them.