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.
See the next post for using VBScript to dump all databases into separate files and compress them.