MySQL Server Error Troubleshooting
Budget: $30 – $250 USD
The local MySQL server engine suddenly shut down due to a power failure. This caused an error in storage or a memory error that led to corruption when the storage engine is writing data to the table.
Attempting to fix it, I manipulated the LOGS files (transaction logs, etc.) and managed to connect to the database, query data, and export some of it, and the data was exported perfectly. That's why I know the data is intact. Unfortunately, I didn't think to export all the data because I thought the error had been fixed. However, the next day, the error returned, and I couldn't fix it. Here is a link that explains that it is a common problem in my situation:
https://www.stellarinfo.com/article/dealing-with-data-corruption-innodb-storage-engine-of-mysql.php
We are using, XAMPP, MYSQL and Maria DB in a Mac
- What I need:
* Troubleshooting and fixing of the MySQL server error.
- Ideal Candidate:
* Expert familiarity with MySQL server engines.
* Experience with error solving and data recovery in MySQL.
Attempting to fix it, I manipulated the LOGS files (transaction logs, etc.) and managed to connect to the database, query data, and export some of it, and the data was exported perfectly. That's why I know the data is intact. Unfortunately, I didn't think to export all the data because I thought the error had been fixed. However, the next day, the error returned, and I couldn't fix it. Here is a link that explains that it is a common problem in my situation:
https://www.stellarinfo.com/article/dealing-with-data-corruption-innodb-storage-engine-of-mysql.php
We are using, XAMPP, MYSQL and Maria DB in a Mac
- What I need:
* Troubleshooting and fixing of the MySQL server error.
- Ideal Candidate:
* Expert familiarity with MySQL server engines.
* Experience with error solving and data recovery in MySQL.