Database information in the cloud is stored in clusters and the cloud will append a number to the front of your created database name/username (e.g. 402464_dbcloud). Use this “numerical prefix_name” format for the database name/username when logging into phpMyAdmin.
When logging into phpMyAdmin, you’ll also need to select the correct database cluster from the drop-down list. Here’s how to locate the correct MariaDB cluster:
- Log into your control panel
- Click on the domain
- Click on the Database heading to display the databases for that domain
- Under the Databases section, you’ll see the hostname listed.
- Next to Hostname, note the first string of characters in the stabletransit.com address. For example, mariadb-l50-11.wc1.dfw1.stabletransit.com. This first part is the MariaDB cluster that you would choose from in the drop-down list when logging into phpMyAdmin
Check out the phpMyAdmin documentation for more info.
phpMyAdmin can be used to import .sql files up to 20MB in size. If you are trying to import an .sql file that is larger than 20MB, just submit a support ticket about how to import larger data files into the database.