Loading...

Knowledge Base
Home 
 
/
 Working with MySQL databases
Categories: MySQL

Working with MySQL databases

Create a new MySQL database 

  1. Log in to your Account Manager. 
  2. Select Hosting, then MANAGE on the right where you're hosting that you wanted to configure.
  3. In the left sidebar, click MySQL Management.

    sql config

  4. Click on Add MySQL Database.

    sql config

  5. Name your new database.

    scripting config

  6. 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.

    scripting config

  7. Configure the database privileges.

    scripting config

  8. 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, e-commerce, and store the name should be self-explanatory 
    • Database name should not be more than 64 characters 
    • Avoid using prefix 

    To manage a MySQL database from phpMyAdmin: 

  9. Log in to your Account Manager. 
  10. Select Hosting, then MANAGE on the right where you're hosting that you wanted to configure.
  11. In the left sidebar, click MySQL Management.

    scripting config

  12. Click Manage on the database you want to access.

    scripting config

  13. Click on phpMyAdmin for the selected database.

    scripting config

  14. You now have access to phpMyAdmin for your database.

    scripting config


    Backup a MySQL database 

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

  15. Log in to your Account Manager. 
  16. Select Hosting, then MANAGE on the right where you're hosting that you wanted to configure. 
  17. In the left sidebar, click MySQL Management.

    scripting config

  18. Click Manage on the database you want to access.

    scripting config

  19. Then click on phpMyAdmin for the selected database.

    scripting config

  20. With your database selected in the left pane: 

    • Click on the Export tab 
    • The quick method will export all tables 
    • Format SQL and Go 

  21. Your database is available for download and other options.

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

  22. Log in to your Account Manager. 
  23. Select Hosting, then MANAGE on the right where you're hosting that you wanted to configure. 
  24. In the left sidebar, click MySQL Management.

    scripting config

  25. Click Manage on the database you want to access.

    scripting config

  26. Then click on phpMyAdmin for the selected database.

    scripting config

  27. 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

      scripting config

    • Your database is available for download and other options.

      scripting config

    Delete or drop a MySQL database

  28. Log in to your Account Manager. 
  29. Select Hosting, then MANAGE on the right where you're hosting that you wanted to configure.

    scripting config

  30. In the left sidebar, click MySQL Management.
  31. Click the garbage can icon.

    scripting config

  32. 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: 

Loading...