How to Merge Old Database to New Database
Issue #354
closed
How to Merge Old Database (Old Server) to New Database (New Server)
From 1 Server to Another New Server Database Merge
Old All Mails (Old Server) to New Archive Server
Comments (9)
-
repo owner
-
repo owner
- changed status to invalid
-
reporter
Using command pilerexport - A
cannot open: 469507.eml cannot open: 469508.eml cannot open: 469509.eml cannot open: 469510.eml cannot open: 469511.eml cannot open: 469512.eml cannot open: 469513.eml cannot open: 469514.eml cannot open: 469515.eml cannot open: 469516.eml cannot open: 469517.eml cannot open: 469518.eml cannot open: 469519.eml cannot open: 469520.eml cannot open: 469521.eml cannot open: 469522.eml cannot open: 469523.eml cannot open: 469524.eml cannot open: 469525.eml cannot open: 469526.eml cannot open: 469527.eml cannot open: 469528.eml cannot open: 469529.eml cannot open: 469530.eml cannot open: 469531.eml cannot open: 469532.eml cannot open: 469533.eml cannot open: 469534.eml cannot open: 469535.eml cannot open: 469536.eml cannot open: 469537.eml cannot open: 469538.eml cannot open: 469539.eml cannot open: 469540.eml cannot open: 469541.eml cannot open: 469542.eml cannot open: 469543.eml cannot open: 469544.eml cannot open: 469545.eml cannot open: 469546.eml cannot open: 469547.eml cannot open: 469548.eml cannot open: 469549.eml cannot open: 469550.eml cannot open: 469551.eml cannot open: 469552.eml cannot open: 469553.eml cannot open: 469554.eml cannot open: 469555.eml cannot open: 469556.eml cannot open: 469557.eml cannot open: 469558.eml cannot open: 469559.eml cannot open: 469560.eml cannot open: 469561.eml cannot open: 469562.eml cannot open: 469563.eml cannot open: 469564.eml cannot open: 469565.eml cannot open: 469566.eml cannot open: 469567.eml cannot open: 469568.eml cannot open: 469569.eml cannot open: 469570.eml cannot open: 469571.eml cannot open: 469572.eml cannot open: 469573.eml cannot open: 469574.eml cannot open: 469575.eml cannot open: 469576.eml cannot open: 469577.eml cannot open: 469578.eml cannot open: 469579.eml cannot open: 469580.eml cannot open: 469581.eml cannot open: 469582.eml cannot open: 469583.eml cannot open: 469584.eml cannot open: 469585.eml cannot open: 469586.eml cannot open: 469587.eml cannot open: 469588.eml cannot open: 469589.eml cannot open: 469590.eml cannot open: 469591.eml cannot open: 469592.eml cannot open: 469593.eml cannot open: 469594.eml cannot open: 469595.eml cannot open: 469596.eml cannot open: 469597.eml cannot open: 469598.eml cannot open: 469599.eml cannot open: 469600.eml cannot open: 469601.eml cannot open: 469602.eml cannot open: 469603.eml cannot open: 469604.eml cannot open: 469605.eml cannot open: 469606.eml cannot open: 469607.eml cannot open: 469608.eml cannot open: 469609.eml cannot open: 469610.eml cannot open: 469611.eml cannot open: 469612.eml cannot open: 469613.eml cannot open: 469614.eml cannot open: 469615.eml cannot open: 469616.eml cannot open: 469617.eml cannot open: 469618.eml cannot open: 469619.eml cannot open: 469620.eml cannot open: 469621.eml cannot open: 469622.eml cannot open: 469623.eml cannot open: 469624.eml cannot open: 469625.eml cannot open: 469626.eml cannot open: 469627.eml cannot open: 469628.eml cannot open: 469629.eml cannot open: 469630.eml cannot open: 469631.eml cannot open: 469632.eml cannot open: 469633.eml cannot open: 469634.eml cannot open: 469635.eml cannot open: 469636.eml cannot open: 469637.eml cannot open: 469638.eml cannot open: 469639.eml cannot open: 469640.eml cannot open: 469641.eml cannot open: 469642.eml cannot open: 469643.eml cannot open: 469644.eml cannot open: 469645.eml cannot open: 469646.eml cannot open: 469647.eml cannot open: 469648.eml cannot open: 469649.eml cannot open: 469650.eml cannot open: 469651.eml cannot open: 469652.eml cannot open: 469653.eml cannot open: 469654.eml cannot open: 469655.eml cannot open: 469656.eml cannot open: 469657.eml cannot open: 469658.eml cannot open: 469659.eml cannot open: 469660.eml cannot open: 469661.eml cannot open: 469662.eml cannot open: 469663.eml cannot open: 469664.eml cannot open: 469665.eml cannot open: 469666.eml cannot open: 469667.eml cannot open: 469668.eml cannot open: 469669.eml cannot open: 469670.eml cannot open: 469671.eml cannot open: 469672.eml cannot open: 469673.eml cannot open: 469674.eml cannot open: 469675.eml cannot open: 469676.eml cannot open: 469677.eml cannot open: 469678.eml cannot open: 469679.eml cannot open: 469680.eml cannot open: 469681.eml cannot open: 469682.eml cannot open: 469683.eml cannot open: 469684.eml cannot open: 469685.eml cannot open: 469686.eml cannot open: 469687.eml cannot open: 469688.eml cannot open: 469689.eml cannot open: 469690.eml cannot open: 469691.eml cannot open: 469692.eml cannot open: 469693.eml cannot open: 469694.eml cannot open: 469695.eml cannot open: 469696.eml cannot open: 469697.eml cannot open: 469698.eml cannot open: 469699.eml cannot open: 469700.eml cannot open: 469701.eml cannot open: 469702.eml cannot open: 469703.eml cannot open: 469704.eml cannot open: 469705.eml cannot open: 469706.eml cannot open: 469707.eml cannot open: 469708.eml cannot open: 469709.eml cannot open: 469710.eml cannot open: 469711.eml cannot open: 469712.eml cannot open: 469713.eml cannot open: 469714.eml cannot open: 469715.eml cannot open: 469716.eml cannot open: 469717.eml cannot open: 469718.eml cannot open: 469719.eml cannot open: 469720.eml cannot open: 469721.eml cannot open: 469722.eml cannot open: 469723.eml cannot open: 469724.eml cannot open: 469725.eml cannot open: 469726.eml cannot open: 469727.eml cannot open: 469728.eml cannot open: 469729.eml cannot open: 469730.eml cannot open: 469731.eml cannot open: 469732.eml cannot open: 469733.eml cannot open: 469734.eml cannot open: 469735.eml cannot open: 469736.eml cannot open: 469737.eml cannot open: 469738.eml cannot open: 469739.eml cannot open: 469740.eml cannot open: 469741.eml cannot open: 469742.eml cannot open: 469743.eml cannot open: 469744.eml cannot open: 469745.eml cannot open: 469746.eml cannot open: 469747.eml cannot open: 469748.eml cannot open: 469749.eml cannot open: 469750.eml
-
reporter
I am taking taking Option A
Export the All using "pilerexport -A" - Done Move all these emails to new server via scp, rsync, whatever - Done Import the new emails on the new server using pilerimport - 1) in which path i have to import all mails in this directory /var/piler/store/ or else any where 2) All mail will show in auditor login automatically or we have to do anything
-
repo owner
Assuming that the emails are in /path/to/dir, then go to /tmp, then execute pilerimport -d /path/to/dir. You should not touch /var/piler/store directly. The piler binaries are meant to handle the /var/piler/store directory.
An auditor login will see all imported emails, nothing extra job is required.
-
reporter
All the Mails in the New Server will won't effect anything right ? it will add new mail from the which we imported right.
-
reporter
You are telling that go to /tmp and execute pilerimport -d /path/to/dir
Assume that path/to/dir size around 80 GB
/tmp 30 GB only we don't have that much space. Then what should I do.
-
repo owner
Yes, I'm telling you that exactly. pilerimport will clean up the temp files as soon as it finishes the given email, so don't worry, just run it.
-
reporter
- changed status to closed
- Log in to comment
I'm still confused how come that this is a major bug according to your evaluation? The process is basically the following:
Option A:
Be sure to read the docs on the piler website.
Option B (this one is trickier):
You have to copy from the old server the contents of /var/piler/store, then the mysql entries regarding the emails, and you have to adjust the serial ids to new server. Then reindex the copied emails.
If I were you, I'd take option A.