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 database problem

Discussion in 'Plesk for Linux - 8.x and Older' started by drogatoo, Mar 25, 2008.

  1. drogatoo

    drogatoo Guest

    0
     
    Hy,
    one of my clients is trying to export a database that has a table of 31M in size, but he can't.When he tries to export it to a file he receives a file of 0 bytes in size.Also when he exports it in plain text in the browser he gets a blank page.
    I've managed to dump it in the shell but i cannot give the client access to the shell, he must do it through phpmyadmin.
    I've tried several tweaks to the php.ini but with no result.
    Here are the settings that I've tried to modify from php.ini
     
  2. XoNNiX

    XoNNiX Guest

    0
     
    I have the same problem!
     
  3. boonies

    boonies Guest

    0
     
    Same problem here - anyone have any ideas?
     
  4. tiramisu_

    tiramisu_ Guest

    0
     
    yes, there is such issue with large databases,
    this has been already reported to Plesk developers, but no update/workaround yet
    i hope this will be fixed soon in future Plesk versions.
     
  5. XoNNiX

    XoNNiX Guest

    0
     
    Yeah, i hope so!

    Mine is 22mb gziped and 100mb as .sql(txt) . :)

    Waiting for an update!

    This is urgent... :)
     
  6. lavinya

    lavinya New Pleskian

    22
    73%
    Joined:
    Dec 28, 2007
    Messages:
    19
    Likes Received:
    0
    I have the same problem. Please help me.
     
  7. sahinler

    sahinler Basic Pleskian

    24
    73%
    Joined:
    Apr 26, 2007
    Messages:
    46
    Likes Received:
    0
    I have the same problem

    I have the same problem

    Here, we are 5 now ?:)
     
  8. lavinya

    lavinya New Pleskian

    22
    73%
    Joined:
    Dec 28, 2007
    Messages:
    19
    Likes Received:
    0
    Here my fix:

    1. Open your plesk php.ini (my plesk php.ini located: /usr/local/psa/admin/conf/php.ini)
    2. Find memory_limit change to example: memory_limit = 256M
    3. Stop and start psa services: /etc/init.d/psa stopall , /etc/init.d/psa start


    i have centos linux 5.1, plesk 8.3 linux, 4096 DDRII ram, core duo 2 cpu..
     
  9. drogatoo

    drogatoo Guest

    0
     
    Thanks that did the trick for me, I can export the database now.Never thought that the value should be that large.
     
  10. ElviCities

    ElviCities Guest

    0
     
    Thanks lavinya for the quick fix, it was a lifesaver!
     
  11. lavinya

    lavinya New Pleskian

    22
    73%
    Joined:
    Dec 28, 2007
    Messages:
    19
    Likes Received:
    0
    drogatoo, ElviCities;

    Ok i happy. :)
     
Loading...