How Import Large Database in XAMPP & WAMP phpmyadmin

Facebook Twitter Email Whatsapp

Hello Every One Welcome to Digital Magnate Blog post. In this Blog We Learn  How to Import Large Database in XAMPP & WAMP  phpmyadmin.

In General once you Trying to import large database in (XAMPP & WAMP) MySQL (phpmyadmin)  with a file size more than 20MB. MySQL will reject the uploaded file with an error(You probably tried to upload too large file). This Type of  Error occurs due to uploading large MySQL file, Just of Because “execution time” or “post max time” errors come in PHP. So Learn how to upload large database in XAMPP & WAMP phpmyadmin. you have to follow these Steps.

if you are facing the error “ refer this blog for increase the limit of upload size in Phpmyadmin.”

• .Increase max_execution_time in PHP.
• .Increase max_input_time in PHP..
• .Increase memory_limit  for PHP.
• .Increase upload_max_filesize in PHP.
• .Increase post_max_size in PHP.

#1. Increase max_execution_time in PHP:

 go to folder PHP in Xampp URl:-  C:/xampp/php

 Open php.ini file in Notepad for Windows.

 Find max_execution_time = 30 in PHP and Replace it with max_execution_time = 259200 (Time you can Customize according to You.)

#2. Increase max_input_time in PHP:

  go to folder PHP in Xampp URl:-  C:/xampp/php

  Open php.ini file in Notepad for Windows.

  Find max_input_time = 30 in PHP and Replace it with max_input_time = 259200 (Time you can Customize according to You.)

#3. Increase memory_limit  for PHP:

  go to folder PHP in Xampp URl:-  C:/xampp/php

  Open php.ini file in Notepad for Windows.

  Find memory_limit = 20M in PHP and Replace it with memory_limit = 1000M (Memory size you can Customize according to You.)

#4. Increase upload_max_filesize in PHP:

   go to folder PHP in Xampp URl:-  C:/xampp/php

  Open php.ini file in Notepad for Windows.

  Find upload_max_filesize = 20M in PHP and Replace it with upload_max_filesize = 750M (file size you can Customize according to You.)

#5. Increase post_max_size in PHP:

  go to folder PHP in Xampp URl:-  C:/xampp/php

  Open php.ini file in Notepad for Windows.

  Find post_max_size = 20M in PHP and Replace it with post_max_size = 750M (file size you can Customize according to You.)

Here the Example for updating the Php.ini. 

Open php.ini file from C:/xampp/php Update following lines

max_execution_time = 259200

max_input_time = 259200

memory_limit = 1000M

upload_max_filesize = 750M

post_max_size = 750M

once update following changers in Php.ini  restart Xampp/Wamp server or restart all services. Now  Try Upload data using import function in phpmyadmin. here you can See the limit has been increased.

I hope you understand How Import Large Database in XAMPP & WAMP phpmyadmin.. if you like Our Blog then do share and Don't Forget to Subscribe our Channel. Thanks for Here...

You Are Free To Ask The Questions By Commenting.

k𝗶𝗻𝗱𝗹𝘆 𝘀𝘂𝗯𝘀𝗰𝗿𝗶𝗯𝗲 𝘁𝗼 𝗼𝘂𝗿 𝗰𝗵𝗮𝗻𝗻𝗲𝗹 𝗳𝗼𝗿 𝗺𝗼𝗿𝗲 𝘃𝗶𝗱𝗲𝗼𝘀

Click here ➜ https://www.youtube.com/c/Digitalmagnate

𝗪𝗮𝘁𝗰𝗵 𝗼𝘂𝗿 𝗼𝘁𝗵𝗲𝗿 𝘃𝗶𝗱𝗲𝗼𝘀  ➜ https://www.youtube.com/c/Digitalmagnate/videos

Follow us on Social Media.

Facebook:- https://www.facebook.com/Magnatedigital

Blog:-  https://digitalmagnate.blogspot.com/

Instagram:- https://www.instagram.com/digimagnate/

youtube:-https://www.youtube.com/c/Digitalmagnate/videos?sub_confirmation=1

𝗞𝗶𝗻𝗱𝗹𝘆 𝘀𝘂𝗯𝘀𝗰𝗿𝗶𝗯𝗲 𝘁𝗼 𝗼𝘂𝗿 𝗰𝗵𝗮𝗻𝗻𝗲𝗹 𝗳𝗼𝗿 𝗺𝗼𝗿𝗲 𝘃𝗶𝗱𝗲𝗼𝘀

Click here ➜https://www.youtube.com/c/Digitalmagnate/videos?sub_confirmation=1

More Video link:-

How to install fb chat in website:- https://youtu.be/BV0NxcIsA5g

How to delete YouTube search history:- https://youtu.be/u-5dppiUeRI

How To Set Auto on-off function in android :-https://youtu.be/AbepiglSCbM

How to solve timeout error in google chrome:- https://youtu.be/MSHCSFxMw4Q

Social media link in google:- https://youtu.be/yrkxLuwerEE

𝗪𝗮𝘁𝗰𝗵 𝗼𝘂𝗿 𝗼𝘁𝗵𝗲𝗿 𝘃𝗶𝗱𝗲𝗼𝘀  ➜https://www.youtube.com/c/Digitalmagnate/videos?sub_confirmation=1

Want your own website? E-mail us your requirements to gosocialmakedigital@gmail.com