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.

mysqldump Best Practices

• Part 1 – MySQL Prerequisites
• Part 2 – Migrations Guide

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.

#mysql #mysqldump