Does not dump or restore routines/procedures

[khaytsus]

I used this yesterday to fix a 8G ibdata1 file that I couldn't sort out what was causing it and lost all of my procedures and several of my databases used them. Luckily I realized what was going on and was able to dig them out of the setup sql for various things and import them.

[uberhacker]

@khaytsus: Sorry about your mishap. Can you please explain more clearly how you resolved your issue? @cmanley, is this something we need to test a bit more?

[khaytsus]

Most programs that have databases have sql files that you use to import when you set them up and in this case I dug those out and cleaned out everything except the procedures and imported that like importing any sql file into that database.

It was a pretty easy fix, but wasn't too obvious until I realized the app (ZoneMinder) was logging errors because it couldn't run some procedures.

[cmanley]

Perhaps adding the --routines option to mysqldump will solve it. See http://www.logikdev.com/2011/03/01/how-to-dump-mysql-functions-and-stored-procedures/