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.

Mysql 5 - #5 - Out of memory (Needed 1677360 bytes)

Discussion in 'General Discussion' started by webstyler, Dec 12, 2008.

  1. webstyler

    webstyler Well-Known Member

    Joined:
    Nov 20, 2003
    Messages:
    432
    Likes Received:
    0
    Trophy Points:
    16
    Hello

    I have migrate any sites to new server, where there is mysql 5

    Centos 5
    WHM/Cpanel

    When I try to open phpmyadmin I see this :/

    query SQL:

    SHOW CHARACTER SET;

    #5 - Out of memory (Needed 1677360 bytes)

    --

    ??

    Thanks
     
  2. stdout

    stdout Well-Known Member

    Joined:
    Apr 10, 2003
    Messages:
    189
    Likes Received:
    5
    Trophy Points:
    18
    Location:
    Nelspruit, Mpumalanga, South Africa
    cPanel Access Level:
    Root Administrator
    Try adding the "quick" flag/variable to the server-wide my.cnf.
    You can test whether using quick will remedy this by connecting to the database from CLI.
    eg. "mysql --quick <database_name>"
     
  3. webstyler

    webstyler Well-Known Member

    Joined:
    Nov 20, 2003
    Messages:
    432
    Likes Received:
    0
    Trophy Points:
    16
    we give
    mysql --quick mydb_name
    from CLI

    but nothing change..
     
Loading...

Share This Page