Databases menu

This is the section for database creation, deletion and management. You can create MySQL databases and this is needed for most CMSs such as Drupal, Joomla! or WordPress. You can manage your database with phpMyAdmin. Remote access is NOT provided and you need to upgrade to a premium account to gain Remote MySQL access
databases section

MySQL Databases

You can only create MySQL databases. Only MyISAM is supported. InnoDB is NOT supported. For InnoDB you need to upgrade to paid hosting. For other databases you need to upgrade to paid hosting.

To create a MySQL database, follow these instructions:

  1. login to your control panel
  2. click in MySQL Databases (image 2)
  3. write a name for your database and press Create button
    create database form
  4. Your final database name will be similar to mipc_12345678_yourname
    check database name
  5. your database username is your control panel username, similar to mipc_12345678
  6. you cannot change the database username
  7. you cannot change your database user permissions
  8. you cannot access you database remotely

WARNING: Be careful and do not click in the Delete button because as soon as you click in it your database will be immediately deleted.

Before deleting a database make sure you have a back up copy in your computer.

To delete a MySQL database, follow these instructions:

  1. login to your control panel
  2. click in MySQL Databases (image 5)
  3. select in the Delete drop down menu the database you want to delete
    delete database form
  4. Press the Remove Database button

WARNING: Be careful with the Delete button. You will notice that a database is already selected in the Delete drop down menu. If you involuntarily click in the Delete button you will lose your database and this action is not reversible. As you click in it, your database will be instantly deleted without any further confirmation, notification or pop-up interaction.

Before deleting a database make sure you have a back up copy in your computer.

phpMyAdmin

If you have a database you can browse and manage it with the visual interface phpMyAdmin.

To manage a MySQL database, follow these instructions:

  1. login to your control panel
  2. click in phpMyAdmin (image 7)
  3. if you only have one database, you will see a white, empty control panel window during 5 seconds (image 8)
    white empty control panel
  4. if you have more than one database, click in Connect now to the right side of the database you want to manage
  5. a new browser tab will open with the database user interface (image 9)
    phpmyadmin database browser
  6. if you don’t feel comfortable performing database operations, then don’t even touch the database

WARNING: If you dare, you can start managing your database, but make sure you previously have a back up copy of your database in your computer.

Are you migrating from a different web host? Do you have a database already? Here is how you can upload your database to the MySQL server.

To import a MySQL database you should:

  1. login to your control panel
  2. click in phpMyAdmin (image 10)
  3. if you only have one database, you will see a white, empty control panel window during 5 seconds (image 11)
    white empty control panel
  4. if you have more than one database, click in Connect now to the right side of the database you want to manage
  5. a new browser tab will open with the database user interface (image 12)
    phpmyadmin database browser
  6. in the top navigation bar click in Import (image 13)
    phpmyadmin import tab
  7. now click in the Browse button and select your db file (image 14)
    import database form
  8. finally scroll down and click in Go button
  9. depending on the size of your sql file this may take some time

Attention: You can upload files such as .sql and .sql.zip and others with a file size limit of 25 MB.

To backup a MySQL database, follow these instructions:

  1. login to your control panel
  2. click in phpMyAdmin (image 15)
  3. if you only have one database, you will see a white, empty control panel window during 5 seconds (image 16)
    white empty control panel
  4. if you have more than one database, click in Connect now to the right side of the database you want to manage
  5. a new browser tab will open with the database user interface (image 17)
    phpmyadmin database browser
  6. in the upper horizontal navigation bar, click in Export (image 18)
    phpmyadmin export tab
  7. in the new screen click in Go button (image 19)
    export database form
  8. this will let you download to your computer a full copy of your database and the extension of the file will be .sql

Important: You can download the file in a .zip format. For this, you have to select Custom, scroll down and select zip format in the drop-down menu.

Remote MySQL

This service is not available in free hosting. You need to upgrade to a premium account to obtain Remote MySQL access (image 20)

If you click the Remote MySQL icon, you’ll see the following (image 21)
remote mysql

It says:

Remote MySQL allows you to connect to the MySQL databases on your hosting server here from another server or computer.
Free hosting plans do not support remote MySQL connections, to get this extra functionality please order a premium hosting plan.