MySQL Performance: MySQL => How to recreate data base from Query Log

Members

Help

Home

Home » Performance » MySQL » How to recreate data base from Query Log

Show: Today's Messages :: Show Polls :: Message Navigator

How to recreate data base from Query Log [message #586]

Sat, 13 January 2007 14:51

david_tuckar
Messages: 3
Registered: January 2007
Location: USA

Junior Member

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

Report message to a moderator

Re: How to recreate data base from Query Log [message #587 is a reply to message #586 ]

Sat, 13 January 2007 15:52

Peter
Messages: 405
Registered: August 2006

Senior Member
Super Guru

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.

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/

Report message to a moderator

Re: How to recreate data base from Query Log [message #588 is a reply to message #587 ]

Sat, 13 January 2007 18:51

david_tuckar
Messages: 3
Registered: January 2007
Location: USA

Junior Member

we have no backups. All we have is query log only.

Report message to a moderator

Re: How to recreate data base from Query Log [message #589 is a reply to message #588 ]

Sat, 13 January 2007 19:14

Peter
Messages: 405
Registered: August 2006

Senior Member
Super Guru

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.

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/

Report message to a moderator

Re: How to recreate data base from Query Log [message #590 is a reply to message #589 ]

Sun, 14 January 2007 08:41

david_tuckar
Messages: 3
Registered: January 2007
Location: USA

Junior Member

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.

Report message to a moderator

Re: How to recreate data base from Query Log [message #591 is a reply to message #590 ]

Sun, 14 January 2007 09:30

Peter
Messages: 405
Registered: August 2006

Senior Member
Super Guru

David,

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

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/

Report message to a moderator

Previous Topic:	Query speed
Next Topic:	Replication : How to load balance queries ?

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 7 20:12:06 EST 2009

Total time taken to generate the page: 0.01513 seconds

.:: Contact :: Home :: MySQL Support by Percona.com ::.