May 08 2013

Mysql Stored Procedures Backup

Published by at 6:49 pm under Mysql

Be aware while backing up Mysql databases: triggers are included by default but NOT the stored procedures/functions.
Do not forget to add the –routines switch when running a backup.

mysqldump -u user -p my_database --routines backup.sql

Check your backup scripts before running into a disaster recovery.

No responses yet

Trackback URI | Comments RSS

Leave a Reply