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.