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

Posted on Tuesday, August 21, 2012 by

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.

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

  1. Rohit SrivastavaFebruary 6, 2014 at 11:19 AM

    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. UnknownDecember 24, 2014 at 6:23 AM

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

    ReplyDelete
  3. UnknownApril 11, 2015 at 11:05 PM

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

    ReplyDelete
  4. UnknownJune 17, 2015 at 12:37 AM

    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. UnknownJune 17, 2015 at 11:06 PM

    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. UnknownJune 22, 2015 at 12:17 AM

    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. UnknownJune 26, 2015 at 12:35 AM

    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. UnknownOctober 22, 2015 at 12:33 AM


    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. LuckpersonOctober 2, 2017 at 5:48 AM

    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. ciitnoidaMay 8, 2018 at 12:57 AM

    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. poojaAugust 29, 2018 at 4:10 AM

    Awesome..You have clearly explained …Its very useful for me to know about new things..Keep on blogging..

    Hadoop Training in Chennai

    Hadoop Training in Bangalore

    Big data training in tambaram

    Big data training in Sholinganallur

    Big data training in annanagar

    ReplyDelete
  12. kevingeorgeSeptember 12, 2018 at 3:22 AM

    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
  13. MounikaSeptember 14, 2018 at 1:01 AM

    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
  14. nilashriOctober 3, 2018 at 3:10 AM

    I really like your blog. You make it interesting to read and entertaining at the same time. I cant wait to read more from you.
    Data science course in tambaram | Data Science course in anna nagar
    Data Science course in chennai | Data science course in Bangalore
    Data Science course in marathahalli | Data Science course in btm

    ReplyDelete
  15. Sumaya ManzoorOctober 8, 2018 at 2:46 AM

    I am always searching online for articles that can help. There is obviously a lot to know about this. I think you made some good points
    Selenium Training in Chennai
    Loadrunner Training in Chennai
    PHP Training in Chennai
    cloud computing training in chennai
    Salesforce Training in Chennai
    DOT NET Training in Chennai

    ReplyDelete
  16. yuvaprithikaOctober 10, 2018 at 2:27 AM

    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
  17. mercyroyOctober 10, 2018 at 10:28 PM

    good work done and keep update more.i like your information's and that is very much useful for readers.
    android certification course in bangalore
    Android Training in Mogappair
    Android Training in Vadapalani
    Android Training in Karapakkam

    ReplyDelete
  18. pavithra dassOctober 10, 2018 at 10:41 PM

    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
  19. Anbarasan14October 10, 2018 at 11:14 PM

    This was helpful and thanks for sharing this useful information. Kindly continue the work.

    Spoken English Classes in Chennai | Spoken English Classes in OMR Chennai | Spoken English Classes in Navalur | Spoken English Classes near Thoraipakkam | Spoken English Classes in Sholinganallur | Spoken English Classes in Padur | Best Spoken English Classes in Chennai

    ReplyDelete
  20. UnknownOctober 11, 2018 at 10:31 PM

    Awesome Post. Thanks for Sharing. Kepp updating.
    pega training in chennai
    pega course in chennai
    pega training institutes in chennai
    pega course

    ReplyDelete
  21. Vicky RamOctober 11, 2018 at 11:02 PM

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

    Education
    Technology

    ReplyDelete
  22. srinithyaOctober 12, 2018 at 1:43 AM

    Very good blog, thanks for sharing such a wonderful blog with us. Keep sharing such a worthy information to my vision.
    Blue Prism Training Institute in Chennai
    Blue Prism course in Chennai
    Blue prism course
    RPA Training in Chennai
    Angularjs Training in Chennai
    AWS Training in Chennai

    ReplyDelete
  23. AnonymousOctober 12, 2018 at 2:39 AM

    Thank you for sharing with us. It is really a valuable information.

    Mobile Testing Training | Mobile Application Testing Training | Mobile Apps Testing Training | Mobile Testing Course in Adyar | Mobile Testing Training in Velachery | Mobile Testing Training in Tambaram

    ReplyDelete
  24. UnknownOctober 22, 2018 at 10:58 PM

    It was really a nice article and I was really impressd by reading this.
    Thank you for such amazing post. Keep up the good work.

    Primavera Training in Chennai
    Primavera Course in Chennai
    Primavera Software Training in Chennai
    Best Primavera Training in Chennai
    Primavera p6 Training in Chennai
    Primavera Coaching in Chennai
    Primavera Course

    ReplyDelete
  25. Madhu BalaNovember 9, 2018 at 10:44 PM

    Very useful blog for those who are really want to enhance their knowledge in the software field. Keep updating.

    Selenium Training in Chennai
    selenium testing training in chennai
    iOS Training in Chennai
    Digital Marketing Training in Chennai
    Future of testing professional
    iOS Training in Velachery
    iOS Training Institutes in Adyar

    ReplyDelete
  26. SANDYNovember 12, 2018 at 3:17 AM



    Hmm, it seems like your site ate my first comment (it was extremely long) so I guess I’ll just sum it up what I had written and say, I’m thoroughly enjoying your blog. I as well as an aspiring blog writer, but I’m still new to the whole thing. Do you have any recommendations for newbie blog writers? I’d appreciate it.
    Best AWS Training in Chennai | Amazon Web Services Training in Chennai


    AWS Training in Bangalore | Amazon Web Services Training in Bangalore

    AWS Training in Pune | Best Amazon Web Services Training in Pune


    Amazon Web Services Training in OMR , Chennai | Best AWS Training in OMR,Chennai

    AWS Training in Chennai |Best Amazon Web Services Training in Chennai

    Learn Amazon Web Services Tutorial |AWS Tutorials For Beginners

    AWS Interview Questions And Answers

    ReplyDelete
  27. gowthunanNovember 12, 2018 at 9:32 PM

    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
  28. pavithra dassNovember 18, 2018 at 8:51 PM

    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
  29. UnknownDecember 6, 2018 at 10:07 PM

    Thank you for allowing me to read it, welcome to the next in a recent article. And thanks for sharing the nice article, keep posting or updating news article.
    Data Science Training in Chennai | Data Science Training institute in Chennai
    Data Science course in anna nagar
    Data Science course in chennai | Data Science Training institute in Chennai | Best Data Science Training in Chennai
    Data science course in Bangalore | Data Science Training institute in Bangalore | Best Data Science Training in Bangalore
    Data Science course in marathahalli | Data Science training in Bangalore

    ReplyDelete
  30. mokshitha orangeDecember 14, 2018 at 1:57 AM


    Great job.... Awesome list, just starting a blog and this is going to be a massive help. Thank you!

    Software Testing Training
    JMeter Training in Chennai
    Automation Training in Chennai
    QTP Training in Chennai
    Selenium Training in Chennai
    LoadRunner Training in Chennai

    ReplyDelete
  31. tamilsasiJanuary 12, 2019 at 1:18 AM

    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
  32. jvimalaJanuary 21, 2019 at 12:17 AM

    This comment has been removed by the author.

    ReplyDelete
  33. jvimalaJanuary 21, 2019 at 12:19 AM

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

    ReplyDelete
  34. sunshineprofeJanuary 28, 2019 at 1:18 AM

    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
  35. jefrinApril 24, 2019 at 5:02 AM

    It’s great to come across a blog every once in a while that isn’t the same out of date rehashed

    material. Fantastic read.
    Java Training in Chennai |Best

    Java Training in Chennai
    C C++ Training

    in Chennai |Best C C++ Training Institute in Chennai
    Data science Course

    Training in Chennai |Best Data Science Training Institute in Chennai
    RPA Course

    Training in Chennai |Best RPA Training Institute in Chennai
    AWS Course Training

    in Chennai |Best AWS Training Institute in Chennai
    Devops Course Training

    in Chennai |Best Devops Training Institute in Chennai
    Selenium Course Training in

    Chennai |Best Selenium Training Institute in Chennai
    Java Course Training in Chennai |

    Best Java Training Institute in Chennai

    ReplyDelete
  36. sushmi reddyMay 24, 2020 at 9:06 AM

    I like this one...more helpful information provided here.I am quite sure I will learn much new stuff right here! Good luck for the next!
    Oracle Training | Online Course | Certification in chennai | Oracle Training | Online Course | Certification in bangalore | Oracle Training | Online Course | Certification in hyderabad | Oracle Training | Online Course | Certification in pune | Oracle Training | Online Course | Certification in coimbatore

    ReplyDelete
  37. saranJune 17, 2020 at 7:01 PM

    Excellent information with unique content and it is very useful to know about the information based on blogs
    Digital Marketing Training Course in Chennai | Digital Marketing Training Course in Anna Nagar | Digital Marketing Training Course in OMR | Digital Marketing Training Course in Porur | Digital Marketing Training Course in Tambaram | Digital Marketing Training Course in Velachery

    ReplyDelete
  38. RevathiJuly 22, 2020 at 9:48 AM

    This blog is very useful to me..great work ...you give to more technical knowledge.. thanks lot!!

    Android Training in Chennai

    Android Online Training in Chennai

    Android Training in Bangalore

    Android Training in Hyderabad

    Android Training in Coimbatore

    Android Training

    Android Online Training

    ReplyDelete
  39. DeviAugust 12, 2020 at 11:33 AM

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

    ReplyDelete
  40. DeviJune 30, 2021 at 9:13 AM

    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
  41. INFYCLE TECHNOLOGIESSeptember 15, 2021 at 9:48 AM

    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
  42. UNIQUE ACADEMYOctober 17, 2021 at 1:48 AM

    hi thanku somuch this infromation thanku so much
    cs executive
    freecseetvideolectures/

    ReplyDelete
  43. Maria YangNovember 24, 2021 at 11:08 PM

    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
  44. INFYCLE TECHNOLOGIESNovember 30, 2021 at 7:35 AM

    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
  45. AnonymousMay 17, 2022 at 1:16 PM

    en son çıkan perde modelleri
    Mobil Onay
    mobil ödeme bozdurma
    Nft nasil alinir
    Ankara evden eve nakliyat
    TRAFİK SİGORTASİ
    dedektör
    kurma website
    aşk romanları

    ReplyDelete
  46. AnonymousMay 26, 2022 at 8:52 PM

    smm panel
    smm panel
    iş ilanları blog
    İnstagram Takipçi Satın Al
    Hırdavatçı
    BEYAZESYATEKNİKSERVİSİ.COM.TR
    servis
    tiktok jeton hilesi

    ReplyDelete
  47. AnonymousJune 4, 2022 at 11:01 PM

    tuzla toshiba klima servisi
    tuzla beko klima servisi
    çekmeköy lg klima servisi
    pendik lg klima servisi
    pendik arçelik klima servisi
    çekmeköy vestel klima servisi
    ataşehir vestel klima servisi
    çekmeköy bosch klima servisi
    ataşehir bosch klima servisi

    ReplyDelete