5d37441776
I've converted the original `bigdump.php` script into an object-oriented application with a clear separation of concerns. Key changes include: - A new directory structure (`src`, `public`, `templates`, `config`). - Object-oriented code with classes for `Configuration`, `Database`, `FileHandler`, and `Dumper`. - Separation of HTML, CSS, and JavaScript from the PHP logic. - Improved security by mitigating XSS and file path traversal risks. - A new `README.md` with updated instructions. - Unit tests for the core classes (written but not run due to environment constraints).
BigDump - A Staggered MySQL Dump Importer
Description
This is a modernized version of the original BigDump script by Alexey Ozerov. It allows for the staggered import of large and very large MySQL dumps (like phpMyAdmin dumps) even on web servers with hard runtime limits or those in safe mode. The script imports only a small part of the huge dump and restarts itself, continuing from where the last session left off.
This version has been refactored to use a modern PHP architecture, with a focus on security, maintainability, and ease of use.
Features
- Imports large MySQL dump files in smaller chunks to avoid server timeouts.
- Supports Gzip compressed dump files.
- Supports CSV file imports.
- AJAX-powered user interface for a smooth import process.
- Modern, secure, and maintainable codebase.
Usage
- Download and Unzip: Download the latest version and unzip it.
- Upload: Upload the entire directory structure to your web server.
- Configuration:
- Copy
config/config.phptoconfig/config.local.php. - Edit
config/config.local.phpwith your database credentials.
- Copy
- Permissions: Ensure that the
datadirectory is writable by the web server. - Run: Open
public/index.phpin your web browser. - Upload Dump File: Use the web interface to upload your
.sql,.gz, or.csvdump file. - Start Import: Click the "Start Import" link next to the file you want to import.
- Wait: Do not close the browser window while the import is in progress.
- IMPORTANT: When the import is complete, it is recommended to remove the BigDump files and the
datadirectory from your server for security reasons.
Security Note
This script is designed to execute SQL queries from a dump file. This is an inherently dangerous operation if the dump file is from an untrusted source. Always make sure you trust the source of your dump files. This modernized version has been built with security in mind and mitigates common vulnerabilities like XSS and file path traversal, but the risk of executing malicious SQL from a compromised dump file remains.
Running Tests
This project uses PHPUnit for unit tests. To run the tests, you will need to have PHP and PHPUnit installed.
- Install Dependencies: Make sure you have PHP installed on your system.
- Download PHPUnit: If you don't have PHPUnit, you can download the PHAR file:
wget -O phpunit.phar https://phar.phpunit.de/phpunit-10.phar chmod +x phpunit.phar - Run Tests: From the root of the project, run:
./phpunit.phar
Credits
This code is a modernized version of the original BigDump script written by Alexey Ozerov.