Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How to synchronize 2 osCommerce databases


Guest

Recommended Posts

For example, I have two OSC installed, one called http://test.abc.com (for testing purpose) and the other called http://production.abc.com (real site). Before I want to make any change on the real site, I want to use the test site to test everything, so at some point I need make the two site identical. I guess there will be two parts:

 

1, Files and folders - If I just copy/paster, then how about those files are not writable? Is there any script/tool can do that?

2, Databases - same questions, any easier way to do that, other than write own shell script?

 

In a word, how could I achieve that?

Thanks

Link to comment
Share on other sites

For example, I have two OSC installed, one called http://test.abc.com (for testing purpose) and the other called http://production.abc.com (real site). Before I want to make any change on the real site, I want to use the test site to test everything, so at some point I need make the two site identical. I guess there will be two parts:

 

1, Files and folders - If I just copy/paster, then how about those files are not writable? Is there any script/tool can do that?

2, Databases - same questions, any easier way to do that, other than write own shell script?

 

In a word, how could I achieve that?

Thanks

1) There is programs with FTP capabilities which can simply synchronize files/folders. I myself use Total Commander which has a synchronize part which gives me the ability to only upload/download the changed files.

 

2) From server to local I just make a backup from the server, drop the whole database locally and import the server backup locally. Done.

For database synchronizing from local test to server this is not a good idea so those changes I do by hand. Assuming you do not alter your database on a daily/weekly basis and only small things needed for certain contributions this is no work at all.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...