Missing tables in MySQL database from innodb changes. Need help to fix
- or -
Post a project like this2385
$$
- Posted:
- Proposals: 3
- Remote
- #1709207
- Awarded
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
General information for the business: Database providing info for iOS app
Database management system (DBMS): MySQL
Description of requirements/functionality: The issue started after needing to make a change to API credentials. After the change the info was only updating once per day, opposed to every 15 seconds. I was directed to a tutorial that recommended deleting log files and adding code to do with innodb.
Since restarting MySQL there has been tables missing and the data isn't updating. I have had a developer try to repair by migrating to MariaDB and restoring from a year old backup. For some reason there are still some tables missing even from the backup. The latest MYSQL (before backup) was corrupted so wouldn't dump, but have a file copy saved on server. Also have a server snapshot from before the MariaDB migration.
Extra notes: I only want experts who know what they are doing. I don't want to pay you for your time trialling. I want to pay a fixed price for a fix.
Database management system (DBMS): MySQL
Description of requirements/functionality: The issue started after needing to make a change to API credentials. After the change the info was only updating once per day, opposed to every 15 seconds. I was directed to a tutorial that recommended deleting log files and adding code to do with innodb.
Since restarting MySQL there has been tables missing and the data isn't updating. I have had a developer try to repair by migrating to MariaDB and restoring from a year old backup. For some reason there are still some tables missing even from the backup. The latest MYSQL (before backup) was corrupted so wouldn't dump, but have a file copy saved on server. Also have a server snapshot from before the MariaDB migration.
Extra notes: I only want experts who know what they are doing. I don't want to pay you for your time trialling. I want to pay a fixed price for a fix.
PPH User P.
100% (13)Projects Completed
13
Freelancers worked with
12
Projects awarded
42%
Last project
15 Sep 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies