Skip to main content

phpMyAdmin memory limit

outpostmm
I'm trying to change the memory limit for phpMyAdmin, and the file that I'm editing is in /usr/local/cpanel/3rdparty/php/72/etc/phpmyadmin (I can verify that phpMyAdmin claims that the PHP version is 7.2.7). I've also edited the files in the /usr/local/cpanel/3rdparty/php/72/etc directory, just to make sure. After making changes, I ran the /usr/local/cpanel/bin/install_php_inis and then the script to restart cpsrvd. It doesn't look like it's having an effect, though. I have a client trying to do a large export, and I'm trying to change the memory limit from 128M to 1024M. After (and before) doing all of the above, I still see this error, which indicates to me that the memory limit is not 1024M: PHP Fatal error: Out of memory (allocated 408944640) (tried to allocate 400556032 bytes) in Unknown on line 0

Comments

3 comments

Date Votes
  • cPanelMichael
    Hello @outpostmm, The supported method to address this issue is to increase the values for the following options under the "PHP" tab in "WHM >> Tweak Settings": cPanel PHP max upload size cPanel PHP max POST size Is it a large database you are exporting? If so, generally the better option is to export larger databases via the command line: MySQL :: MySQL 5.6 Reference Manual :: 7.4.1 Dumping Data in SQL Format with mysqldump Additionally, I encourage you to vote for the following feature request if you'd like to see an option to do this in cPanel & WHM: PHPMyAdmin - Editing Memory Limit, Max Input Vars, Upload Size, & Other Settings via WHM Thank you.
    0
  • outpostmm
    Will increasing the max upload size affect the memory limit as well, does WHM apply one of those options as the memory limit? If not, is there any other way to increase it? The database is about 17GB, although our customer is only trying to export one table, which is about 1.5GB. We don't have SSH open for anyone except our office, and this is for a customer so we can't do a command line export in this case. In this case this is a server that we have dedicated to a single client, and we gave them a separate account where every night it will copy the database (via shell commands via cron) from their production application to a secondary account for them to log in to via cPanel to access the database. I've tried to also allow them to connect remotely so they can set up an ODBC connection or other access that way, but I'm not sure if that's working for them yet. But they wanted the database to do their own reporting so we gave them a copy so they can't mess up the production database, but we don't allow SSH access to the server LAN in the data center. I'll take a look at the new feature request and vote.
    0
  • cPanelMichael
    Will increasing the max upload size affect the memory limit as well, does WHM apply one of those options as the memory limit? If not, is there any other way to increase it?

    Increasing those settings is often required in addition to increasing the memory limit. To increase the memory limit itself, increase (or set to unlimited) the following value under System in WHM >> Tweak Settings: Max cPanel process memory Keep in mind the memory limit is designed to prevent a specific process or event from using up the available memory on a system. A 1.5G table is generally too large to import or export via phpMyAdmin. If command line access to export the database isn't possible, then manually installing phpMyAdmin as an independent installation under the domain is the other approach you can take. By installing a separately managed phpMyAdmin instance on the domain, you will have more control over the memory limit (it will run under the server's Apache/PHP installation instead of cpsrvd). Thank you.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post