Syncronizing updates from file to mysql

Syncronizing updates from file to mysql

am 18.10.2006 21:21:13 von mohitanchlia

Is it possible to upload just the changes made to file since last time
it was imported/updated to the database.

For Eg:

1. File A has String "One"
2. This get uploaded to mysql table
3. File A is updated and now it has
"One"
"Two"
4. Only "Two" gets uploaded to mysql

Something like rsync that just does incremental transfer. Can we do
this between file and mysql.

Re: Syncronizing updates from file to mysql

am 19.10.2006 07:45:43 von peterloh

AFAIK, MySQL doesn't support differential backups. However, you can
backup and restore individual tables.

mohitanchlia@gmail.com wrote:
> Is it possible to upload just the changes made to file since last time
> it was imported/updated to the database.
>
> For Eg:
>
> 1. File A has String "One"
> 2. This get uploaded to mysql table
> 3. File A is updated and now it has
> "One"
> "Two"
> 4. Only "Two" gets uploaded to mysql
>
> Something like rsync that just does incremental transfer. Can we do
> this between file and mysql.