help... moving one MySQL DB to another server - GoFuckYourself.com

96ukssob · 09-30-2009, 06:11 PM

I have two huge mysql tables that I am trying to move to a new server. I tried to download the files but it is taking to long and hangs up the server while trying to process it. one is about 8gb and the other is around 10gb.

Is there an "easy" way to move the table from server A to server B without vast programming knowledge?

thanks

area51 - BANNED FOR LIFE · 09-30-2009, 06:14 PM

It's pretty easy to do. Why not have your host do it if you're having trouble?

signupdamnit · 09-30-2009, 06:15 PM

If you already dumped the database you could split it up (maybe using zip) into a multi-part archive say in 500MB pieces. Then piece it together on the server.

You don't necessarily need to download the files locally. You could use sftp, scp, etc to copy the files server to server.

96ukssob · 09-30-2009, 06:32 PM

Quote:

Originally Posted by area51

It's pretty easy to do. Why not have your host do it if you're having trouble?

Quote:

Originally Posted by signupdamnit

If you already dumped the database you could split it up (maybe using zip) into a multi-part archive say in 500MB pieces. Then piece it together on the server.

You don't necessarily need to download the files locally. You could use sftp, scp, etc to copy the files server to server.

each box is with a different host.

I was told by the host where the database is at that they would prepare the file as a .tar or .gz file and I could use telnet or ssh to get the file... i have NO clue then what to do with it once its on the new server

Kick Ass Chat · 09-30-2009, 06:35 PM

Quote:

Originally Posted by bossku69

each box is with a different host.

I was told by the host where the database is at that they would prepare the file as a .tar or .gz file and I could use telnet or ssh to get the file... i have NO clue then what to do with it once its on the new server

If your new host won't do it for you then they are the wrong host to be moving to.

bbobby86 · 09-30-2009, 06:43 PM

help for you...

SeizeTheDomain · 09-30-2009, 07:32 PM

Quote:

Originally Posted by GirlsFreePics

If your new host won't do it for you then they are the wrong host to be moving to.

He is absolutely right.

IllTestYourGirls · 09-30-2009, 07:35 PM

Ive moved huge data bases from hosts. If your host isnt doing that doesnt say much for the host. Who is it?

TurboAngel · 09-30-2009, 07:44 PM

Quote:

Originally Posted by GirlsFreePics

If your new host won't do it for you then they are the wrong host to be moving to.

signupdamnit · 09-30-2009, 08:34 PM

Quote:

Originally Posted by bossku69

each box is with a different host.

I was told by the host where the database is at that they would prepare the file as a .tar or .gz file and I could use telnet or ssh to get the file... i have NO clue then what to do with it once its on the new server

The others are right this is probably going to be pretty difficult for you and you need some support.

Generally once you have the file on the server assuming it is a tar.gz archive and this is linux:

gunzip filename
tar xvf filename

then you have to import the database back into mysql on the new server.

Here's some basic help to get you started:

http://linuxcommand.org/
http://www.pixelbeat.org/cmdline.html
http://www.mysqltutorial.org/

Good luck.

rowan · 09-30-2009, 09:31 PM

If your mysql version is the same and your OS is the same "flavour" (eg not moving from 32 to 64 bit) then you may just be able to copy the entire database directory, which will also preserve your user accounts and permissions. Make sure mysql is NOT running on either server when you do this.

Doing it this way will save time since mysql won't have to reinsert everything and build indexes on the fly. (How many rows you got in that table?)

09-30-2009, 06:11 PM	#1
96ukssob So Fucking Banananananas Industry Role: Join Date: Mar 2003 Location: If I was in your ass you'd know it Posts: 12,991	help... moving one MySQL DB to another server I have two huge mysql tables that I am trying to move to a new server. I tried to download the files but it is taking to long and hangs up the server while trying to process it. one is about 8gb and the other is around 10gb. Is there an "easy" way to move the table from server A to server B without vast programming knowledge? thanks __________________ Email: Clicky on Me

09-30-2009, 06:43 PM	#6
bbobby86 partners.sexier.com Industry Role: Join Date: Jan 2007 Location: San Francisco, CA Posts: 11,926	help for you... __________________

09-30-2009, 07:35 PM	#8
IllTestYourGirls Ah My Balls Industry Role: Join Date: Feb 2007 Location: Under the gold leaf ICQ 388-454-421 Posts: 14,311	Ive moved huge data bases from hosts. If your host isnt doing that doesnt say much for the host. Who is it? __________________

09-30-2009, 06:14 PM	#2
area51 - BANNED FOR LIFE So Fucking Banned Join Date: Aug 2009 Posts: 3,164	It's pretty easy to do. Why not have your host do it if you're having trouble?

09-30-2009, 06:15 PM	#3
signupdamnit Confirmed User Industry Role: Join Date: Aug 2007 Posts: 6,697	If you already dumped the database you could split it up (maybe using zip) into a multi-part archive say in 500MB pieces. Then piece it together on the server. You don't necessarily need to download the files locally. You could use sftp, scp, etc to copy the files server to server.

09-30-2009, 09:31 PM	#11
rowan Too lazy to set a custom title Join Date: Mar 2002 Location: Australia Posts: 17,393	If your mysql version is the same and your OS is the same "flavour" (eg not moving from 32 to 64 bit) then you may just be able to copy the entire database directory, which will also preserve your user accounts and permissions. Make sure mysql is NOT running on either server when you do this. Doing it this way will save time since mysql won't have to reinsert everything and build indexes on the fly. (How many rows you got in that table?)