Freelancer job part time jobs

Freelancer jobs offer, job advice, freelance tips, employment advice. Find programmers jobs, software development jobs, freelance writer jobs, projects jobs for work from home.

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

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

June 5, 2015 by Freelance

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

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

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 50MB limit in PhpMyAdmin section.We need to go in WHM in 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

When you finish upload than you put in default values.

How to transfer your WordPress blog to new domain ?
How to disable auto reboot after Windows Update – Disable restart after update
How to fix problem – Sorry we couldn’t connect to skype – solved
How to fix Jetpack glitch xml_rpc-32700 – solved
How to shrink or cleanup the winsxs folder in Windows 7 or Windows Server 2003 or Windows Server 2008
What is Virtual Private Server VPS hosting ?
Retention Guarantee in Contracts
How to use Search Queries in Webmaster Tools
How to remove Fast Start adware from Mozilla Firefox
How to earn money as freelancer ?
How to fix Metadata staging failed problem in Windows 10 in 1 minute ?

Filed Under: Featured, Jobs

Navigation

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

Recent articles

  • What is Clickfunnels ?
  • Organic Keyword Research Tool – How to Find Competitors Keywords
  • Why my website does not appear in google search ?
  • What are semantically related keywords ?
  • How to Choose Long Tail Keywords
Copyright freelancer-job.com 2007.

Terms and Conditions - Privacy Policy