I apologize for my grammar errors and imprecisions.
Hi everyone! It's my first post here.
After taking a full wordpress backup, i got an error, and looking trough the log file i found a full storage error.
I run Bitnami wordpress in a AWS server with Ubuntu x64
This free aws server istance have a proor storage so i wasn't surprised.
i deleted the backup file from the server, restarted all the services and logged in on the admin page:
i found out that all the pages, posts and media were gone.
i attept to follow this bitnami guide
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:
innodb_force_recovery = 1
Start the MySQL database with the following command:
mysqld --skip-grant-tables --user=mysql --pid-file=/opt/bitnami/mysql/data/mysqld.pid
--skip-external-locking --port=3306 --sock=/opt/bitnami/mysql/tmp/mysql.sock
Open a new console and try to log in the database:
mysql -u root -p
In this case, the error was related to the mysql.user table. Run these commands:
mysql> use mysql;
From this point i always got the same error
Got error: 2002: Can't connect to local MySQL server through socket '/opt/bitnami/mysql/tmp/mysql.sock' (2) when trying to connect
i wasn't able to run mysql again or login
i changed the permission of the /opt/bitnami/mysql folder to 755 but i didn't had results
somone could help me with this problem?
Let me know if i have to post more informations.