How can I recreate MySQL DB of piler?
Issue #873
wontfix
Hi,
I have a problem that MySQL DB is lost while migrating the piler machine. How can I recreate MySQL DB of piler again from scratch?
If it is part of documentation please let me know.
Thanks, Shiv
Comments (6)
-
-
reporter
No my /var/piler/store is fine. I only need to regenerate MySQL tables.
-
go examine the files in your /var/piler/store .. without the mysql they are pretty useless
The only way is to reconstruct and re-import, Which is essentially rebuilding the mysql database.
With attachment de-duplication and no database there is a very complicated process to work out to which attachment goes with which email.
Anycase recovery is possible and has been done lots of times with xshok-piler-archive-recovery
-
repo owner
Well, perhaps it's not emphasized enough how important the mysql database is, however extremeshok is right: mysql stores crucial metadata and other stuff required for piler to operate. The documentation doesn't describe how to recover the piler database, because it expects you to take care of it, don't let it be gone.
Despite your settings of this issue, ie. being a trivial enhancement, it's not. So if I were you, I'd definitely give a chance to the mentioned tool to recover your lost database.
Anyway, I'll add a warning to the piler wiki that the mysql database is extremely important.
-
reporter
What is the price of these two tools and where can I purchase them?
-
repo owner
- changed status to wontfix
I suggest to contact with extremeshok, and discuss the details with him. I'm closing this issue. Feel free to update it with your feedback when it's done.
- Log in to comment
You need 2 commercial tools:
xshok-piler-archive-recovery and then xshok-piler-import-dir will have the entire archive reconstructed with the attachments imported and everything corrected.