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.

Sql error on hostname.err

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

  1. webstyler

    webstyler Well-Known Member

    Joined:
    Nov 20, 2003
    Messages:
    432
    Likes Received:
    0
    Trophy Points:
    16
    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
     
  2. Ghulam Yaseen

    Ghulam Yaseen Well-Known Member

    Joined:
    Mar 14, 2008
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    6
    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:
    432
    Likes Received:
    0
    Trophy Points:
    16
    I don't now the db name

    The table indicated not exist
     
  4. webstyler

    webstyler Well-Known Member

    Joined:
    Nov 20, 2003
    Messages:
    432
    Likes Received:
    0
    Trophy Points:
    16
    any suggest ?

    We haven't found solutions at this time

    Thanks
     
  5. nilesh_kolte

    nilesh_kolte Well-Known Member

    Joined:
    Apr 13, 2006
    Messages:
    65
    Likes Received:
    0
    Trophy Points:
    6
    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.
     
  6. webstyler

    webstyler Well-Known Member

    Joined:
    Nov 20, 2003
    Messages:
    432
    Likes Received:
    0
    Trophy Points:
    16
    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
     
  7. nilesh_kolte

    nilesh_kolte Well-Known Member

    Joined:
    Apr 13, 2006
    Messages:
    65
    Likes Received:
    0
    Trophy Points:
    6
    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
     
  8. nilesh_kolte

    nilesh_kolte Well-Known Member

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

    nilesh_kolte Well-Known Member

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

     
  10. webstyler

    webstyler Well-Known Member

    Joined:
    Nov 20, 2003
    Messages:
    432
    Likes Received:
    0
    Trophy Points:
    16
    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'

    :/
     
  11. webstyler

    webstyler Well-Known Member

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

    Thanks
     
Loading...

Share This Page