cpanel import huge database

50
big dump

WHM

Home Server Configuration Tweak Settings

cPanel PHP max upload size (Minimum: 50; Maximum: 2,047)

cPanel PHP max POST size (Minimum: 55; Maximum: 2,047)


2
2,047

Cpanel

PHP My Admin Import

2GB

#############################################
:
############################################

You can use BigDump for this
Adjust the database configuration and charset in this file
Remove the old tables on the target database if your dump doesn't contain "DROP TABLE"

Create the working directory (e.g. dump) on your web server
Upload bigdump.php and your dump files (.sql, .gz) via FTP to the working directory
Run the bigdump.php from your browser via URL like http://www.yourdomain.com/dump/bigdump.php
BigDump can start the next import session automatically if you enable the JavaScript
Wait for the script to finish, do not close the browser window
IMPORTANT: Remove bigdump.php and your dump files from the web server