i cant Import more 50 MB phpmyadmin

[bt4]

i cant Import more 50 MB phpmyadmin
how i can edit this for more 50 MB ?
thanks

[cPanelTristan]

Do you have direct root SSH access to the machine? If you do not, then you won't be able to change the setting.

If you do, then it is the following setting in /usr/local/cpanel/3rdparty/etc/phpmyadmin/php.ini file:

upload_max_filesize = 50M

Thanks.

[bt4]

yes i have root access and i change it after restart mysql and restart server nothing changed !

[cPanelTristan]

Can you do a search for all php.ini files on the machine?

find /usr -name php.ini

[bt4]

/usr/lib/php.ini
/usr/php4/lib/php.ini
/usr/local/lib/php.ini
/usr/local/php4/lib/php.ini
/usr/local/cpanel/3rdparty/etc/roundcube/php.ini
/usr/local/cpanel/3rdparty/etc/phppgadmin/php.ini
/usr/local/cpanel/3rdparty/etc/php.ini
/usr/local/cpanel/3rdparty/etc/phpmyadmin/php.ini
/usr/local/cpanel/3rdparty/etc/horde/php.ini

from file /usr/local/cpanel/3rdparty/etc/php.ini
i can edit but cant edit to more 55M it mean when i insert 90 MB it just show 55 MB from phpmyadmin
when i edit to under 55 MB it edited from phpmyadmin

now i ask why i can edit to more 55 MB

[LinuxTechie]

Hello,

You also need to increase the value for post_max_size.

This will work out!

[crazyaboutlinux]

yes, You would also need to increase the value for post_max_size.

which is located at /usr/local/lib/php.ini

take a backup of this file for safer side

# cp /usr/local/lib/php.ini /usr/local/lib/php.ini.BKP

vi /usr/local/lib/php.ini
; Maximum size of POST data that PHP will accept.
post_max_size = 50M

[bt4]

i did! but nothing changed from phpmyadmin

[cPanelTristan]

Editing the global php.ini at /usr/local/lib/php.ini does not increase values in the internal PHP for cPanel for PhpMyAdmin. You have to edit the internal php.ini, which apparently it is reading from /usr/local/cpanel/3rdparty/etc/php.ini rather than /usr/local/cpanel/3rdparty/etc/phpmyadmin/php.ini one.

[davejames]

Dear,

After login in your PHPMyAdmin panel.

Click on your database on top left, and then Click on SQL.

There you can past and copy the tabels one by one in that form. And Click start to upload.

I use this method, its the best.

Goodluck,
Dave.