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 here to see how to do this.



1

Log in to your 123-reg control panel

log in to 123-reg account

2

Scroll down to the Web hosting section.

scroll down to the web hosting section

3

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

4

In the Web Tools section, click on MySQL Databases.

click on the databases button

5

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".


6

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

7

This will open up phpMyAdmin.

open up phpmyadmin

8

Click on your database in the top left hand corner.

select your database

9

Now click on the Import tab.

click on import

10

You can now choose the database you wish to import.

choose the database you wish to import

11

Ensure that the SQL option is selected.

ensure SQL is selected

12

Now click the Go button.

click go

13

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

add a table

Offer

Answer options

Your feedback was successfully added.

Answer tracking

Track

Watch the content of this article for changes.