{"id":18393,"date":"2026-09-29T23:17:29","date_gmt":"2026-09-29T20:17:29","guid":{"rendered":"https:\/\/www.hyyat.com\/knowledgebase\/increase-phpmyadmin-upload-size-whm\/"},"modified":"2026-09-29T23:17:29","modified_gmt":"2026-09-29T20:17:29","password":"","slug":"increase-phpmyadmin-upload-size-whm","status":"publish","type":"docs","link":"https:\/\/www.hyyat.com\/en\/knowledgebase\/increase-phpmyadmin-upload-size-whm\/","title":{"rendered":"How to Increase the phpMyAdmin Upload Size on a cPanel Server"},"content":{"rendered":"
In short:<\/strong> To import a larger database in phpMyAdmin on a cPanel server: log in to WHM, go to Server Configuration, then Tweak Settings, open the PHP tab, raise cPanel PHP max POST size and cPanel PHP max upload size, and save. Or edit upload_max_filesize and post_max_size in php.ini over SSH (find its path with php –ini).<\/div>\n

cPanel servers limit the size of a database file you can import in phpMyAdmin (by default around 50 MB). This makes it hard to import a large database. As the server administrator, you can raise this limit from WHM.<\/p>\n

Method 1: from WHM<\/h2>\n

1.<\/strong> Log in to WHM at https:\/\/your-server-ip:2087<\/strong> with your username and password.<\/p>\n

\"WHM<\/p>\n

Logging in with the server hostname (https:\/\/your-server-hostname:2087) is recommended.<\/p>\n

2.<\/strong> Go to Server Configuration<\/strong>.<\/p>\n

\"Server<\/p>\n

3.<\/strong> Click Tweak Settings<\/strong>.<\/p>\n

\"Tweak<\/p>\n

4.<\/strong> Open the PHP<\/strong> tab.<\/p>\n

\"PHP<\/p>\n

Change cPanel PHP max POST size<\/strong> and cPanel PHP max upload size<\/strong> to the values you need, and save. Log in to phpMyAdmin again and you will see the new limit on the Import page.<\/p>\n

Method 2: from the command line<\/h2>\n

1.<\/strong> Connect to your server over SSH (see how to connect to your server over SSH<\/a>):<\/p>\n

ssh root@your-server-ip<\/pre>\n
2.<\/strong> Find the php.ini file in use:<\/p>\n
php --ini<\/pre>\n
3.<\/strong> Open it in a text editor (replace the path with the one shown):<\/p>\n
vi \/path\/to\/php.ini<\/pre>\n
4.<\/strong> Find these lines and set the values you need, then save the file:<\/p>\n
upload_max_filesize = 256M\npost_max_size = 256M<\/pre>\n
5.<\/strong> Restart Apache:<\/p>\n
systemctl restart httpd<\/pre>\n
Related service:<\/strong> Hyyat Host server management<\/a> can adjust your server settings for you, with 24\/7 support.<\/p>\n","protected":false},"excerpt":{"rendered":"
In short: To import a larger database in phpMyAdmin on a cPanel server: log in to WHM, go to Server Configuration, then Tweak Settings, open the PHP tab, raise cPanel PHP max POST size and cPanel PHP max upload size, and save. Or edit upload_max_filesize and post_max_size in php.ini over SSH (find its path with […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"_templately_pack_id":"","_templately_imported_at":"","_templately_source":"","_templately_import_session_id":"","footnotes":""},"doc_category":[2734],"doc_tag":[],"class_list":["post-18393","docs","type-docs","status-publish","hentry","doc_category-whm-cpanel-control-panels"],"year_month":"2026-10","word_count":261,"total_views":"1","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"ahmed fathy","author_nicename":"ahmed-fathy","author_url":"https:\/\/www.hyyat.com\/en\/author\/ahmed-fathy\/"},"doc_category_info":[{"term_name":"whm\/cpanel control panels","term_url":"https:\/\/www.hyyat.com\/en\/kb\/whm-cpanel-control-panels\/"}],"doc_tag_info":[],"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/docs\/18393","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/comments?post=18393"}],"version-history":[{"count":0,"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/docs\/18393\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/media?parent=18393"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/doc_category?post=18393"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/doc_tag?post=18393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}