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!

Sql error on hostname.err

Discussion in 'Database Discussion' started by webstyler, Feb 11, 2009.

  1. webstyler

    webstyler Well-Known Member

    Joined:
    Nov 20, 2003
    Messages:
    439
    Likes Received:
    0
    Trophy Points:
    166
    Hello

    I've found many of this error on hostname.err

    090203 4:00:32 [ERROR] /usr/sbin/mysqld: Incorrect key file for table '/tmp/#sql_1605_0.MYI'; try to repair it

    Any info about this ?

    This table/db not exist.. can be temporary table ?

    Thanks
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. Ghulam Yaseen

    Ghulam Yaseen Well-Known Member

    Joined:
    Mar 14, 2008
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    56
    Location:
    Karachi,Pakistan
    regarding mysqld server stop

    Hello :),

    Can you please try repair the database/table using these command

    --> myisamchk -r /var/lib/mysql/database_name/*.MYI

    --> updatedb

    --> pkill -9 mysqld

    and then try restart the mysql server:cool:.

     
  3. webstyler

    webstyler Well-Known Member

    Joined:
    Nov 20, 2003
    Messages:
    439
    Likes Received:
    0
    Trophy Points:
    166
    I don't now the db name

    The table indicated not exist
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. webstyler

    webstyler Well-Known Member

    Joined:
    Nov 20, 2003
    Messages:
    439
    Likes Received:
    0
    Trophy Points:
    166
    any suggest ?

    We haven't found solutions at this time

    Thanks
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. nilesh_kolte

    nilesh_kolte Well-Known Member

    Joined:
    Apr 13, 2006
    Messages:
    65
    Likes Received:
    0
    Trophy Points:
    156
    Location:
    Pune ,India
    cPanel Access Level:
    Root Administrator
    Hello,

    /tmp/#sql_XXX.MYI tables are temporary tables used to help execute a query. MySQL really needs to create such tables. Please read about EXPLAIN at

    http://dev.mysql.com/doc/refman/5.0/en/explain.html

    try

    Table 'CHARACTER_SETS' in mysql database is marked as crashed and should be repaired.

    It will fix the issue.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. webstyler

    webstyler Well-Known Member

    Joined:
    Nov 20, 2003
    Messages:
    439
    Likes Received:
    0
    Trophy Points:
    166
    Hi

    check table CHARACTER_SETS

    Result:
    information_schema.CHARACTER_SETS
    error
    Table upgrade required. Please do "REPAIR TABLE `/...

    --

    I try to repair table character_sets from phpmyadmin but get error
    #1044 - Access denied for user 'root'@'localhost' to database 'information_schema'

    --

    Tx
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. nilesh_kolte

    nilesh_kolte Well-Known Member

    Joined:
    Apr 13, 2006
    Messages:
    65
    Likes Received:
    0
    Trophy Points:
    156
    Location:
    Pune ,India
    cPanel Access Level:
    Root Administrator
    Hello,

    You will need to repair it from your Root shell access.Run the following commands from your Shell or from the root user phpmyadmin.

    This will go to mysql prompt.
    # mysql -u root -p

    #mysql > use information_schema;
    mysql> repair table CHARACTER_SETS;

    exit;

    Done
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  8. nilesh_kolte

    nilesh_kolte Well-Known Member

    Joined:
    Apr 13, 2006
    Messages:
    65
    Likes Received:
    0
    Trophy Points:
    156
    Location:
    Pune ,India
    cPanel Access Level:
    Root Administrator
    check your PM..
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  9. nilesh_kolte

    nilesh_kolte Well-Known Member

    Joined:
    Apr 13, 2006
    Messages:
    65
    Likes Received:
    0
    Trophy Points:
    156
    Location:
    Pune ,India
    cPanel Access Level:
    Root Administrator
    check your PM.. thanks

     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  10. webstyler

    webstyler Well-Known Member

    Joined:
    Nov 20, 2003
    Messages:
    439
    Likes Received:
    0
    Trophy Points:
    166
    Hello

    Yes, I have try both way but get, also from shell, same error:

    ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'information_schema'

    :/
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  11. webstyler

    webstyler Well-Known Member

    Joined:
    Nov 20, 2003
    Messages:
    439
    Likes Received:
    0
    Trophy Points:
    166
    Anyone have suggest for this issue ?

    Thanks
     
    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