The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Phpmyadmin Cpanel - Not able to export as MSExcel format

Discussion in 'Database Discussions' started by astalvista, Nov 21, 2010.

  1. astalvista

    astalvista Registered

    Joined:
    Nov 21, 2010
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Hi,

    I am not able to export mysql DB from phpmyadmin which is installed along with cpnael as MS EXCEL format.Only this format is not working. Remaining all formats working fine. Why is this happening?

    I am getting error:

    Error: <br />
    <b>Fatal error</b>: Out of memory (allocated 253231104) (tried to
    allocate 16 bytes) in
    <b>/usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/PHPExcel/PHPExcel/Worksheet.php</b>
    on line <b>942</b><br />

    I have increased the memory_limit in php.ini file to 1024MB also.even though no luck.:(

    Can someone help me with regard to this?:)

    Thanks in advance,
    Astal
     
  2. portal85

    portal85 Registered

    Joined:
    Nov 22, 2010
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    I have exact same issue. I definately do not believe it is a memory issue. Please assist us. :)
     
  3. marslert

    marslert Member

    Joined:
    May 23, 2006
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    I have this problem as well.

    Any idea?
     
  4. kotakomputer

    kotakomputer Member

    Joined:
    Mar 21, 2010
    Messages:
    24
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Jakarta, Indonesia
    I'm facing same issue but regarding to Import from Excel. I see there are empty columns in the middle of Excel table then delete them. Now Excel import working fine.

    If you believe this is not a memory issue then try to Export/Import only small rows and see if this issue occurs. HTH.
     
  5. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,461
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
  6. sinys_85

    sinys_85 Member

    Joined:
    Jan 28, 2010
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Hi guys! Have anybody found the troubleshooting?
     
  7. garconcn

    garconcn Well-Known Member

    Joined:
    Oct 29, 2009
    Messages:
    98
    Likes Received:
    1
    Trophy Points:
    8
  8. cPanelDavidN

    cPanelDavidN Integration Developer
    Staff Member

    Joined:
    Dec 17, 2009
    Messages:
    571
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Hi garconcn,

    I believe this is still a problem. It may be due to the leak mentioned in Issue #13151 or another, unknown, leak. Or, it may be just a limitation revolving our the design of the export functionality and the fact the data vs. Excel format.

    I personally think it's a combination of both. I would recommend exporting a CSV file and importing that into Excel. If you do that, at least you're guaranteed to extract all the data from the phpMyAdmin export function. Otherwise, the Excel2000 writer in phpMyAdmin will truncate at approximately 65k rows due to the limitation within the Excel 2000 format.

    -DavidN
     
  9. garconcn

    garconcn Well-Known Member

    Joined:
    Oct 29, 2009
    Messages:
    98
    Likes Received:
    1
    Trophy Points:
    8
    Thanks for this. I am able to export it to csv or xml.
     
Loading...

Share This Page