In the second and final part of our mysqldump best practices we will talk about how to handle the migration and import for stored-program objects and views from your MySQL database. To read more about the prerequisites for a successful dump and restore operation for large MySQL databases, check out the first part of this 2-part blog series.

Importing Your Stored Procedures, Functions, and Triggers

By default, mysqldump imports views, and triggers. However, it does not import procedures, functions, and events. To import procedures and functions, the --routines option should be specified, and to import events, the --events option should be specified.

#mysqldump #datbaase #mysql