Author Topic: Maximum Upload size of phpMyAdmin  (Read 20384 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Maximum Upload size of phpMyAdmin
« on: January 16, 2018, 01:20:44 PM »
Hi,

The default setting for uploading dbase file says 64MiB in phpmyadmin.  Great.  I went to php.ini and changed it up to 500MB, saved it and then restarted apache.  No change  Still says 64MiB.  Why isnt my change taking effect?

post_max_size  500M
upload_max_filesize 500M

In my PHP Info, its showing 500Mb but in my phpadmin page its showing only (Max: 64MiB)

Someone please help me to solve this isue

Offline
***
Re: Maximum Upload size of phpMyAdmin
« Reply #1 on: January 17, 2018, 06:51:29 AM »
Change post_max_size too with the same value and check if it's reflected in phpMyAdmin or not.
https://www.24x7servermanagement.com/
Server Management, Server Security, Server Monitoring.
India's Leading Managed Service Provider !!

Offline
*
Re: Maximum Upload size of phpMyAdmin
« Reply #2 on: February 13, 2018, 09:16:05 PM »
Hi to all,
I'm durign a migration, and analized all servers configuration files:
/usr/local/cwpsrv/var/services/pma/*
/use/share/mysql/*

It's from 7 days that I lost my mind to discover where phpmy admin get 64Mib

I changed also php.ini postmax size, but it no want read values.
I discovered that in phpmyadmin folder, in file import.php, it call variables name "max_file_size" and not "post_max_size",
readed all articles online, 38, regarding mariadb in relation of the variable  "max_allowed_packet= " in my.cnf.

I also change the variabel name in all files in /pma folder from "max_file_size" to "post_max size", and for absurd it calling yet 64Mib!!!!!! Normaly have to show error, or call the post_max_size, but no it don't want do....


I'm very afraid, it's 9 days to migrate a wordpress e-commerce with a 250m database.
Losting my customer, or need find one new panel...

PS: tryed to import too by ssh  and terminal too, and databse in other servers can be imported without problem
« Last Edit: February 13, 2018, 09:20:32 PM by HRian »

Offline
*
Re: Maximum Upload size of phpMyAdmin
« Reply #3 on: February 13, 2018, 10:54:04 PM »
try checking here
http://wiki.centos-webpanel.com/configuration-files

phpMyAdmin (MySQL Database manager)
php server configuration: /usr/local/cwp/php71/php.ini
script location: /usr/local/cwpsrv/var/services/pma/
VPS & Dedicated server provider with included FREE Managed support for CWP.
http://www.studio4host.com/

*** Don't allow that your server or website is down, choose hosting provider with included expert managed support for your CWP.


Offline
*
Re: Maximum Upload size of phpMyAdmin
« Reply #5 on: February 14, 2018, 04:14:21 PM »
Thank you,
this fix.

service cwp-phpfpm restart


Also if you edit php.ini in centos web panel, and restart mysql and apache, after you have to restart too phpfpm.

Thank you very much to all

Kind Regards,