How to import large sql files into mysql using phpmyadmin wamp server

When you try to import sql file to wamp server usually it cann't upload more than  2,048KiB size and gives error message like

There is another way to upload large size of sql file to wamp server

step 1

Find the config.inc.php file located in the phpmyadmin directory. In my case it is located here:

C:\wamp\apps\phpmyadmin3.4.5\config.inc.php

Note:  phymyadmin3.4.5 folder name is different in different version of wamp

step 2:

Find the line with $cfg['UploadDir'] on it and update it to:

$cfg['UploadDir'] = 'upload';


step 3:
Create a directory called ‘upload’ within the phpmyadmin directory.
   
C:\wamp\apps\phpmyadmin3.2.0.1\upload\


step 4:

copy and paste the  large sql file into upload directory which you want importing to phymyadmin

step 5:

select sql file from drop down list from phymyadmin to import



Bookmark the permalink.

48 Responses to How to import large sql files into mysql using phpmyadmin wamp server

  1. Yes sir its working for me on wamp localhost but muy question is that what I do with server.
    How we upload on the server.

    ReplyDelete
  2. Its very helpful for uploading the files..thanks for the blog
    Oracle DBA Training Chennai

    ReplyDelete
  3. Thanks you very much
    http://www.steptoinstall.com/import-big-database-sql-file-to-phpmyadmin-wamp-server.html

    ReplyDelete
  4. Oracle is a relational database management system produced by oracle corporation. Nowadays most of the multinational companies used this oracle database for storing and managing their data's and programs. So learning Oracle Training is one of the best idea to make a bright career.

    ReplyDelete
  5. Excellent information. HTML5 is a markup language used for designing responsive website and it is also used for structuring and presenting the website content.
    HTML5 Training | PHP Course in Chennai



    ReplyDelete
  6. Nice information. Android is one of the most popular mobile operating system developed by Google. Learning Android Course in Chennai is useful to make a wonderful future in mobile application development field.

    ReplyDelete
  7. Really nice post. SEO is one of the digital marketing techniques used for improve the website ranking in search engine result page. To know more details please call 9003623340.
    Regards..
    SEO Training in Chennai

    ReplyDelete

  8. I have read your blog, it was good to read & I am getting some useful info's through your blog keep sharing... Informatica is an ETL tools helps to transform your old business leads into new vision. Learn Informatica training in chennai from corporate professionals with very good experience in informatica tool.
    Regards,
    Informatica training center in Chennai|Informatica training chennai

    ReplyDelete
  9. This is first time I am come across your site. You have shared great information to me. Keep updating.
    DBA course syllabus | Oracle dba course

    ReplyDelete
  10. Ciitnoida provides Core and java training institute in

    noida
    . We have a team of experienced Java professionals who help our students learn Java with the help of Live Base Projects. The object-

    oriented, java training in noida , class-based build

    of Java has made it one of most popular programming languages and the demand of professionals with certification in Advance Java training is at an

    all-time high not just in India but foreign countries too.

    By helping our students understand the fundamentals and Advance concepts of Java, we prepare them for a successful programming career. With over 13

    years of sound experience, we have successfully trained hundreds of students in Noida and have been able to turn ourselves into an institute for best

    Java training in Noida.

    java training institute in noida
    java training in noida
    best java training institute in noida
    java coaching in noida
    java institute in noida

    ReplyDelete
  11. Great post! I am actually getting ready to across this information, It’s very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.

    rpa training in Chennai

    rpa training in anna nagar | rpa training in marathahalli

    rpa training in btm | rpa training in kalyan nagar

    rpa training in electronic city | rpa training in chennai

    rpa online training | selenium training in training

    ReplyDelete
  12. Appreciating the persistence you put into your blog and detailed information you provide
    python training in rajajinagar
    Python training in btm
    Python training in usa

    ReplyDelete
  13. This information is impressive. I am inspired with your post writing style & how continuously you describe this topic. Eagerly waiting for your new blog keep doing more.

    Franchise Business in India
    Education Franchise
    Computer Education Franchise
    Education Franchise India
    Computer Center Franchise
    Education Franchise Opportunities in India

    ReplyDelete
  14. I am obliged to you for sharing this piece of information here and updating us with your resourceful guidance. Hope this might benefit many learners. Keep sharing this gainful articles and continue updating us.
    Java Training in Chennai
    Java course in Chennai
    Java Training Institute in Chennai
    Best Java Training Institute in Chennai
    Java Training
    Java Classes in Chennai
    Core Java Training in Chennai

    ReplyDelete
  15. I am happy to find this post Very useful for me, as it contains lot of information

    Education
    Technology

    ReplyDelete
  16. I really love the theme/design of your website. Do you ever run into any browser compatibility problems?
    fire and safety course in chennai

    ReplyDelete
  17. This is a good post. This post give truly quality information. I’m definitely going to look into it. Really very useful tips are provided here. thank you so much. Keep up the good works.
    hadoop big data training in chennai
    big data training institute in chennai
    Best Hadoop Training in Chennai
    CCNA institute in Chennai
    CCNA Training center in Chennai
    Best CCNA Training Institute in Chennai

    ReplyDelete
  18. Some us know all relating to the compelling medium you present powerful steps on this blog and therefore strongly encourage
    contribution from other ones on this subject while our own child is truly discovering a great deal.
    Have fun with the remaining portion of the year.

    Selenium training in bangalore | best selenium training in bangalore

    ReplyDelete
  19. This comment has been removed by the author.

    ReplyDelete
  20. Finally i Found this, Thank you to share this. PHP Course in Chennai

    ReplyDelete
  21. Hey there! I know this is kind of off-topic, but I’d figured I’d ask. Would you be interested in exchanging links or maybe guest authoring a blog post or vice-versa?
    iosh course in chennai

    ReplyDelete
  22. Thanks for posting this information it really useful for everyone. oracle training in chennai

    ReplyDelete
  23. Get Big Data Certification in Chennai for making your career as a shining sun with Infycle Technologies. Infycle Technologies is the best Big Data training institute in Chennai, providing complete hands-on practical training of professional specialists in the field. In addition to that, it also offers numerous programming language tutors in the software industry such as Oracle, Java, Python, AWS, Hadoop, etc. Once after the training, interviews will be arranged for the candidates, so that, they can set their career without any struggle. Of all that, 200% placement assurance will be given here. To have the best career, call 7502633633 to Infycle Technologies and grab a free demo to know more.
    Grab Big Data Certification in Chennai | Infycle Technologies

    ReplyDelete
  24. Finish the Selenium Training in Chennai from Infycle Technologies, the best software training institute in Chennai which is providing professional software courses such as Data Science, Artificial Intelligence, Java, Hadoop, Big Data, Android, and iOS Development, Oracle, etc with 100% hands-on practical training. Dial 7502633633 to get more info and a free demo and to grab the certification for having a peak rise in your career.

    ReplyDelete
  25. OctaFx Review : A Complete Introduction to Trading Methods and Applications with Concept, Tools, and Techniques for Understanding the Market is a complete course in technical market analysis that focuses on how to navigate the labyrinth of technical tools currently available to financial traders.

    ReplyDelete
  26. Are You Aware Of Fxtm Review Minimum Deposit And Withdrawal Amounts?

    ReplyDelete
  27. Pull- up your socks and knot your tie. Gonna have a good salary package job after completing Big-data Hadoop training in Chennai at Infycle. Infylce is completely for Software training and placement by friendly trainees, good atmosphere, 200% practical classes, and more.

    ReplyDelete