How to use Bigdump?

BigDump refers to a popular script used for importing large SQL databases into MySQL databases. It is particularly useful when you need to import large database backups, as it allows you to overcome the size limitations of the default MySQL import tools.

Here's a step-by-step guide to using BigDump to import large SQL databases:

1. Download BigDump

Visit the official BigDump website: https://www.ozerov.de/bigdump/

Download the latest version of the script (bigdump.php) to your local machine and unzip the downloaded zip file in bigdump directory by using the option extract to bigdump.

2. Copy unzipped bigdump folder to project root directory

Copy bigdump folder from your download location and paste into the root directory of your project.

3. Copy mysql file to bigdump folder of your project root directory

Copy mysql file which you want to import and paste into the bigdump folder of your project root directory.

4. Edit BigDump configuration

Open the bigdump.php file in a text editor.

Find the following lines and update them with your MySQL database information.

$db_server   = 'your_mysql_server';
$db_name     = 'your_database_name';
$db_username = 'your_mysql_username';
$db_password = 'your_mysql_password';

5. Run BigDump

Open a web browser and navigate to http://yourdomain.com/bigdump/bigdump.php (replace "yourdomain.com" with your actual domain name).  

Find the "Start Import" button, and click on it to begin the import process.