How do I import a MySQL database?

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.

  • Step 1 of 13

    Log in to your 123 Reg control panel

  • Step 2 of 13

    Scroll down to the Web hosting section.

    scroll down to the web hosting section

  • Step 3 of 13

    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

  • Step 4 of 13

    In the Web Tools section, click on MySQL Databases.

    click on the databases button

  • Step 5 of 13

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

  • Step 6 of 13

    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

  • Step 7 of 13

    This will open up phpMyAdmin.

    open up phpmyadmin

  • Step 8 of 13

    Click on your database in the top left hand corner.

    select your database

  • Step 9 of 13

    Now click on the Import tab.

    click on import

  • Step 10 of 13

    You can now choose the database you wish to import.

    choose the database you wish to import

  • Step 11 of 13

    Ensure that the SQL option is selected.

    ensure SQL is selected

  • Step 12 of 13

    Now click the Go button.

    click go

  • Step 13 of 13

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

    add a table