Does a MySQL backup save custom functions, events, and queries?

Question

I successfully did a backup of my database, dropped the DB in workbench and created a new one, and attempted to restore it. First, it didn’t restore until I ran the creation of a custom function first (which is something I use in multiple views), and when I did restore it, the event I created wasn’t present.

FUNCTION library.daysout does not exist

I can understand why a query I had open would not be restored (although if you can tell me how to do that, please do,) but how can I make sure my custom function and event restore (especially since the DB doesn’t restore till I run the creation of the function before)?

Please provide enough code so others can better understand or reproduce the problem. — Community
– Community Bot, Commented Aug 7, 2022 at 6:10

Bill Karwin · Accepted Answer · 2022-08-06 20:58:49Z

1

A default database dump or export does not include stored procedures or stored functions by default.

MySQL Workbench has a checkbox to include stored procedures and functions in an export. You have to check this, and it's not checked by default.

This option is shown in the screenshots in the manual here: https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-management.html Although it isn't described clearly in the text.

Likewise if you use the command-line mysqldump tool, you must use the --routines option to include stored procedure and stored function definitions in the export. This option is documented here: https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html#option_mysqldump_routines

answered Aug 6, 2022 at 20:58

Bill Karwin

567k87 gold badges709 silver badges869 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

angryteacup Over a year ago

Thanks! I've been using command line, didn't see the checkbox in workbench. Are events similarly included if we check dump stored procedures and functions?

Bill Karwin Over a year ago

Check the documentation links I gave. The answers are there!

Collectives™ on Stack Overflow

Does a MySQL backup save custom functions, events, and queries?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related