Fix your corrupted tables / ibdata1 problem

--0-1660625509-1239191798=:47441
Content-Type: text/plain; charset=us-ascii


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.h tml

and

http://tgrove.com/2007/12/02/innodb-operating-system-error-n umber-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 :)




--0-1660625509-1239191798=:47441--