<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-5232258871649572"
crossorigin="anonymous"></script>
1)The MySQL database is configured to use InnoDB engine by default. You can add the innodb_force_recovery=1 option in the main MySQL configuration file at /opt/bitnami/mysql/etc/my.cnf to try and fix the database:
[mysqld] innodb_force_recovery = 1
2) Start the MySQL database with the following command: mysqld --skip-grant-tables --user=mysql --skip-external-locking --port=3306 --sock=/opt/bitnami/mysql/tmp/mysql.sock 3)mysql -u root -p
4)o not forget to remove the innodb_force_recovery option from the my.cnf file and restart the MySQL server again
5)If they show any permission issue usesudo chown mysql:root -R /opt/bitnami/mysql/datachmod 1777 /tmp
To find error logs: cd /var/log/apache2 References https://docs.bitnami.com/aws/infrastructure/mysql/administration/recover-database-mysql/
No comments:
Post a Comment