How to import large data bases to phpMyAdmin

You cannot import mysql database of file size more than 50 MB from your site’s PHPmyAdmin. Even though its compressed with gzip or zip, your_database.sql.gz shouldn’t exceed that maximum file size limit.

So how to import larger mysql database?

The workaround is importing it with Bigdump script. You can download the script from here.

Watch the video below to get started,

NOTE: while importing the DB, you will receive an error saying (At this place the current query includes more than 300 dump lines). So to resolve this issue, simply search for the $max_query_lines and change the value to a greater number.

Please follow and like us:

Author: Chathura Ariyadasa

♚Father ♚Innovative Technical Architect ♚ Cyber Security Strategist ♞ vCISO | vCIO ♞ Blogger & an Adrenaline junkie...