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.

  [email protected]