How do I import a MySQL database?

123-reg web hosting icon

This FAQ will help you to import your database onto your Web hosting package.

The below video and step by step instructions will help you to import an existing database you own onto your 123-reg hosting package.

Need to export your database instead? Click to see how to do this.


Log in to your 123-reg control panel

log in to 123-reg account


Scroll down to the Web hosting section.

scroll down to the web hosting section


Select your domain name using the drop-down menu and then click on the Manage button.

select your domain name and click on the manage button


In the Web Tools section, click on MySQL Databases.

click on the databases button


If you haven't already, you will need to create a new database, just choose a username and password and click on the Create button.

create username

Please note: Your username should be 9 characters or less and can only contain letters, numbers and these characters: "_" and "-". It should not contain the words "test", "root", "mysql" nor "alive".


You will now see your database in the Manage MySQL Databases section. Enter your password and click on the Manage button.

click on the manage button


This will open up phpMyAdmin.

open up phpmyadmin


Click on your database in the top left hand corner.

select your database


Now click on the Import tab.

click on import


You can now choose the database you wish to import.

choose the database you wish to import


Ensure that the SQL option is selected.

ensure SQL is selected


Now click the Go button.

click go


You will now see a message stating that the Import was successful.

add a table


Answer options

Your feedback was successfully added.

Answer tracking


Watch the content of this article for changes.