I'm using this tutorial on How to recover MySQL data from Innodb which provides the following steps:
ibdata1, ib_logfile0 and ib_logfile1
files) into the normal MySQL data directory ( /var/lib/mysql )/var/lib/mysql
ls -l
to find the size of your Innodb logfiles The output looks like this:
-rw-rw—- 1 mysql mysql 5242880 Jun 25 11:30 ib_logfile0
-rw-rw—- 1 mysql mysql 5242880 Jun 25 11:30 ib_logfile1
Run su mysql
And run this /usr/sbin/mysqld –innodb_log_file_size=5242880 –innodb_force_recovery=6
Note the number 5242880 is what I've got on step 4
Now I'm getting this error bash: /usr/sbin/mysqld: No such file or directory
.
What do I miss or what should I install ?
Any help would be appreciated thanks
Mysql is 5.5.4
Finally solved the problem by uninstalling and install again mysqlServer and taking the entire mysql directory /var/lib/mysql
content from my backup to the new directory . I have all tables and data .