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