By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,890 Members | 1,039 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,890 IT Pros & Developers. It's quick & easy.

Migrate mysql server

P: 28
How do I migrate (copy) mysql database to another server/machine.
Feb 19 '08 #1
Share this Question
Share on Google+
2 Replies


randome
P: 6
Hi,
use mysqldump command
Feb 19 '08 #2

Markus
Expert 5K+
P: 6,050
If you are using phpmyadmin, you can go to any table you have created and then use the 'export' link at the top.

Make sure SQL is checked in the next page you come to, and then carry on.
It will give you a load of code; copy this and then go to your new servers phpmyadmin.

Open up the 'SQL' tab and then paste the code into the textarea.

Query it, and you're done!

But then again, if you're not using phpmyadmin (shock) this isn't very helpful :P
Feb 19 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.