1. Knowledge Base
  2. >
  3. Results
  4. >
  5. Article

Working with MySQL databases

Create a new MySQL database

  1. Log into your Hosting Dashboard.
    Hosting dashboard
  2. In the left sidebar, click MySQL Management. 
    left sidebar, MySQL Management
  3. Click on Add MySQL Database.
    Add MySQL Database
  4. Name your new database. 
    name your database
  5. Set a new username and password for your new database. Keep the username and database name as close to identical as possible. The username cannot be more than 16 characters long.
    set database username and password
  6. Configure the database privileges.
    configure the database privileges
  7. Save and your new database will be created.

To manage a MySQL database from phpMyAdmin:

  1. Log into your Hosting Dashboard.
    Hosting dashboard
  2. In the left sidebar, click MySQL Management.
    left sidebar, MySQL Management
  3. Click Manage on the database you want to access.
    Manage
  4. Click on phpMyAdmin for the selected database.
    phpmyadmin
  5. You now have access to phpMyAdmin for your database.
    inside phpmyadmin

Backup a MySQL database

To create an on-demand MySQL database backup (all tables):

  1. Log into your Hosting Dashboard.
    Hosting dashboard
  2. In the left sidebar, click MySQL Management.
    left sidebar, MySQL Management
  3. Click Manage on the database you want to access.
    Manage
  4. Then click on phpMyAdmin for the selected database.
    phpmyadmin
  5. With your database selected in the left pane:
    • Click on the Export tab
    • The quick method will export all tables
    • Format SQL and Go
    export database tables
  6. Your database is available for download and other options.
    database ready for download

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

  1. Log into your Hosting Dashboard.
    Hosting dashboard
  2. In the left sidebar, click MySQL Management.
    left sidebar, MySQL Management
  3. Click Manage on the database you want to access.
    Manage
  4. Then click on phpMyAdmin for the selected database.
    phpmyadmin
  5. With your database selected in the left pane:
    • Click on the Export tab
    • Change the Export method to Custom
    • Select the tables you want to Export
    • Change any other Export options
    • Format SQL and Go
    • Your database is available for download and other options.
    back up database

Delete or drop a MySQL database

  1. Log into your Hosting Dashboard.
    Hosting dashboard
  2. In the left sidebar, click MySQL Management.
    left sidebar, MySQL Management
  3. Click the garbage can icon. 
    garbage icon
  4. Verify that you are dropping the selected database, and click Delete 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.

yieldmanager

Thanks for visiting! Since you landed on this page of our website, we wanted to let you know you visited one of our paid endorsers while researching your purchase. close