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.
Step 1 of 13
Log in to your 123 Reg control panel
Step 2 of 13
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.
Step 4 of 13
In the Web Tools section, click on MySQL Databases.
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.
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.
Step 7 of 13
This will open up phpMyAdmin.
Step 8 of 13
Click on your database in the top left hand corner.
Step 9 of 13
Now click on the Import tab.
Step 10 of 13
You can now choose the database you wish to import.
Step 11 of 13
Ensure that the SQL option is selected.
Step 12 of 13
Now click the Go button.
Step 13 of 13
You will now see a message stating that the Import was successful.