Importing a large database

[TopicKing]

Hi guys. I'm looking to import a large forum database I have that contains over 30,000 posts and 1,000 members. Each time I import it, it seems to come without the mybb_users table and the necessary tables to run the MyBB Merge platform.

I have searched the plain SQL file and found the mybb_users table inside of it. I'm just unsure why it is leaving out so many tables when I import it.

The file is 136mb raw with no compression. I tried to use it on localhost with the max filesize just being enough to upload it and it gives me the same errors.

I'd also like to be sure that it does have everything with it, else I'll have a problem with the person who sold it to me.

Thanks

[weBex]

You're probably exceeding the limit some how.

Try uploading the .SQL file directly onto the FTP of the new host, then using this script to help you port in the Database:
http://www.ozerov.de/bigdump/

Alternatively, you should consult your host, a lot will assist you with transferring the enormous database onto their servers.

[User 2877]

That's very large for 30k posts and 1k members. I'd expect the SQL to be much smaller. Less than 50mb.

But follow webex advice.

[Salih I]

This user has been denied support.

http://www.mysqldumper.net/

This one is very good and easy to use too!

[Nebulon Ranger]

That's a huge database. Does it contain a Bad Behavior log table? Those can take up space extremely fast when spambots start trying to access your forum. I know mine used to sit at ~75MB.

[Salih I]

This user has been denied support.

A simple equation:
50mb != Large db
1 gb >= Large db

And for importing any size larger than 10 mb use big dump or mysqldumper.

[Nebulon Ranger]

A simple equation:
50mb != Large db
1 gb >= Large db

And for importing any size larger than 10 mb use big dump or mysqldumper.

Got your symbols mixed up. Saying that 1GB is greater than or equal to a large database sounds odd.

[Salih I]

This user has been denied support.

A simple equation:
50mb != Large db
1 gb >= Large db

And for importing any size larger than 10 mb use big dump or mysqldumper.

Got your symbols mixed up. Saying that 1GB is greater than or equal to a large database sounds odd.

Yes exactly you don't call a db of 50 mb large or huge. I din't mix up any symbols.

[Tom K.]

You're saying "less than or equal to 1gb is a large database". You should have just typed "1gb+" ^_^

[Salih I]

This user has been denied support.

@TOM: i used ">" which means greater than not less than. Ohhh GOD is there no programmers here. They would definitely understand me