Google Answers Logo
View Question
Q: MYSQL ( Answered,   0 Comments )
Subject: MYSQL
Category: Computers > Internet
Asked by: don21-ga
List Price: $15.00
Posted: 24 Sep 2003 06:46 PDT
Expires: 24 Oct 2003 06:46 PDT
Question ID: 259710
What program can I use to move My database from one server to another. (MySql)

Request for Question Clarification by hummer-ga on 24 Sep 2003 07:37 PDT
Hi don21,

Are you comfortable using "mysqldump"? Have a look at this forum

Dev Shed Forums > Databases > MySQL > Moving a database to a different

"I ended up using "mysqldump" which is a very elegant solution.

I just typed in "mysqldump [databasename] > [file.txt]." That created
a file with all the sql statements required for setting up each table
and populating it.

I then ftp'd it to my new server, and ran the script. The whole think
took less than 5 minutes. Awesome!"

Subject: Re: MYSQL
Answered By: andyt-ga on 24 Sep 2003 08:52 PDT
Hi don21-ga,

There are several options for doing what you want to do.  Using
mysqldump is certainly one option, but I'm not sure if you need 'root'
access to the server in order to install this tool.  Certainly you'll
need shell access, and sometimes with shared hosting enviroments this
isn't provided.  The way I've done it in the past is using the PHP and
MySQL management tool, phpmyadmin.

First download the latest phpmyadmin 2.5.3 from
 Then unzip/untar the files into a directory called phpmyadmin on the
server containing the database info you want to transfer.  Edit the
configuration file provided with phpmyadmin with your username and
password, and you should be good to go.

Next, navigate to the phpmyadmin directory with a web browser, and
click on the name of the database you want to transfer (on the left). 
Now click on the tab at the top called 'export', make sure the data
button is checked as well as the structure button.  Now click 'go'. 
What you're provided with is all the data in your database in the
window, which you can copy and paste into the new server.  Phpmyadmin
also gives you the option to save this information as a file, which
might be useful for bigger databases.

To import this information to the new server, follow the instructions
above for installing phpmyadmin and click on the 'SQL' at the top of
the phpmyadmin screen.  Paste your database data into the big box, or
locate the file holding the data and upload it.

As a word of caution, you'll want to password protect this phpymadmin
directory, or delete it after you are done with these tasks so as to
make it inaccessible to anyone but yourself.

If you need any clarification, please don't hesistate to ask for a

There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy