Moving MySQL db's - GoFuckYourself.com

Ted · 05-20-2002, 05:19 AM

I'm moving servers and need to move several databases

Can anyone point me to some tutorials to make this as easy and pain free as possible ?

Terenzo · 05-20-2002, 05:22 AM

just dump the databases and recreate them on the new server - if you are using a tool like phpMyAdmin, then it is easy unless your db's are of a kind i dont know about...

Mr.Fiction · 05-20-2002, 05:30 AM

If it's a large database, I don't know how well PHPMyAdmin will do with dumping it. I would do it using telnet if I was you. Just dump it to a directory, then copy it to your new server and recreate it there.

Looking.... I just found it. Here is a detailed page on how to move a MySQL database from one server to another:

http://www.vbulletin.com/manual/movingservers.html

Ted · 05-20-2002, 06:06 AM

Thanks mr fiction

that should be enough to get me started, I'll bumble my way through learning as i go.

Tipsy · 05-20-2002, 06:22 AM

Just moved a server with a load of MySQL stuff on it. We used phpmyadmin as it made life soooo much easier.

kicks · 05-20-2002, 07:25 AM

Ted
A lot of the better hosting companies out there will move your db's for you if you ask. If you have a cut rate host who only wants to hear from you when you send money then the advice others have given is at least on the right track.
I know I recently moved some db's from one server to another and I just asked my host to do it and a few minutes later it was done. Call me lazy if ya want

kicks

Midnight · 05-20-2002, 01:10 PM

You would have to use mysqldump in order to dump the data and the structure, and mysql to import the database from the .sql file created on your new server.

telnet or ssh into your box, and you would need to execute this line from your command line

mysqldump -u username -p --opt databasename > backup-file.sql

You will be asked for your password, then, move the backup-file.sql to your new server, and create a new database , then use the mysql command to import the file into your new database

mysql -u username -p databasename < backup-file.sql

HIt me up via icq at 118997859 if you have any further problems.

Midnight

05-20-2002, 05:19 AM	#1
Ted Confirmed User Join Date: Nov 2001 Posts: 830	Moving MySQL db's I'm moving servers and need to move several databases Can anyone point me to some tutorials to make this as easy and pain free as possible ?

05-20-2002, 05:22 AM	#2
Terenzo Confirmed User Join Date: Jan 2002 Posts: 971	just dump the databases and recreate them on the new server - if you are using a tool like phpMyAdmin, then it is easy unless your db's are of a kind i dont know about... __________________ Signature Spot - USD 5000 / month

05-20-2002, 06:22 AM	#5
Tipsy Confirmed User Join Date: Jul 2001 Location: See sig Posts: 6,989	Just moved a server with a load of MySQL stuff on it. We used phpmyadmin as it made life soooo much easier. __________________ Ignorance is never bliss.

05-20-2002, 07:25 AM	#6
kicks Confirmed User Join Date: Mar 2002 Location: state of missery Posts: 221	Ted A lot of the better hosting companies out there will move your db's for you if you ask. If you have a cut rate host who only wants to hear from you when you send money then the advice others have given is at least on the right track. I know I recently moved some db's from one server to another and I just asked my host to do it and a few minutes later it was done. Call me lazy if ya want kicks __________________ DanL Simply Great Hosting from RackCo icq 162154557

05-20-2002, 05:30 AM	#3
Mr.Fiction Confirmed User Join Date: Feb 2002 Location: Free Speech Land Posts: 9,484	If it's a large database, I don't know how well PHPMyAdmin will do with dumping it. I would do it using telnet if I was you. Just dump it to a directory, then copy it to your new server and recreate it there. Looking.... I just found it. Here is a detailed page on how to move a MySQL database from one server to another: http://www.vbulletin.com/manual/movingservers.html

05-20-2002, 06:06 AM	#4
Ted Confirmed User Join Date: Nov 2001 Posts: 830	Thanks mr fiction that should be enough to get me started, I'll bumble my way through learning as i go.

05-20-2002, 01:10 PM	#7
Midnight Confirmed User Join Date: Jun 2001 Location: ONLINE Posts: 330	You would have to use mysqldump in order to dump the data and the structure, and mysql to import the database from the .sql file created on your new server. telnet or ssh into your box, and you would need to execute this line from your command line mysqldump -u username -p --opt databasename > backup-file.sql You will be asked for your password, then, move the backup-file.sql to your new server, and create a new database , then use the mysql command to import the file into your new database mysql -u username -p databasename < backup-file.sql HIt me up via icq at 118997859 if you have any further problems. Midnight