2

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.

Improve this question
2
  • Welcome at SO. Your question does not contain enough information to analyze the problem. Please include the error message and other relevant information you have. Commented Mar 17, 2014 at 8:33
  • @patric hofman : there is not any error. it just takes very long time to do the job done. there is 2 gb sql file for the table and when i import it takes so much time. i have also tried to execute the sql file it also takes very long time. plz suggest me the easy slution to import the sql file in my phpmyadmin in less time. Your any help will be very appreciated. Commented Mar 17, 2014 at 9:46

2 Answers 2

Reset to default
1

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

5 Comments

i am importing this file on live database of my website. how can i change the suggested changes in php.ini file
@user3427967 You haven't mentioned that in your question!
@user3427967 check this out: for WHM/Cpanel (coolestguidesontheplanet.com/…)
@arshad yes i am using whl/cpanel. i have checked out your suggested link but cant find the tweak setting option over there. i have tried to execute the sql dump file that i dumped from localhost i.e wampp but it takes too much time.
@user3427967 Ok, check is it successful in wamp after making suggested changes. If gives error then mention that error in your question/comment.
0

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

Improve this answer

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.