Update Procedures

[mikca]

We are using a site we installed in 2001. It's time to update.

 

I intend to install a new instance of OSC in a separate directory (Linux box), then, once all my modifications are completed, copy this to the current, established directory.

 

I don't expect any major problems with this, it should work, right? But, how do I handle the database.

 

Can I point the new install to the current DB? If I need to create another DB, can I data-dump the current DB and then insert into the new, when the time comes?

 

Thanks

[ksl8313]

I would suggest mapping the database after you're done, then import from old site to the new site, rather than simply copying the database over - that way you can avoid any schema errors you might run into.

[mikca]

Okay, I did install the newest version and compared the databases. There were only two differences. (that I found)

 

table orders:

old - has comment field

new - no comment field

 

table orders_status_history:

old - has new_value, old_value

new - replaces those with order_status_id, comments

 

It should port over pretty easily.

 

Still curious though, once everything's setup, custom changes are added to the newest version, new database matches old database - since all our search links, links from other sites, etc. point to the existing directory - can I just rename the new version directory to the same name as the old? Everything will work?