We have lost data from Mysql. We are trying to reconstruct the data from Query Log. Please help us
No announcement yet.
How to recreate data base from Query LogPage Title Module
Move Remove Collapse
How to recreate data base from Query LogTags: None
Have you lost all your data, have no backups or anything ?
Are you speaking about query log or binary log. If you have binary log from MySQL start it is possible to recover data by using mysqlbinlog.
General query log or binary log ?
And does it run to the very beginning ?
You should be able to reply that query log, if so, it will not be perfect though as now() for example will be screwed.
All we have is general query log that runs from the begining until the end. It appears it has all the information related to all kinds of queries. We need tips or suggestions to recreate our database from these General Query Log. Any parser available1
If there is any consultant who is proficient and have this experience Please contact. I would ask my associates in Boston to contact them directly.
See my signature. We should be able to help you. Drop us a note at
consulting _at_ mysqlperformanceblog.com