Restoration of Openbravo Environment

All of us depend on backup most of the time. That’s one side-effect of innovative product development. Sometimes when our imagination unfolds in the form of thousands of ideas, the first thing that suffers is the application coz its new for it and the last thing is you got to restore it..:) Sometimes we do development in one environment and recreate the environment elsewhere. I will present how I did it for Openbravo in ubuntu. Openbravo in ubuntu has two parts. One if the folder structure and the other of course is the database. I use postgres as database because of the simple reason that its free. So the first step is i need a backup or a dump of the database. If you have pgadmin installed this is a easier task. Just right click on your database, and choose backup. In the options that present before you, choose the plain option. This option is to create a backup in plain text format that you can see. You can almost sense whats there in that dump with the plain format backup.

Now if you don’t use pgadmin then use the command
pg_dump  -U postgres dbname > nameofbackupfile” for more doubts in this, visit this link
We have our database copy now. Next step is copy your current folder structure and transfer it to the destination machine. Next step is restoring the database. This command is really simple..:)
psql -U postgres -d newdb_name -f path_of_backupfile“. Note that you need to create an empty database before restoring into that..:) i forgot his once, so only added this. Next thing there is option restore in Pgadmin but sadly that does not work for plain type database dump that we took.
So we now have a database and folder structure. next step is modify the openbravo properties file and set the source directory and database name accordingly…(refer obwiki for these stuffs if u have doubts, or i ll put another blog about openberavo properties..:) ). So after modifying the properties file, just go ahead and do a complete build and you have the openbravo ready in your new environment…revert back with questions if you have any, in fact i am waiting for many…:)


About Shankar Balachandran
Technical Manager, Openbravo operations, Kailao Consulting Private Limited

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: