Backup the database

# mysqldump --opt -u username -p password -r mydb.dump mydb


Please note: Redirection does not capture UTF characters properly, while the -r option does (--result-file). I found this  [ ... ]

MyISAM is the default storage engine for MySQL. Unfortunately it doesn't support transactions or foreign keys (but it has some other nice features like compression). However, because InnoDB does su [ ... ]