When importing large MySQL database files, you may need to increase the maximum upload size limit in cPanel. This guide shows you how to adjust the PHP upload size setting through WHM's Tweak Settings interface, allowing you to import database files up to 2,047 MB.
How to do it
-
Step 1: Access WHM
Log in to your WHM with root access.
-
Step 2: Search for Tweak Settings
In the search bar at the top of WHM, enter "Tweak" to locate the Tweak Settings option.
-
Step 3: Open Tweak Settings
Click on "Tweak Settings" from the search results.
-
Step 4: Find the upload size setting
In the Tweak Settings page, use the search field to locate "upload size".
-
Step 5: Adjust and save the setting
Set the cPanel PHP maximum upload size to your desired value. You can choose any value between 50 and 2,047 MB. Click the Save button to apply the changes.
The system may take some time to apply these changes, depending on server conditions. Once complete, you can proceed to upload your database without any issues.