MySQL

  1. What is MySQL? #

    MySQL is an open source, relational database that can be used in conjunction with scripting languages like PHP

  2. What version of MySQL are you running? #

    All new databases that are created run on MariaDB 10 (MySQL 5.5 Compatible).

    If you have databases running an older version of MySQL and you want to upgrade, please submit a help desk ticket

  3. How do you create a MySQL database? #

    MySQL databases can be setup using the control panel under “Features”.

    The cloud will add 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 or in any config file reference.

  4. How do you access phpMyAdmin to manage a MySQL database? #

    You can manage your database(s) using phpMyAdmin, which can be accessed through your control panel.

    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 MySQL cluster from the drop-down list. Here’s how to locate the correct MySQL cluster:

    1. Log into your control panel
    2. Click on the domain
    3. Click on the Features tab
    4. Under the Databases section, click on the database name
    5. Next to Hostname, note the first string of characters in the stabletransit.com address. For example, mysql50-11.wc1.dfw1.stabletransit.com. This first part is the MySQL 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, contact us through the Help Desk about how to import larger data files into the database.

  5. How do I migrate a database into the Cloud using phpMyAdmin? #

    We have a tutorial with step-by-step instructions on how to migrate a database. If you encounter any errors or have questions about this process, please feel free to open a help desk ticket.

  6. What hostname should be used to call out a MySQL database from a script? #

    The hostname for connecting to a database can be found by logging into the control panel. Also be sure to check that you are using the correct “database name”, “username” and “password”.

  7. How much are additional MySQL databases and how do you add one? #

    Additional MySQL databases are $1.00 each per month. If you need to add another MySQL database to one of your domains, please enter a support ticket through our Help Desk.

    NOTE: The maximum amount of MySQL databases allowed per domain is 5.