Just found a gotcha with the current version. mysqldump requires "-R" to include stored procs into the dump. It doesn't currently do so. I think this should be the default behaviour since it's vital to a full restore of a database.
wipe_out: Happy to submit a patch adding this as extra option, any preference on naming?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Just found a gotcha with the current version. mysqldump requires "-R" to include stored procs into the dump. It doesn't currently do so. I think this should be the default behaviour since it's vital to a full restore of a database.
wipe_out: Happy to submit a patch adding this as extra option, any preference on naming?
no idea what it should be called. I added "-routines " to OPT over a year ago.
OPT="-routines -single-transaction -quote-names -opt"
YES - I'm adding it to my update.