Portal Home > Knowledgebase > Web Hosting > Using bigdump.php to deal with large databases

Using bigdump.php to deal with large databases

1) Download a copy of bigdump.php from http://solidshellsecurity.com/clients/dl.php?type=d&id=3, unzip the file, and open the file "bigdump.php" by right clicking it with your mouse, selecting "Open with" from the context menu and then "Notepad" from the list of applications.

2) Find the following section of the file:

// Database configuration

$db_server = 'localhost';
$db_name = 'DBname';
$db_username = 'DBusername';
$db_password = 'DBpassword';

The entries should be as shown above, substituting the correct values depending on where the database that is to be imported is located. Close this file and save a copy of it to your desktop or somewhere it will be easily remembered.

3) Upload the DB file to the same location as bigdump.php

4) Open your web browser, select the text in the address bar, and type:

5) Bigdump.php should run unattended after it has run, and will inform you of it's success when the database has been completely installed.

6) If you are importing to a remote database, you should delete the bigdump.php file for security purposes with your ftp program or other utility as suggested in the bigdump.php documentation, and you may wish to remove the old database at this time as well, to free up server space.

Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Powered by WHMCompleteSolution