How to synchronize 2 osCommerce databases

[Guest]

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

[wheeloftime]

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.