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

  1. Step 1: Access WHM

    Log in to your WHM with root access.

    WHM login

  2. Step 2: Search for Tweak Settings

    In the search bar at the top of WHM, enter "Tweak" to locate the Tweak Settings option.

    Search for Tweak

  3. Step 3: Open Tweak Settings

    Click on "Tweak Settings" from the search results.

    Tweak Settings

  4. Step 4: Find the upload size setting

    In the Tweak Settings page, use the search field to locate "upload size".

    Search for upload size

  5. 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.

    Save settings

    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.