Reference http://ushost.name/training/repairing_a_mysql_database.htm http://dev.mysql.com/doc/refman/5.0/en/repair-table.html http://dev.mysql.com/doc/refman/5.0/en/repair.html http://www.informit.com/articles/article.aspx?p=29406&seqNum=3 IBM Helpdesk
The number following the message indicates a database problem. The error number is generated by joomla! and error numbers 1, 2 and 3 indicate the following: Error 1 = FATAL ERROR: MySQL support not available. Error 2 = FATAL ERROR: Connection to database server failed. Error 3 = FATAL ERROR: Database not found my view [...]
mysqlshow –status db_name * show engine type , and some other info mysqlcheck -r dbname – repairs a table/database describe tablename reference http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html innodb engine http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html http://dev.mysql.com/doc/refman/5.0/en/innodb-monitor.html
Got error: 1016: Can’t open file: ‘threadviews.MYI’. (errno: 145) when using LOCK TABLES run the repair command and then try the dump again mysqlcheck -r -u mysqlusername -p databasename
Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock under cpanel , i had to first locate the correct mysql.sock file by running find / | grep “sock” and them created a symlink to that lock file from the /var/tmp folder The strange that is the my.cnf files claims the sock file is located at [...]