Making a MySQL database backup with MySQL Workbench

Discussion in 'Tutorials' started by mjp, Dec 20, 2010.

  1. mjp

    mjp DiscountASP.NET Staff

    Making a backup in MySQL workbench is a pretty easy task, but it can be hard to find exactly where to do it the first time around. Typically when you're working in MySQL Workbench you will be using the SQL Development section. But in order to export a backup you have to move to the Server Administration section.

    [​IMG]




    The first time through you will have to Create A New Server Instance. If you have already set up the connection parameters in the SQL Development section, you can just choose Take Parameters from Existing Database Connection.

    [​IMG]




    MySQL Workbench will then test the connection.

    [​IMG]




    In the "Remote Management Type" dialog, select Do not use remote management.

    [​IMG]




    Create Instance Profile is just asking you for a name for the connection. You can enter whatever you'd like here.

    [​IMG]




    When you make the connection in the Server Administration section you will see a notice that remote administration is disabled. But don't worry, you can still make a backup of your database.

    1. Click the Data Dump tab to access the export utility.
    2. Check the box for the database you want to back up
    3. Choose Export to Self-Contained File and make sure the path is correct.
    4. Hit the Start Export button.

    [​IMG]



    When the export is complete the backup will be on your local machine in .sql format.
     

    Attached Files:

Share This Page