Skip to main content

mysql error

Comments

5 comments

  • mojamoi
    I did yum remove mysql on teh server cpanel what can i do to reinstall it
    0
  • mojamoi
    installed it by /scripts/upcp but still the first issue [QUOTE]MySQL Error! MySQL error in file: /engine/classes/mysqli.class.php at line 52 Error Number: 1 The Error returned was: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) SQL query:
    0
  • cPanelMichael
    Hello :) Please attempt to restart MySQL and let us know the error message you see in /var/lib/mysql/$hostname.err when the restart fails. Thank you.
    0
  • mojamoi
    Restart of mysql never fails however it always gives the error above in running state It always starts However the status shows as not running at times [COLOR="silver">- - - Updated - - - Here are log files from $hostname.err 120923 13:05:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 120923 13:05:06 [Note] Plugin 'FEDERATED' is disabled. 120923 13:05:07 InnoDB: Initializing buffer pool, size = 8.0M 120923 13:05:07 InnoDB: Completed initialization of buffer pool InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 120923 13:05:07 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 120923 13:05:13 InnoDB: Started; log sequence number 5 2084801700 120923 13:05:14 [Note] Event Scheduler: Loaded 0 events 120923 13:05:14 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.1.63-cll' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 120923 13:05:42 [ERROR] /usr/sbin/mysqld: Table './eximstats/sends' is marked as crashed and last (automatic?) repair failed 120923 13:05:42 [ERROR] /usr/sbin/mysqld: Table './eximstats/sends' is marked as crashed and last (automatic?) repair failed 120923 13:05:43 [ERROR] /usr/sbin/mysqld: Table './eximstats/smtp' is marked as crashed and last (automatic?) repair failed
    0
  • cPanelMichael
    Check to make sure none of your partitions are full: df -h df -i
    If not, please open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome. Thank you.
    0

Please sign in to leave a comment.