How to back up MySQL Schemas

Updated on December 8th, 2022

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:

  1. Open MySQL Workbench.
  2. Double-click and connect to the relevant instance.
  3. From the Server tab at the top, choose Data Export.
  4. Within the Object Selection tab, check the relevant schema.
    • Objects to Export
      • Dump Stored Procedures and Functions
      • Dump Events
      • Dump Triggers
  5. From Export options, select Export to Self-Contained File.
    1. Choose a file path.
    2. 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.
Was this article helpful?