From the Export Option section, select the format for the exported data.From the Data Export tab in the Tables To Export section, select the databases and tables that will be added to the backup file.Go to the Administration tab, on the Navigation panel (on the left by default).To create a backup using MySQL Workbench follow these steps: This application also allows you to create logical backups of a MySQL database.
MySQL Workbench is a tool for visual design and it works with a MySQL database. sql file if you need to change something before restoring.įor more information, see mysqldump documentation. Thus, switching to another version of MySQL can be done without worrying about backups.
It is easy to restore a MySQL database from a file created by mysqldump. This command-line utility creates a backup file with a set of commands to recreate the database. When installing a MySQL server, the main backup utility is automatically installed – mysqldump.
How to create a logical MySQL backup Simple backup of MySQL database using mysqldump This is useful when different backup strategies are applied to different data.
This article is limited to MySQL database backups for a Microsoft Windows Server only.
Because there are several ways to backup MySQL database on Windows, this article will review all the different options so that you can select the method that works for you.