Trainers discussing SQL Server, Oracle and MySQL

MySQL Workbench is an integrated development environment used by DBAs and developers when working with MySQL servers and databases. There are three main areas of functionality: SQL Development, Data Modeling, and Server Administration. In this article, I will show you how to use the Server Administration tool to create a backup for your database.

How to Use the Server Administration Tool in MySQL Workbench

To create a backup, launch MySQL Workbench. Within the Server Administration component, connect to your database.

The list of MySQL Workbench Server Administration tools will be shown. Choose the tab for Data Dump.

Within this Data Dump tool, you can backup specific databases or individual tables.

Creating a Backup for a Single Database

First, here are the steps to create a backup for a single database.

  1. Choose the database you wish to backup by clicking on the checkbox beside it.

  2. Next, specify the destination file of your backup. MySQL Workbench has the advanced feature of letting you decide whether to Export to a Backup Project Folder (each exported table will be written to a separate file) or to Export to Self-Contained File (all exported database objects will be written to a single file). In addition, you can enter the full path name where you want the server to create the file(s).

  3. Start the backup process by clicking on the Start Export Button. MySQL Workbench will show you the progress of the activity.

  4. Finally, MySQL Workbench displays a message whether it has completed the backup or not. Check the logs and take appropriate actions if there are errors.

Creating a Backup for Individual Tables

MySQL Workbench gives you the option to backup individual tables.

  1. To do that, click on the name of the database which contains the table(s) you wish to backup. Note that the tables contained within the database you chose will be displayed on the middle portion of the screen.

  2. From the list of tables, choose those for backup by clicking on the checkboxes.

  3. As before, indicate the destination of the backup file. You can choose the default destination or enter a full pathname.

  4. Once again, click on the Start Export button to start the backup process.

  5. After the tables have been exported, MySQL Workbench will display a message regarding the completion of the process. Check the logs and take appropriate actions if there are errors.

If you want to learn more about creating database backups and other critical administration tasks, please check out our MySQL Administration training. You can also hear about our latest database blogs, classes, and webinars by signing up for our newsletter.

No TweetBacks yet. (Be the first to Tweet this post)

4 Responses to “Creating Database Backups in MySQL Workbench”

  1. Thanks it really helped..

  2. Will this move the table to my chosen destenation or will it just create a back up, my version of mySQL workbench is slightly different. Other than taht really helpful thanks a lot.

  3. I’ve been searching EVERYWHERE online for this!!!
    Thank you so, so , so much!

  4. Great post, really helped! Thank you!


Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

© Webucator, Inc. All rights reserved. | Toll Free: 877-932-8228 | UK: 0808-101-3484 | From outside the USA: 315-849-2724 | Fax: 315-849-2723