batch update database

Anon

Hello,

I want to make a website using PHP and Access or MySql as database. (first time)

My biggest problem is how to batch update the database.

What do I mean? Let's say I have a database of 1000 records used for the website. Each hour I want to update the website database with data stored in another similar database (the database on the web must be a copy of this one).
I don't want to update the website database manually record by record. I just want to upload the changes (not the whole database) from my real database to my website database.

Can anybody help me?

Anon

If you are rusing Mysql, have a look at the details on replication.

http://ftp.plig.org/pub/mysql/doc/R/e/Replication.html (UK mirror)

Anon

What I want to do is the following.

We have a unix system with a lot of databases ...

I want to export (changing) information from those databases into a new database (Access or MySql database). Information in this database must be transfered to the MySql database on the internet server.

Records must be added, deleted, updated.

My problem is how to get the changed information from the generated database in the internet database ?

Please help ...