PHPMyAdmin will not work for uploading large mysql databases. If you attempt to upload a large mysql dataset you will often get this error

Fatal error: Maximum execution time of 300 seconds exceeded

Fix:

If you get this error you will need edit config.default.php inside phpmyadmin and look for this line

$cfg['ExecTimeLimit'] = 300;

and replace with 0 or any larger value

$cfg['ExecTimeLimit'] = 3600;

If that doesnt work, try this BigDump MySQL Importer. It is free for download.

If you have commandline SSH access, and your SQL file is in gzip format use this superfast command to import large gzipped mysql databases

gunzip < dbname.gz | mysql -u Username -p dbname

Always consider GZIP to export and dump large mysql databases as it has better compression than ZIP formats.

Similar Posts:

• how to create new user for phpmyadmin login
• How to Fix: PHPMyAdmin 403 Forbidden Error
• Install LAMP Server for Centos/RHEL
• Rewriting MySQL Date to PHP Date Format
• How to import text data in mysql with spaces?
• How to upload/download files with FTP in linux commandline
• Uploading Files using Unzip in Linux
• Fix: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’
• HOWTO: Install PEAR for php in Linux
• Most Popular Open Source PHP Scripts