vb.org Archive - Transferring a big board to new server

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Big Board Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=172)

- - Transferring a big board to new server (https://vborg.vbsupport.ru/showthread.php?t=126463)

kontrabass

09-13-2006 12:50 AM

Transferring a big board to new server

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

09-13-2006 03:13 AM

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

09-18-2006 12:18 AM

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

09-27-2006 12:15 PM

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

10-04-2006 04:07 PM

The way I dump my databases is as follows:

Code:

mysqldump --opt -u username -p dbname > dbname.sql

If you are worried that the dump is being cutoff then you could try running:

Code:

tail -n 15 dumpfilename

The last few lines should look something like:

Code:

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

10-05-2006 12:30 AM

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

10-08-2006 04:51 AM

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

jstep

10-09-2006 11:16 PM

Quote:

Originally Posted by 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

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.

All times are GMT. The time now is 08:02 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01096 seconds Memory Usage 1,726KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: