How to Run Large SQL File in PHPMyAdmin

Question

I have a huge (~500mb) SQL file that I need to run on my database. It is a data dump from a production database that I need to put into my development database. Normally, if it were smaller, I'd paste it into the SQL tab and run it, but that would definitely blow up my browser.

If I import that SQL file into the development database, is is just like running the SQL file? Or is the import function specifically set to import a whole database?

Answer 1

You should try to import it from the console, so you do not depend on the file upload limitations:

C:>  mysql -u root -p < file.sql

Answer 2

I can suggest two options that you can try:

1.I would say try BigDump. I had the exact same problem before. You can read and follow this article for more information:

http://moeamine.com/how-to-upload-a-big-sql-file-to-mysql

You can download big dump from the link below:

http://www.ozerov.de/bigdump/

2.you can gzip or bzip the file and phpMyAdmin will decompress and run the script. Another option is to split the MYSQL file into number of files and load each of them individually.