Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    439
    Likes Received:
    0
    Trophy Points:
    166
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. stdout

    stdout Well-Known Member

    Joined:
    Apr 10, 2003
    Messages:
    189
    Likes Received:
    6
    Trophy Points:
    168
    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>"
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. webstyler

    webstyler Well-Known Member

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

    but nothing change..
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice