Archive for the tag 'Stored Procedure'

 

 

May 08 2013

Mysql Stored Procedures Backup

Published by 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