Lounge Network - Knowledge Base

  View Printer Friendly Version Search
KNOWLEDGE BASE HOME » 16. INFORMATION: DATABASE QUESTIONS Viewing Answer
How do I move a MySQL database from my old host, to your servers?
Moving databases from one provider to another is a relatively simple process. Below is a brief description of how to do this. Your designer or developer should be able to process this for you.

Exporting from phpMyAdmin with your old provider:
Open your phpMyAdmin console with your current hosting provider.
On the welcome screen you will see an Export option click on this link. (Make sure to select the version of MySQL on our servers, incase there are any differences in the versions)
This will bring up the view dump (schema) of databases screen
Select the tables you wish to be exported from the list
Ensure you choose SQL as the option (this will allow you to just paste the SQL in your phpmyadmin console on our servers)
This will now create text file on the screen, highlight the information and paste it into a text document. Save this until you are ready to import it into the phpMyAdmin console on our server.

Import into phpMyAdmin on our servers:
Open your phpMyAdmin, which you can access from within your hosting control panel. This will be under the 'MySQL Databases' section of the control panel.
On the welcome screen you will see an Query window option (lower left corner) click on this link
Paste the contents of the text file that you exported and done. Your database and it's contents are moved.

KNOWLEDGE BASE HOME » 16. INFORMATION: DATABASE QUESTIONS Viewing Answer




Knowledgebase Manager

© Copyright Lounge Network 2001-2017