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