1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

phpmyadmin export db memory exhausted

Discussion in 'Plesk 9.x for Linux Suggestions and Feedback' started by argonius, Apr 28, 2010.

  1. argonius

    argonius Basic Pleskian

    18
    85%
    Joined:
    Apr 28, 2010
    Messages:
    57
    Likes Received:
    0
    Hi,

    I am running Plesk 9.3.0. While trying to export a huge database (110MB) over phpmyadmin I received the following error in the error.log:
    FastCGI-stderr: PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 152969079 bytes) in Unknown on line 0

    I also upgraded phpmyadmin like described on kb.odin.com, but there is no change in behaviour. Still the same error.
    If I set the memory_limit from 256MB up to 512MB it takes a long time until my browser freezes (Firefox 3.5) I think there is something wrong, but I can not really imagine what it could be.

    OS: Centos 5.4
    Plesk: 9.3.0 (direct install, not upgraded from prior versions!)
    PhpMyAdmin: 2.11.9.5

    hope someone has a clue.

    Thanks,
    Patrick
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,564
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
  3. argonius

    argonius Basic Pleskian

    18
    85%
    Joined:
    Apr 28, 2010
    Messages:
    57
    Likes Received:
    0
    thanks but

    this will not solve the problem, cause phpmyadmin in plesk is not using /etc/php.ini

    also php parameters like memory_limit, max_execution_time, post_max_size and upload_max_filesize are already increased. There must be another solution.

    thanks, patrick
     
  4. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,564
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    There are two PHP in Plesk - one for Plesk admin interface (lighttpd) and one for client's sites (Apache):

    Plesk admin's php:

    /usr/local/psa/admin/bin/php
    /usr/local/psa/admin/conf/php.ini

    Client's php:

    /usr/bin/php
    /etc/php.ini

    Phpmyadmin uses Plesk admin's PHP. Therefore you should tune /usr/local/psa/admin/conf/php.ini
     
  5. argonius

    argonius Basic Pleskian

    18
    85%
    Joined:
    Apr 28, 2010
    Messages:
    57
    Likes Received:
    0
    thanks but

    i already have knowen this. as i wrote in my previous post, i already increased the php parameters for phpmyadmin (so i did it in /usr/local/psa/admin/conf/php.ini. I also build a info.php file in the plesk phpmyadmin directory. this shows me on calling high values for memory_limit, post_max_size, etc...
    so as i also wrote, if i increase memory_limit up to 512mb my firefox will wait a long time for a response from phpmyadmin and then freezes! there must be a bug or something. simply tuning php config values will not do the trick.

    thanks, patrick

    ps:
    if you want, you can have a look on the server?
     
  6. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,564
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    Contact support team if you want to check it on your server. If it is really bug, you will be refunded for ticket.
     
  7. argonius

    argonius Basic Pleskian

    18
    85%
    Joined:
    Apr 28, 2010
    Messages:
    57
    Likes Received:
    0
    hmm

    thanks, but not really helpful ...
     
  8. ProWebS

    ProWebS Regular Pleskian

    23
    57%
    Joined:
    Mar 23, 2010
    Messages:
    118
    Likes Received:
    0
    argonius, did you find any solution for this? I have the same problem.
     
Loading...