Transferring a big board to new server

[kontrabass]

I did a dump of my database, in prep to transfer to a new server. The size of the .sql is exactly 3.0G, which leads me to believe maybe there's a file size limitation going on here? I tried restoring this dump on the new server, but any attempt to load a vb page leads to a hung browser (nothing, nada).

How do y'all move huge databases? Mysqlhotcopy?

[Ntfu2]

how in the world did you get a 3.0G database :shock:

Anyway, you can try mysqlhotcopy, most people use a tool that breaks the sql into smaller chunks, i cant remember the name of it, but hopefully that helps some

[COBRAws]

you could compress (tar.gz) your db in the actual server, and then scp it thru SSH to the new server. Finally decompress it and load it into your mysql =D

[paldo]

i use a lil php application called bigdump (its free) for my database cuz its to big to mess with by hand anymore ..3gig db my god man u saving your attachments in your sql?

http://www.ozerov.de/bigdump.php

[jason|xoxide]

The way I dump my databases is as follows:
mysqldump --opt -u username -p dbname > dbname.sql
If you are worried that the dump is being cutoff then you could try running:
tail -n 15 dumpfilename
The last few lines should look something like:
UNLOCK TABLES;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;


Oh, and as to 3GB being huge, it's not that big. My two largest sites have 2.4GB and 2.0GB dumps so I'm well on my way.

[Ntfu2]

3GB is a huge database. Our board currently has 10k users and almost 100k posts and is under 150MB, at this rate, we'd need about 2 million users and 2 millions posts :D

[Gunshot]

3gigs is about 4.5 million posts....not impossible, but why keep that many posts in the database?

[jstep]

3GB is a huge database. Our board currently has 10k users and almost 100k posts and is under 150MB, at this rate, we'd need about 2 million users and 2 millions posts :D

My board with only 400 users, and 26,000 posts is about 50mb

It depends on hack installs etc. as well

We have alot of custom fields etc.