PDA

View Full Version : Transferring a big board to new server


kontrabass
13 Sep 2006, 02:50
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
13 Sep 2006, 05:13
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
18 Sep 2006, 02:18
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
27 Sep 2006, 14:15
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
04 Oct 2006, 18:07
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
05 Oct 2006, 02:30
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
08 Oct 2006, 06:51
3gigs is about 4.5 million posts....not impossible, but why keep that many posts in the database?

jstep
10 Oct 2006, 01:16
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.