mysql mirroring?

[bubbles]

I have a local mysql database at home, and a remote mysql database on my webhosting account.

I want to have a cron job run a php script every hour on my local system that will update the remote database with any new changes on the local database, so they are sort of mirrored.

I want it to just update just new changes, not dump the whole database every time.

I remember being able to do this with MSSQL years ago but I'm not sure how to do it with mysql/php.

 

[-BokkeN-]

You can set up MySQL replication, it's the most effective way of achieving this. It is kind of a pain to set up initially, but it works great over long distances.

http://dev.mysql.com/doc/refman/5.0/en/replication.html

 

[ToddW2]

You can set up MySQL replication, it's the most effective way of achieving this. It is kind of a pain to set up initially, but it works great over long distances.

http://dev.mysql.com/doc/refman/5.0/en/replication.html

Yep works great!

 

[bubbles]

I only have a cheap shared account with so I don't think I can setup replication.

I suppose I could order a cheap VPS account and host it on that?

 

[ToddW2]

I only have a cheap shared account with so I don't think I can setup replication.

I suppose I could order a cheap VPS account and host it on that?

Yeah, standard VPS or a "Cloud" solution may work for you too.

Essentially both are VPS one just has elastic billing and some other foo-foo stuff.

 

[keenan]

If the schema is unchanging and you just want to mirror data you could also use triggers and track changes in a separate table that you then dump and clear and run against the other copy.