Fix your corrupted tables / ibdata1 problem

 
Dear everyone,
I
just love list and I think I should share this information on how to
fix MySQL tables that are in use and according to the articles:

http://articles.techrepublic.com.com/5100-10878_11-5193721.html

and

http://tgrove.com/2007/12/02/innodb-operating-system-error-number-13-in-a-file-operation/

- First you should goto the corrupt databse folder in "data"
- either fix all tables or if you know the table name:
   #> myisamchk -r *.MYI
   #> myisamchk -r /path/to/table.MYI

- The, look for these lines, uncomment and change the paths
innodb_data_home_dir = /usr/local/mysql/data/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/db/mysql/
innodb_log_arch_dir = /usr/local/mysql/data/

- And now fix your permissions on the DATA directory.

#>chown -R mysql:mysql /usr/local/mysql

- or if u'd like more specific solution and when u get "error number 13" on starting up the Engine, then u must type this command:
#> chown mysql:mysql /usr/local/mysql/ibdata1

And u're saved :)