In order to back up IPV MySQL databases, whether it’s to provide to Support or use as a fallback for an upgrade, the following is best practice:
- Open MySQL Workbench.
- Double-click and connect to the relevant instance.
- From the Server tab at the top, choose Data Export.
- Within the Object Selection tab, check the relevant schema.
-
Objects to Export
- Dump Stored Procedures and Functions
- Dump Events
- Dump Triggers
-
Objects to Export
- From Export options, select Export to Self-Contained File.
- Choose a file path.
- Ensure the Create Dump in a Single Transaction option is checked.
For an extra level of security, you may wish to also export the dump folder of individual tables.
- To do this, simply select the Export to Dump Project Folder under Export options.