This article describes several ways to manage MySQL databases.

HostPilotĀ® Control Panel query tool
To manually manage MySQL databases, you need to log on to your HostPilot account, then navigate to MySQL > Commands page. There you can use standard MySQL commands to manage your database.


For example, if you would like to see your database tables, you can execute the following command:
            show tables

Inside this shell, you can run any SQL command against the database server. Please consult MySQL documentation for more information.

phpMyAdmin tool
To access and manage your MySQL databases via the phpMyAdmin server side tool, please load the tool from HostPilot > MySQL > phpMyAdmin page or directly at http://mysqladm.serveronline.net/, select your server from the Server Choice drop down list, type your MySQL login and password, and click the GO button. You can find your server name on HostPilot > MySQL > phpMyAdmin page.


For detilaed in formation on using the tool, pelase refer to its documentation.

Note

There is a 50MB filesize limit in the Import section of phpMyAdmin. If you find that you are unable to upload your backed-up SQL file to phpMyAdmin because the file is too large (even after zipping it) there are few options you could try:

  1. Using a better compression algorithm. Zip is fairly good but there are better alternatives. GZip and BZip2 are good choices that should give you considerably lower file sizes (and phpMyAdmin understands them too). If you need a utility that can compress to gzip or bzip you could try 7zip.
  2. Split your SQL. As most MySQL files are raw SQL commands that create database structure then import data to it, sometimes these can easily be split into multiple files and uploaded in order (i.e. sql_part1.sql, sql_part2.sql). This may be combined with the above GZip method if the database is very large.
  3. If this is a full database backup, you may consider uploading via MySQL > Databases section of HostPilot. If it is a backup originally generated by HostPilot, no problems should be encountered.

 

Client based applications
While we provide a way to manage your MySQL Database via HostPilot, you may opt to use client based applications to manage your MySQL databases such as MySQL Workbench and many others. These programs simply connect to the MySQL server and allow you to manage the database though their visual interface. To be able to connect, you'll have to specify your credentials as well the server and database names, which you can find on HostPilot > MySQL > Databases page. Port to be used is 3306.