How to Transfer MySQL Database to Network Solutions
Changing hosting providers for a database-driven website and migrating your database to the new provider is a somewhat daunting task if handling a large database. When migrating one MySQL database to another, there are several steps you can take to ensure a fast and easy migration. Popular hosting service providers, such as Network Solutions, offer phpMyAdmin, an SQL administration tool that allows for a smooth transition.
Other People Are Reading
Instructions
-
-
1
Log in to your current website's administration panel and click the link for phpMyAdmin.
-
2
Select the existing database you wish to migrate to the new site in the drop-down menu on the left side of the screen.
-
-
3
Click on the "Export" tab.
-
4
Select "SQL" under the Export section and choose your custom options on the right. Click on "Go" to generate the SQL script.
-
5
Select the SQL script that appears and press "Ctrl" plus "C" to copy.
-
6
Go to the Network Solutions site. Click on the Manage Account tab, and log in to your account.
-
7
Click on "nsHosting (Web Hosting)," then the "Configurations" icon. Select the "Database Manager" icon.
-
8
Click on the "Add" button and enter the name of your database. Enter the desired user name and password to access it.
-
9
Click on the "Admin" button next to the database name and log in to phpMyAdmin.
-
10
Select the database name on the left side and click on the SQL tab.
-
11
Paste your SQL text and click on "Go." A message to confirm that tables and data have been copied will appear.
-
1
References
- Photo Credit deep in database image by .shock from Fotolia.com
