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 :winkwink:

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

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

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

:)

help for you...

He is absolutely right.

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

:thumbsup:thumbsup:thumbsup

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.

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?)