GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

How to recreate data base from Query Log

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to recreate data base from Query Log

    We have lost data from Mysql. We are trying to reconstruct the data from Query Log. Please help us

  • #2
    Hm,

    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.

    Comment


    • #3
      we have no backups. All we have is query log only.

      Comment


      • #4
        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.

        Comment


        • #5
          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.

          Comment


          • #6
            David,

            See my signature. We should be able to help you. Drop us a note at
            consulting _at_ mysqlperformanceblog.com

            Comment

            Working...
            X