moving big sites servers

[lenney]

i have just taken over a site which has a huge database and i am wondering wot is the best way to move it

i tried to bigdump the database but get loads of errors

 

[mp3show]

Big dump is probably best way to imprt a large database. just try and iron out the errors your getting

normaly it comes from a bad export of the database from phpmyadmin.

 

[lenney]

i am really rusty with bigdump not used it for years

Error at the line 3011: /*!40101 SET character_set_client = @saved_cs_client */;
Query: /*!40101 SET character_set_client = @saved_cs_client */;
MySQL: Variable 'character_set_client' can't be set to the value of 'NULL'
Stopped on error

 

[okone]

Dump it via command line (ssh), there are plenty of tutorials on the internet for this. Then tar gunzip it and rsync to the new server. Then just import via command line and voila, problem solved!

 

[Tango]

Check this i wrote http://www.wjunction.com/showthread.php?t=68088


you can tar the mysql dir then transfer the database, there is no need to re-import.

 

[mp3show]

if u want me to take a look at this for you. pm me the info and i will try and take a backup with no errors

 

[immortalxx]

never heard of big dump? as stated do a mysql dump using ssh http://************/6fx2bf3

 

[xs123]

I am use mysqldumper to backup my website huge database and then upload dbs into filehost like hotfile.com .

 

[lenney]

i do not have ssh access so i will try mysqldumper

 

[lenney]

still same error grr

MySQL says:
Variable 'character_set_client' can't be set to the value of 'NULL'
Error in Query:
/*!40101 SET character_set_client = @saved_cs_client */;

 

[mp3show]

as mentioned before. if you wish me to take a look at this for you. please pm me the phpadmin login detials

 

[StupidGlitch]

Want me to take a look?

Depends how large it is, i could take it then split the database for you.

 

[jessepure]

bro u have to use ssh dump or split it.

 

[lenney]

the database un zipped is 200mb mp3show thanx for the offer but i would not give my ftp details out

 

[mp3show]

No problem

hope you find a solution

 

[loki]

use ssh to import it, mines over 5 gigs unpacked and works for me

 

[lenney]

i do not have ssh access as i am shared hosting

 

[lenney]

i have just started doing it table by table hopefully i dont miss any

 

[Storming]

Hi Lenney,
Contact your host and they should be able to import it for you via SSH - would be much quicker for you.

If they can't you really shouldn't be hosting with them :P