Dumping zip, txt, or csv files into PHPMYADMIN is a quick way to generate a database. However, a time could arise when you would like to dump a very large file. By default, phpAdMin allows files up to 50 mb; although php.ini may have other limits. You can alter file sizes in php.ini to allow for upload_max_size and post_max_size. If you alter the size, you may want to alter the timeout so it will not timeout.
If you have root access to yoor hosting account, you can create an upload directory and load from the server, rather than remotely. To do this, you need to access your phpMyAdmin config file called config.inc.php. The file path may be something like: /usr/local/cpanel/base/3rdparty/phpMyAdmin.
To check for its location,
1) Login with SSh and type:
root@server [~]# cd /usr/local/cpanel/base/3rdparty/phpMyAdmin
To change the config.inc.php file,
1) Transfer a copy to your hard drive.
$cfg[‘UploadDir’] = ”; to
$cfg[‘UploadDir’] = ‘upload’;
3) Upload CSV, txt or zip file to upload folder.
4) Login to phpMyAdmin and dump from server. You will see:
‘Select from the web server upload directory’.