Best way to replicate the database between Simple CMS installations?

[learningcms]

I have a simpleCMS installed on two different computers.  However, they both need to use the same information.  They use two different databases...they do not share the same database.

Originally I wanted to use sqlite so i could transfer the database with each simpleCMS installation but I have read it isn't supported.  If anyone knows different please tell me.  I only need basic functionality, no third party modules, just basic menu, articles, pages, etc.

Outside of sqlite does anyone know the best way to replicate the database between installations?  Maybe a module that goes out and updates?  I don't know.

Thank you for any help.

[Nullig]

The Sitepusher module may be what you're looking for.

Nullig

[Duketown]

learningcms,

You don't talk about the frequency. How up to date should the target site when compared with the source site?
Is it realy a duplicate of the database?

Duketown

[Rolf]

Perhaps with both sites using
http://dev.cmsmadesimple.org/projects/mysqldump
Export DB in the first site, move dumpfile and import in the second site.

[learningcms]

learningcms,

You don't talk about the frequency. How up to date should the target site when compared with the source site?
Is it realy a duplicate of the database?

Duketown

Whenever they need to is the frequency.  Probably not that often but neither site changes that much.  The target, the copy, is an exact duplicate and should at all times be so.

[Dr.CSS]

Point them both to the same DB in the config, any change on one will be reflected in the other...

Having said that, if you have 2 sites with the same content "live" on the web you will get hit by search engines as having duplicate content and bad rankings...

[learningcms]

Point them both to the same DB in the config, any change on one will be reflected in the other...

Having said that, if you have 2 sites with the same content "live" on the web you will get hit by search engines as having duplicate content and bad rankings...

I can't have them on the same DB.  That's the whole problem.  I need two exactly duplicate sites with two separate databases that are the exact same.

I am considering developing with php and using truncate and insert select.

[Dr.CSS]

No idea why you need this, as you never really explain it...

But, export the DB from one and import it to the other when needed, as long as they have the same modules etc. they will be the same...