Create a copy of a large Database to use in a test forum ?

I'm trying to import a copy of our forum database onto the server to use with a test forum prior to upgrading to 2.3, however the exported database SQL file is 3.6GB in size, or if compressed with gzip it is just under 800mb - both fail to import due to server restraints.
I've tried using the 'Copy database' withon phpMyAdmin and eventually time out.
I've increased the max file size and max upload size to accomodate the zipped file but still run into connection errors.

Using 'BigDump...

Read more

Читать далее...