\nHow to Increase Upload Size for MySQL Database via WHM<\/strong><\/a> is a common question among server administrators and hosting users who need to import large MySQL database files. By default, cPanel and phpMyAdmin have upload limits that may prevent users from importing larger database backups, website migrations, or application databases.<\/p>\n
When the database file exceeds the configured upload limit, users may encounter upload errors or failed imports. Fortunately, WHM provides an easy way to increase the PHP upload size using the Tweak Settings interface.<\/p>\n
In this guide, you’ll learn how to increase the MySQL database upload size through WHM in just a few simple steps.<\/p>\n
Why Increase MySQL Database Upload Size?<\/h3>\n
Large database imports are common when:<\/p>\n
- \n
- Migrating websites<\/li>\n
- Restoring backups<\/li>\n
- Importing eCommerce databases<\/li>\n
- Moving WordPress websites<\/li>\n
- Transferring applications between servers<\/li>\n<\/ul>\n
If the upload size limit is too low, phpMyAdmin may reject the database file during import.<\/p>\n
Increasing the upload size allows larger SQL files to be uploaded successfully.<\/p>\n
Prerequisites<\/h3>\n
Before proceeding, ensure that:<\/p>\n
\u2714 You have Root Access to WHM<\/p>\n
\u2714 WHM is functioning properly<\/p>\n
\u2714 The server has sufficient disk space available<\/p>\n
\u2714 You have administrative privileges<\/p>\n
Step 1: Log in to WHM<\/h3>\n
Common WHM login URLs include:<\/p>\n
- \n
- https:\/\/yourdomain.com:2087<\/a><\/li>\n
- https:\/\/server-ip-address:2087<\/a><\/li>\n<\/ul>\n
Enter your WHM username and password to log in.<\/p>\n
Once authenticated, you’ll be redirected to the WHM dashboard.<\/p>\n
Step 2: Search for Tweak Settings<\/h3>\n
At the top-left search bar inside WHM:<\/p>\n
Type:
Tweak<\/code><\/p>\n\n\n\n\n\nWHM will display matching configuration options.<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\nLocate: Tweak Settings<\/strong><\/p>\n
Click on it to open the server configuration page.<\/p>\n
![\"type-tweak\"](\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/type-tweak-1024x615.webp\")
<\/p>\nStep 3: Open Tweak Settings<\/h3>\n
After clicking Tweak Settings<\/strong>, you’ll be redirected to the server-wide configuration interface.<\/p>\n
This section allows administrators to modify various cPanel and WHM settings.<\/p>\n
![\"tweak-settings\"](\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/tweak-settings-1024x564.webp\")
<\/p>\n<\/h3>\n
Step 4: Search for Upload Size<\/h3>\n
Inside the Tweak Settings page, locate the:<\/p>\n
Find<\/strong> search box.<\/p>\n
Type:
upload size<\/code><\/p>\n\n\n\n\n\nWHM will automatically highlight the related configuration field.<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\nLook for: cPanel PHP Max Upload Size<\/strong><\/p>\n
![\"find-box-upload-size\"](\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/find-box-upload-size-1024x482.webp\")
<\/p>\n<\/h3>\n
Step 5: Increase the Upload Limit<\/h3>\n
You will see the setting:<\/p>\n
cPanel PHP Max Upload Size<\/h4>\n
The allowed range is:<\/p>\n
- \n
- Minimum: 50 MB<\/li>\n
- Maximum: 2047 MB<\/li>\n<\/ul>\n
Enter your preferred upload size.<\/p>\n
Examples:<\/p>\n
- \n
- 128 MB<\/li>\n
- 256 MB<\/li>\n
- 512 MB<\/li>\n
- 1024 MB<\/li>\n
- 2047 MB<\/li>\n<\/ul>\n
Choose a value based on the size of the database you intend to import.<\/p>\n
Step 6: Save the Changes<\/h3>\n
After updating the upload size value:<\/p>\n
Click: Save<\/strong><\/p>\n
![\"how-to-increase-upload-size-for-mysql-database-via-whm\"](\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/save-4.webp\" "\\"how-to-increase-upload-size-for-mysql-database-via-whm\\"")
<\/p>\nWHM will begin applying the new configuration.<\/p>\n
Depending on server load and environment settings, the changes may take a few moments to become active.<\/p>\n
Verify the New Upload Limit<\/h3>\n
After saving:<\/p>\n
- \n
- Log in to cPanel.<\/li>\n
- Open phpMyAdmin.<\/li>\n
- Click the Import tab.<\/li>\n<\/ol>\n
You should now see the updated maximum upload size displayed on the import page.<\/p>\n
This confirms the configuration has been successfully applied.<\/p>\n
Common Reasons for Increasing Upload Limits<\/h3>\n
Website Migration<\/h4>\n
Import large WordPress, Joomla, Magento, or custom application databases.<\/p>\n
Backup Restoration<\/h4>\n
Restore complete database backups without splitting SQL files.<\/p>\n
eCommerce Stores<\/h4>\n
Large WooCommerce, OpenCart, PrestaShop, and Magento databases often require higher upload limits.<\/p>\n
Development Projects<\/h4>\n
Import staging or production databases efficiently.<\/p>\n
Why Use WHM Tweak Settings?<\/h4>\n
WHM Tweak Settings offers a centralized and easy way to manage:<\/p>\n
- \n
- PHP Upload Limits<\/li>\n
- Server Configuration<\/li>\n
- cPanel Settings<\/li>\n
- Performance Options<\/li>\n
- Security Preferences<\/li>\n<\/ul>\n
Instead of manually editing configuration files, administrators can make changes directly from the WHM interface.<\/p>\n
Conclusion<\/h4>\n
The How to Increase Upload Size for MySQL Database via WHM<\/strong> process is simple and can be completed through WHM’s Tweak Settings section. By increasing the cPanel PHP Max Upload Size value, you can successfully import larger MySQL databases through phpMyAdmin without encountering upload restrictions.<\/p>\n
This configuration is especially useful for website migrations, database restorations, and large application deployments.<\/p>\n","protected":false},"excerpt":{"rendered":"
How to Increase Upload Size for MySQL Database via WHM Introduction:\u00a0 How to Increase Upload Size for MySQL Database via WHM is a common question among server administrators and hosting users who need to import large MySQL database files. By default, cPanel and phpMyAdmin have upload limits that may prevent users from importing larger database […]<\/p>\n","protected":false},"author":6,"featured_media":12867,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,3],"tags":[],"class_list":["post-12847","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-latest-updates","category-whm-panel"],"_links":{"self":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/12847","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/comments?post=12847"}],"version-history":[{"count":5,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/12847\/revisions"}],"predecessor-version":[{"id":12904,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/12847\/revisions\/12904"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/media\/12867"}],"wp:attachment":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/media?parent=12847"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/categories?post=12847"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/tags?post=12847"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- https:\/\/server-ip-address:2087<\/a><\/li>\n<\/ul>\n
- https:\/\/yourdomain.com:2087<\/a><\/li>\n