Difference between revisions of "March Oandm Backup"
(March_Oandm Backup) |
(March_Oandm Backup) |
||
| Line 1: | Line 1: | ||
| − | 1) Login to March and Oandm cPanel using the password in Lastpass | + | 1) Login to March and Oandm cPanel using the password in Lastpass. |
| − | 2) Enter into the pgsql section and create a new DBs corresponding for the backup domains "http://backup.march.connectkwa.com/" & "http://backup.oandm.connectkwa.com/" | + | |
| + | 2) Enter into the pgsql section and create a new DBs corresponding for the backup domains "http://backup.march.connectkwa.com/" & "http://backup.oandm.connectkwa.com/". | ||
| + | |||
| + | |||
3) Then find the backup of live DBs that we required from the databasebackup folder under the domains (march & oandm) and restore it to the newly created DBs. | 3) Then find the backup of live DBs that we required from the databasebackup folder under the domains (march & oandm) and restore it to the newly created DBs. | ||
| Line 6: | Line 9: | ||
------------------------ | ------------------------ | ||
psql -U username -d dbname -1 -f filename.sql | psql -U username -d dbname -1 -f filename.sql | ||
| + | |||
or | or | ||
| + | |||
pg_restore -U username -d dbname -1 filename.dump | pg_restore -U username -d dbname -1 filename.dump | ||
| + | |||
4) Then connect the new DBs to the corresponding backup domains mentioned above and check the working. | 4) Then connect the new DBs to the corresponding backup domains mentioned above and check the working. | ||
| + | |||
| + | |||
5) After that share the links "http://backup.march.connectkwa.com/" & "http://backup.oandm.connectkwa.com/" with support team for send it to the department for verification. | 5) After that share the links "http://backup.march.connectkwa.com/" & "http://backup.oandm.connectkwa.com/" with support team for send it to the department for verification. | ||
Revision as of 12:01, 23 April 2021
1) Login to March and Oandm cPanel using the password in Lastpass.
2) Enter into the pgsql section and create a new DBs corresponding for the backup domains "http://backup.march.connectkwa.com/" & "http://backup.oandm.connectkwa.com/".
3) Then find the backup of live DBs that we required from the databasebackup folder under the domains (march & oandm) and restore it to the newly created DBs.
Restore Commands
psql -U username -d dbname -1 -f filename.sql
or
pg_restore -U username -d dbname -1 filename.dump
4) Then connect the new DBs to the corresponding backup domains mentioned above and check the working.
5) After that share the links "http://backup.march.connectkwa.com/" & "http://backup.oandm.connectkwa.com/" with support team for send it to the department for verification.
