If you are a longtime user of mysqldump you may have experienced that restoring with mysql < dumpfile doesn’t always work because of referential problems. Here is a little script that takes care of it: mysql-restore.txt.