Working with MySQL databases

To create a new MySQL database:

1. Log into your hosting control panel, and navigate to MySQL manager

2. In the left pane, click Add Database icon. An Add Database dialog is displayed.

3. Enter the database name, username, and password. The database is created for you, with the username and password applied to the first user.

Note: If you cannot see your newly created database, click the Refresh icon in the left pane

Access phpMyAdmin for a MySQL database

To manage a MySQL database from phpMyAdmin:

1. Log into your hosting control panel, and navigate to MySQL manager

2. In the left pane, select a database which you wish to manage

3. In the right pane, for the selected username, click the Access icon. You are brought to the phpMyAdmin page, from which you can manage the selected database.

Backup a MySQL database

Important: InnoDB database users will need to back up their database manually.

To create an on-demand MySQL database backup:

1. Log in to your hosting control panel, and navigate to MySQL manager.

2. Click the Manage Backups tab

3. From the list of databases on the left, select a database that you want to create an on-demand backup for. The various versions of this database will appear on the list in the right pane, under Available Database Backups

To schedule an on-demand full database backup (all tables):

1. From the list in the right pane, select the database that you want to use. Scroll all the way down. The message, "Your Database/Tables are currently being prepared" will appear below the selection.

2. Scroll down to the Status column. Here, the database first needs to be converted. Afterwards, it will be ready for download.

3. Refresh the page periodically by clicking the Refresh icon.

4. When the Status column contains a Download link, the backup is complete and ready for download.

To schedule specific tables in a database for an on-demand backup

1. From the list in the right pane, select the database and expand it by clicking the "+" icon. A list of tables in the database is displayed.

2. Select the tables that you want to back up.

3. Scroll to the end of the list of tables and click Select Tables. The message, "Your Database/Tables are currently being prepared" will appear below the selection.

4. Scroll down to the Status column. The tables first need to be converted. Afterwards, they will be ready for download.

5. Refresh the page periodically by clicking the Refresh icon

6. When the Status column contains a Download link, the backup is complete and ready for download.

Delete or drop a MySQL database

To drop or delete a MySQL database:

1. Log into your hosting control panel, and navigate to MySQL manager

2. In the left pane, select the MySQL database you wish to drop

3. In the right pane, click the Drop Database icon. The verification dialog is displayed.

4. Verify that you are dropping the selected database, and click Drop Database.

Warning: Once a database is dropped, this action is irreversible, and all data stored in the database is lost

Can't schedule a MySQL database backup

Problem: When you go to the MySQL Beta -> Manage Backups tab, and click a database name to schedule it for backup, nothing happens.

Why is this happening: The server is trying to post an error, and it's not being displayed. The error says: Server is busy. Please try again later.

Solution: Please try to schedule your database backup later.