Dear everyone,
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:


- 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 :)


Reply via email to