Category Archives: MySQL

By April 26, 2008

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


Read More
By April 25, 2008

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


Read More
By April 12, 2008

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


Read More
By March 29, 2008

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


Read More
By February 07, 2008

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


Read More
1 3 4 5