Pages

Saturday 20 September 2014

How to upload more than 50mb database?


1) Download BigDump from here

2) Make sure you have a copy of the large database you want to import in .sql or .gz format. Make sure when you export the database that you include the ‘drop table’ function and turn off ‘extended inserts’. - 

3) Open bigdump.php and change the database details to match your own. 

$db_server   'localhost'//This is usually localhost
$db_name     'database_name'//Your database name
$db_username 'database_username'//Your database username
$db_password 'password'//Your database password

4)  Upload bigdump.php to your website.

5)  Upload the .sql or .gz file to the same directory as bigdump.php.

6)  Access http://yourwebsite.com/bigdump.php

7)  Select the file you wish to import from the list that BigDump creates.

8)  Wait for the import to finish. BigDump will give you a status bar with details on the progress of the import.

9)  Once you’ve finished, remember to delete bigdump.php and your database file from your webspace!

Note:If you keep getting a timeout error when BigDump runs an import, try increasing the $linespersession.

0 comments:

Post a Comment