Upload large sized database using BigDump.
- Download and unzip bigdump.zip on your computer.
- Open bigdump.php in a text editor.
- Update database configuration
// Database configuration $db_server = 'localhost'; $db_name = ''; $db_username = ''; $db_password = '';
- Optional settings (For example, $filename)
// OPTIONAL SETTINGS $filename = ''; // Specify the dump filename to suppress the file selection dialog $ajax = true; // AJAX mode: import will be done without refreshing the website $linespersession = 3000; // Lines to be executed per one import session $delaypersession = 0; // You can specify a sleep time in milliseconds after each session // Works only if JavaScript is activated. Use to reduce server overrun
- Create the working directory (e.g. tempFile) on your web server
- Upload bigdump.php and the database file (*.sql or *.gz) via FTP to the working directory.
- Run the bigdump.php from your web browser via URL like http://www.yourdomain.com/tempFile/bigdump.php.
- Now you can select the file to be imported from the listing of your working directory. Click “Start import” to start.
- BigDump will start every next import session automatically if JavaScript is enabled in your browser.
- Relax and wait for the script to finish. Do NOT close the browser window!
- IMPORTANT: Delete the working directory (e.g. tempFile) to remove bigdump.php and your dump files from your web server.
Leave a Reply