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
After moving restoring my data I notice i was had some ???? question marks . The character set and collation was incorrect . For my example the character setis utf8 and the collation is utf8_persian_ci set name uts8 ALTER TABLE tbl_name
MyISAM tables (the default table type in MySQL) become fragmented when you delete records (this can even happen when you update records, if your table format is dynamic). You cannot avoid this effect if you’re using MyISAM tables. If you don’t optimize fragmented MyISAM tables, they will become slow to scan because the operating system
