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

lenney Reviewed by lenney on 7th Mar 2011. moving big sites servers 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 Rating: 5

[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!

[Gavo]

Check this i wrote http://www.besthostingforums.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 */;