How to import too large database file in phpmyadmin?

How to import too large database file in phpmyadmin? you tired to upload too large file in phpmyadmin?

We face big problem when we will upload a large file to phpmyadmin. Here I give some way that help your problem solutions. Also I added screenshot that help your solution.   If you can too large file upload your mysql database. You can follow bellow steps. Here I give you to way for large file upload.

Step One:

you will should change your config from XAMPP or wampserver  control panel. You need change here “post_max_size”, “upload_max_file”, and  “memory_limit” also increase your input time.

Ex: max_execution_time = 3000, max_input_time = 60, memory_limit = 1200M, upload_max_filesize = 1100M, post_max-size = 1100M.

And configure

Second Step:

First you copy your database sql file  and paste your  xampp\mysql\bin folder screenshot below if your xampp installed in C drive then root is: C:\xampp\mysql\bin

Now you open your command in this folder(here already you paste your database that means C:\xampp\mysql\bin), when open command then write “mysql -u root -p databasename < database-sqlfile.sql” its look like: C:\xampp\mysql\bin>mysql -u root -p ru_web < ru_web.sql

*databasename=  that you create http://localhost/phpmyadmin here

* database-sqlfile.sql= your main sql file, that you will upload/import  to “databasename”

When completed upload then Open command  show  this code, screenshot below:

C:\xampp\mysql\bin>mysql -u root -p ru_web < ru_web.sql

Enter password:

C:\xampp\mysql\bin>

Ok, that’s all. Just follow carefully my instruction step by step. If you will face any problem then you can comment me.

3 Responses to “How to import too large database file in phpmyadmin?”

  1. Despite a lot of searching I cannot seem to find the deadline for Rosling King LLP graduate vac schemes? Some students on the latestlawjobs.com chat told me I may find some lawyers here. Thanks

  2. Good morning! I bumped into some intriguing news in the crypto currency domain . Some people in the crypto area are writing that a new cryptocurrency will be launched and remarkably, it will be financed by the best law firms in the USA and the UK 😀 Allegedly, its name is LAWesome coin. It would be great if anyone could share some new real-time info on this coin. I would particularly, like to purchase this coin during the course of the ICO and participate in the bounty hunt to make some free coins also. Regretfully, there is not enough info on the LAWesome coin as I assume that it is a ‘behind-the-doors’ project. I ponder why the law firms have suddenly penetrated the sector? This step by the law firms will certainly inject a dose of trustworthiness and stability into the cryptocurrency field.

  3. Hi! I have bumped into a blog comment on this website (can not find the comment so will create a brand-new one) with some interest in the Lawesome coin cryptocurrency. I am one of the designers of the Lawesome coin and I can verify that the Lawesome cryptocurrency is being finalised and will certainly be released throughout the next week. For the time being, you can begin picking up free Lawesome coins by submitting a guest post on https://blog.latestlawjobs.com. I am really overwhelmed by the volume of interest the Lawesome coin has received. I am afraid that I can not reveal any additional details about this groundbreaking cryptocurrency just yet because of our privacy and NDA legal contracts with a couple of other organizations. Do reply to this comment if you have any questions.

​Leave a Comment

Comment authors age:




How I Display Total Post View Count Without Any Plugin For WordPress?

How to Recent Post Show Exclude a Specific Taxonomy?