Hi all! I have a Dell PowerEdge R520 server running debian12 and ispconfig3 I have several personal websites hosted on it for some time I have been trying to restore a database from a former online store based on the prestashop platform when I got to the step of importing the database, I got an error due to the size of 39 mb, I mention that I changed the limit to 250 mb in php.ini, you can also see it here primomob.ro/infophp.php I really don't know what else to change to be able to load the database or the tables in it to be able to restore the online store, You should know that I am an average in Linux, I am not an expert I am waiting for a solution from you, maybe I can solve the problem. My English is not very good, I'm from Romania Thank you for understanding!
Your memory_limit is 128mb, try increasing it to be the same with the other two upload_max_filesize and post_max_size? Also check if the error is due to max_execution_time as it could need more time?
I did and you can check this at primomob.ro.infophp.php also, nothing seems to have changed in phpmyadmin, in the import column, 2MB still appears another solution? what else could I change to get rid of that limitation in phpmyadmin
This means you either missed restarting the php-fpm daemon of that php version or you edited the wrong php.ini file.
the files I edited are in the location: /etc/php/7.4/cgi/php.ini /etc/php/7.4/fpm/php.ini /etc/php/7.4/cli/php.ini where am I wrong
You say you are using Debian 12, so the default PHP version of the OS that phpmyadmin likely uses is PHP 8.2 and not 7.4.
probably, but in ispconfig3 on the primomob.ro website I set it as version 7.4, could it be the problem here? now I will change the limit in: /etc/php/8.2/cgi/php.ini /etc/php/8.2/fpm/php.ini /etc/php/8.2/cli/php.ini
I also modified it for 8.2 but I still don't get rid of the 2MB limit the files I edited are in the location: /etc/php/8.2/cgi/php.ini /etc/php/8.2/fpm/php.ini /etc/php/8.2/cli/php.ini
No, the php version of the website does not matter for PHPMyAdmin. In Debian and Ubuntu, phpmyadmin is a global alias, so it does not run via website php. and did you restart php8.2-fpm service afterwards? service php8.2-fpm restart
I used the command: systemctl php8.2-fpm restart putty displayed the message: Unknown command verb php8.2-fpm. I don't know how to restart it at service
The service command should exist on any Debian 12 system by default. But you can alternatively use systemctl command: systemctl restart php8.2-fpm.service
You must use the right command option order when executing a command on Linux. See my example in post #12
ready, finally I succeeded, I restarted the service with the command you posted above and now the limit in phpmyadmin is 256mb Thank you very much yesterday I searched all day on the internet for the solution to my problem but it was in vain I have received quality support on this forum Thank you very much!
