Import a MySQL database

Category: Databases, Web Hosting / Design
Tagged: , , .
Print This Post Print This Post

MySQL database support is only available for Business Hosting subscriptions or higher.

Import a MySQL database using phpMyAdmin

  1. Login to the Account Level console using the Master Account Reference and Password.
  2. Locate the section Administer/Upgrade domain.
  3. Search for or select the required domain from the Select domain dropdown list.
  4. Click [Administer].
  5. Click the Database icon.
  6. Click the name of the database into which the backup is to be imported.
  7. Select the SQL tab.
    SQL Tab in phpMyAdmin
  8. Click on [Browse].
    phpMyAdmin
  9. Select the .sql file from your computer:
    If using a .sql file, select the None radio option.
    If uploading a compressed sql file, select the Autodetect radio option.
  10. Click [Open].
  11. Click [Go].

If importing a large database, phpMyAdmin may not have enough memory to handle your request. We recommend using a local MySQL client such as EMS SQL Manager Lite for MySQL if phpMyAdmin can’t handle the size of your database.

Import a MySQL database using EMS SQL Manager Lite for MySQL

The below steps utilise free SQL Management software. You can download this software at the developers website then install it on your local computer. The below steps are accurate as of version 4.6.0.5

Please note that these steps are provided for your convenience, as this software is not sold by Netregistry, we are unable to provide technical support on its use.

Register an existing database

  1. Open EMS SQL Manager Lite for MySQL
  2. Click the Register Database icon. register database
  3. Type the database host name in the Host Name. e.g. mysql.netregistry.net, mysql-2.netregistry.net, mysql-3.netregistry.net, or mysql-4.netregistry.net depending on which server the database is on.
  4. Type the username and password into the database.
  5. Click [Next].
  6. Type in the name of the database in the Database Name field.
  7. Click [Finish].

Restore .sql file into a registered database

  1. Navigate to the Databases column located in the left most panel.
  2. Right click on the database you wish to import into.
  3. Click Connect to Database.
  4. Click on the Show SQL editor icon.
  5. Underneath the Edit heading, click on Load from file.
  6. Select the .sql file from your computer and click [Open].
  7. Underneath the General heading, click Execute.

 

Related Articles