CODEWITHSUNDEEP
mysqlimportphpmyadminlarge-files
user3427967
user3427967

Reputation: 21

Importing huge sql file using phpmyadmin

I am trying to import 2 GB sql file of table. I tried using bigdump but it failed. Can any body help me in this regard? I am using phpmyadmin by increasing the max_upload_filesize. Any help will be much appreciated.

Upvotes: 2

Views: 1849

Answers (2)

pyjavo
pyjavo

Reputation: 1613

I tried using the mysql console like in this answer and it worked for me! (It will take a while)

Upvotes: 0

user2303914
user2303914

Reputation:

How To

Make sure you change both *"post_max_size"* and *"upload_max_filesize"* in your "php.ini" (which is located where your "php.exe" is).

The following example allows you to upload and import 128MB sql files:

post_max_size=128M
upload_max_filesize=128M

Restart Apache and you're all set.

Alternatives

An alternative way to work around the problem is to use the command line. But it's a workaround, and as ugly as workarounds get:

C:\xampp\mysql\mysql.exe -u root -p db_name < C:\some_path\your_sql_file.sql

As you're not using the server but the command line, upload and POST sizes don't matter. That's why I call this a "workaround", since it doesn't actually solve your problem.

Upvotes: 1

Related Questions