cPanel/WHM Server imposes a limit on the size of a mysql database that can be imported into phpMyAdmin. The default size is 50MB.
The best way to navigate this limitation is to make some tweaks in the WHM interface. Sometimes editing a php.ini file doesn’t make a difference.
- Log into your WHM interface and type Tweak in the search bar.
The Tweak settings appear, in the find field on the right type: upload size
Change the cPanel PHP max upload size to what you need and save.
Go back to Tweak Settings and in the find bar type: post
Change the cPanel PHP max POST size to what you need
That’s it, now you can import a larger database directly into phpMyAdmin, go back and change back to the default settings if required.