How to Backup or Restore a MySQL database on Everleap.com using MySQL Workbench.

Overview

MySQL Workbench can back up your Everleap MySQL database to a .sql file on your own computer, and restore that file back into the database. This article covers both directions. You need MySQL Workbench installed locally and a connection to your Everleap MySQL database.

Before you start: your connection details

Everything Workbench asks for is on your database's page in the Control Panel.

Log in to the Everleap Control Panel at cp.everleap.com.
From the top menu click Databases, then Shared MySQL.

The MySQL Databases page listing databases with columns Database Name, Version, Usage and Manage, and a Create MySQL Database button

Click Manage next to your database.

The General Information panel gives you the Database Server to connect to, in the form my##.everleap.com, and the Database User. The password is masked, with an Edit link if you need to set a new one. The database name itself is the one shown in the list on the previous page.

The MySQL Database Overview page showing the General Information panel with Database Version, Database Server, Database User, Database Password and Disk Space Quota

For the connection itself, see How to Connect to MySQL using MySQL Workbench.

Backing up your MySQL database

Connect to the MySQL database in MySQL Workbench.
Click on Data Export under the Management section.
Place a check next to your MySQL database in the Data Export section.
Select Export to Self-Contained File and select a path where you want to place your .sql file on your local computer.
Select what options you want to use in the "All selected database objects will be exported into a single, self-contained file" section.
Click the Start Export button.

Note: Dump Events is not allowed in our environment.

Verify it worked

Once the export completes, the MySQL backup will be on your local computer in the path you selected.

Restoring your MySQL database

Connect to the MySQL database in MySQL Workbench.
Click on Data Import/Restore under the Management section.
Select Import from Self-Contained File and select the path to the .sql file stored locally on your computer.
For Default Target Schema, click the drop down menu and select your MySQL database name.
Click the Start Import button to restore the MySQL database.

Note: if you are restoring from a MySQL database with a different name to the Everleap MySQL database, you must open your .sql file with a text editor such as Notepad and change the MySQL database name to the MySQL database name you are using on Everleap. Otherwise you will receive a permissions error.

Article ID: 1280, Created: 5/10/2014 at 9:49 PM, Modified: Yesterday at 7:21 PM