This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
reference:database_restore [2012/08/17 10:09] – created paul | reference:database_restore [2018/11/14 10:45] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
======Database -> Restore Tab====== | ======Database -> Restore Tab====== | ||
- | This tab is only in VPOP3 Enterprise, and is for performing a partial (mailbox/ | + | This tab is only in VPOP3 Enterprise |
Using the **Restore** tab, you can recover one or more users' full mailboxes or individual messages from a backup. Note that you cannot filter by date, so if you just want to recover a few messages you should probably restore into a different mailbox/ | Using the **Restore** tab, you can recover one or more users' full mailboxes or individual messages from a backup. Note that you cannot filter by date, so if you just want to recover a few messages you should probably restore into a different mailbox/ | ||
Line 11: | Line 11: | ||
To restore a backup to a temporary database on the VPOP3 computer, go to a command prompt in the VPOP3\pgsql\bin folder and run a command like | To restore a backup to a temporary database on the VPOP3 computer, go to a command prompt in the VPOP3\pgsql\bin folder and run a command like | ||
- | | + | createdb -U postgres -E SQL_ASCII -p 5433 -T template0 vpop3temp |
(password '' | (password '' | ||
Line 17: | Line 17: | ||
Then, run a command like: | Then, run a command like: | ||
- | | + | pg_restore -U postgres -p 5433 -d vpop3temp -j 4 -v dbback.dmp |
(password '' | (password '' | ||
Line 40: | Line 40: | ||
When you press **Start Restore** the restore process starts. It may take some time depending on how many messages need to be restored. You can continue using VPOP3 or edit more settings while the restore process is running. | When you press **Start Restore** the restore process starts. It may take some time depending on how many messages need to be restored. You can continue using VPOP3 or edit more settings while the restore process is running. | ||
+ | |||
+ | =====Cleaning Up===== | ||
+ | Once the messages have been restored you can remove the temporary database | ||
+ | |||
+ | Go to a command prompt in the VPOP3\pgsql\bin folder and run a command like | ||
+ | |||
+ | dropdb -U postgres -p 5433 vpop3temp | ||
+ | (password '' | ||
====Notes==== | ====Notes==== | ||
* If a restored message already exists in the message store, it will be duplicated, so you will get the original copy PLUS the restored copy | * If a restored message already exists in the message store, it will be duplicated, so you will get the original copy PLUS the restored copy | ||
* If a message is to be restored to a folder which no longer exists, VPOP3 will create the folder for you | * If a message is to be restored to a folder which no longer exists, VPOP3 will create the folder for you | ||
- | + | | |
- | | + | |
^ Selected Target User ^ Selected Target Folder ^ Number Of Users Being Restored ^ Destination User ^ Destination Folder ^ | ^ Selected Target User ^ Selected Target Folder ^ Number Of Users Being Restored ^ Destination User ^ Destination Folder ^ | ||
Line 54: | Line 61: | ||
| X | Y | 1 | X | Y/< | | X | Y | 1 | X | Y/< | ||
| X | Y | >1 | X | Y/< | | X | Y | >1 | X | Y/< | ||
- |