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

Working with MySQL databases


Create a new MySQL database

  1. Log in to your Hosting Dashboard.
    Dashboard
  2. In the left sidebar, click MySQL Management. 
    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.

Database Naming Pro Tips

  • Use lowercase - this will help avoid mistakes due to case-sensitivity.
  • No spaces - use underscore instead
  • No numbers - use only alpha English characters
  • Use valid understandable names like blog, wordpress, ecommerce, store Name should be self-explanatory
  • Database name should not be more than 64 characters
  • Avoid using prefix

To manage a MySQL database from phpMyAdmin:

  1. Log in to your Hosting Dashboard.
    Dashboard
  2. In the left sidebar, click MySQL Management.
    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 in to your Hosting Dashboard.
    Dashboard
  2. In the left sidebar, click MySQL Management.
    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
    back up database
  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 in to your Hosting Dashboard.
    Dashboard
  2. In the left sidebar, click MySQL Management.
    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.
      Inside phpmyadmin



Delete or drop a MySQL database

  1. Log in to your Hosting Dashboard.
    Dashboard
  2. In the left sidebar, click MySQL Management.
    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.


Related Articles:

Chat
Close