Nimble Freelancer

Work from home tips. Passive income path.

SEMrush
  • Home
  • About Us
  • Terms and Conditions
  • Privacy Policy
  • Contact

Steps to Increase Max Import Size Limit in phpMyAdmin – import large sql files

by freelancer

How can I increase the max upload file limit in PhpMyAdmin? I wanted to change the 50 MB limit and increase it to 200 Mb, only to import few large SQL files. I tried to find answers on the internet, and I saw many complicated solutions, part true answers, etc.
So if you own a server and if you can manage Cpanel and WHM, then you can do this easily.

Step 1:
Change in PHP.ini section of WHM (Home »Service Configuration »PHP Configuration Editor):

SEMrush

upload_max_filesize : 200MB
max_execution_time 240 (this is not important, but large files need more time to load – I set 6 minutes)
max_input_time 240 (this is not important, but large files need more time to load – I set 6 minutes)
post_max_size = 200 MB

Step 2:
We need to change the 50MB limit in the PhpMyAdmin section. We need to go in WHM in the Tweak settings section (Main >> Server Configuration >> Tweak Settings ) :

cPanel PHP max execution time 240
cPanel PHP max POST size 200
cPanel PHP max upload size 200

SEMrush

When you finish upload, then you put in default values.

Related posts:
  1. Steps How to stop Friend Requests on Facebook
  2. How to Increase Youtube Subscribers For Free?
  3. The Best SEO Tool to Increase Your Traffic
  4. How to transfer your WordPress blog to new domain ?
  5. How to disable auto reboot after Windows Update – Disable restart after update
  6. How to fix problem – Sorry we couldn’t connect to skype – solved
  7. How to shrink or cleanup the winsxs folder in Windows 7 or Windows Server 2003 or Windows Server 2008
  8. What is Virtual Private Server VPS hosting ?
  9. How to fix Jetpack glitch xml_rpc-32700 – solved
  10. Server Migration Meaning and Video Example

Filed Under: Featured, Jobs

SEMrush
SEMrush

Categories

  • Active Income
  • Advertising
  • Amazon
  • Apps
  • Business
  • Computer
  • Ebay
  • Ecommerce
  • Education
  • Facebook
  • Featured
  • Formal education
  • Freelance
  • Freelancer
  • Gadgets
  • Gaming
  • Graphic Design
  • Grocery Business
  • Home
  • Industry
  • Internet
  • Investing
  • Jobs
  • Knowledge
  • Law
  • Legal
  • Life
  • Marketing
  • Mobile Phone
  • Money
  • Network
  • Network
  • Passive income
  • Personal Finance
  • Rights
  • Sales Funnels
  • SAP
  • Selling physical products
  • SEO
  • Software
  • Technology
  • Uncategorized
  • Windows
  • wordpress
  • Work
  • Work From Home
  • Writing
  • Youtube
  • Home
  • About Us
  • Terms and Conditions
  • Privacy Policy
  • Contact

Recent Posts

  • Use 401k to Buy House
  • What is the Maximum Social Security Benefit in the US?
  • How Much is 3/4 Cup?
  • How to Order Sweet Cream on Starbucks App?
  • How Long Is a Million Seconds?

Copyright Nimblefreelancer.com 2020

Privacy Policy - Terms and Conditions