A blog by a system administrator and programmer.

Mysql problems 
Saturday, October 27, 2007, 06:05 PM - System
Posted by Freddy Chu
Get Error 1033 "Incorrect information in file xxxx.frm" when run REPAIR

* Found a backup frm file if you can and overwrite the existing one
* If you do not have frm backup, you may need to find the original "create table" statement

1. Backup those table's frm, MYI, MYD first
2. use the original create table statement to create a new table with another name
3. overwrite the table's frm with the new table's frm
4. run REPAIR TABLE again

mysqldump: Got error: 1105: not found (Errcode: 24) when using LOCK TABLES

* this happens usually caused by open_files_limit too low
* edit my.cnf at [mysqld]" part

open_files_limit = 8192

* restart mysql server
9 comments ( 77 views )   |  permalink   |   ( 3 / 2385 )
About my blog 
Thursday, October 25, 2007, 09:41 PM - General
Posted by Freddy Chu
It has been a long time that i want to have my own blog, but

I am really lazy....

I spent most of my in World of Warcraft in the past. I think i have spent almost around 2 years in the game. It is a good timing to leave the virtual world and put more time on work and study. :D

This blog is mainly about Unix servers and programming problems.

I will keep update it when i solve any interesting problems.

add comment ( 56 views )   |  permalink   |   ( 3 / 1306 )

<<First <Back | 1 | 2 |