Project

General

Profile

Forums » Help »

How to recover from production.log?

Added by Jennal ZHENG over 13 years ago

Hi guys,

I have a big trouble, mysql database crashed and all data are lost..
All the documents in redmine are lost, T-T... but I found redmine has a production.log with very clear user events GET/POST/PUT.

Can I recover my data with this production.log?
Can somebody tell me how?

Thank you very much for help!!


Replies (5)

RE: How to recover from production.log? - Added by Felix Schäfer over 13 years ago

Jennal ZHENG wrote:

I have a big trouble, mysql database crashed and all data are lost..

Make backups.

All the documents in redmine are lost, T-T

Attachments and files aren't stored in the DB, so why?

... but I found redmine has a production.log with very clear user events GET/POST/PUT.

Can I recover my data with this production.log?
Can somebody tell me how?

I wouldn't know how, the production.log holds the parameters of all HTTP actions on Redmine, but you can't for example be sure which action happened as what user. Anyway, there's no "production.log importer" I know of, so even if it's doable, you're on your own, sorry.

RE: How to recover from production.log? - Added by Jennal ZHENG over 13 years ago

Attachments and files aren't stored in the DB, so why?

I put all documents in wiki..

RE: How to recover from production.log? - Added by Felix Schäfer over 13 years ago

Jennal ZHENG wrote:

Attachments and files aren't stored in the DB, so why?

I put all documents in wiki..

If you attached files to wikipages, the files are in the files directory in your Redmine directory. If you mean documents as in "wiki pages", they are probably recoverable to some degree from the production.log, but as I said, that information is not complete (lacks the user who did the change, and so on).

RE: How to recover from production.log? - Added by Jennal ZHENG over 13 years ago

Felix Schäfer wrote:

Jennal ZHENG wrote:

Attachments and files aren't stored in the DB, so why?

I put all documents in wiki..

If you attached files to wikipages, the files are in the files directory in your Redmine directory. If you mean documents as in "wiki pages", they are probably recoverable to some degree from the production.log, but as I said, that information is not complete (lacks the user who did the change, and so on).

Yes, I mean the Wiki Pages..
I don't need the details about who did the changes, I just need the contents.
But I can't find wiki changes in the production.log file..
Is there another log about the wiki pages change?

RE: How to recover from production.log? - Added by Felix Schäfer over 13 years ago

Jennal ZHENG wrote:

But I can't find wiki changes in the production.log file..

It should be in lines starting with Processing WikiController#update and the few following lines after that.

Is there another log about the wiki pages change?

No.

    (1-5/5)