I have been using the built in DB backup/restore interface in OE for the last 9 months with no problems. My main application is in LINUX and my backup application is running on a Windows servers. Up to now I have used the built in backup function to create the dump file and I have restored it on my windows application to test it.
Now for no obvious reason I get an error message in a small window in the center of the screen stating "Restore Database Could not restore database OK" At the same time I see the text I am used to see up in the right corner "Restored Database restored"
At this point I can not restore any of the backups that I have been able to restore in the past.
Does anyone have any idea what have happened? I have not done any changes to the install as far as I know.
If you have a problem with "database manager" method, you can try with this:
DUMP DataBase from source server:
pg_dump -f oe-mydatabase_backup.sql mydatabase_name
RESTORE on destination server:
psql -f mydatabase_backup.sql mydatabase_name
You need remember if have a custom addons then need copy the server files.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 3/6/14, 3:06 PM|
|Seen: 2590 times|
|Last updated: 3/16/15, 8:10 AM|