How to run a large SQL file in PHPMyAdmin

Question

I have a huge (~ 500 MB) SQL file that I need to run in my database. This is a data dump from the production database that I need to contribute to my development database. Normally, if it were smaller, I would insert it into the SQL tab and run it, but that would surely blow my browser.

If I import this SQL file into the development database, is it like running an SQL file? Or is the import function specifically configured to import an entire database?

Answer 1

You should try to import it from the console, so you will not be dependent on file upload restrictions:

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

Answer 2

, :

1. , BigDump. . :

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

:

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

2. gzip bzip , phpMyAdmin script. MYSQL .

Answer 3

DB sql 2,2 , , MySQL GUI Tools . .

My Sql GUI

7-8 , .