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.
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.
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
Ok, that’s all. Just follow carefully my instruction step by step. If you will face any problem then you can comment me.