473,569 Members | 2,698 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Syncronizing updates from file to mysql

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.

Oct 18 '06 #1
1 2223
AFAIK, MySQL doesn't support differential backups. However, you can
backup and restore individual tables.

mo**********@gm ail.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.
Oct 19 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
5647
by: Gary | last post by:
I haver a table of students - Say 100 students that I need to be able to update/delete and amend. I know I can do this one student at a time which is simple but lets say I want to see all the students on the screen at the same time, modify some, mark some for deletion and even have blank fields at the end to add a new record. In HTML which...
1
1876
by: Craig Stadler | last post by:
Using mysql 4.0.23- What is the best way to execute several (hundreds of) inserts and updates? Rather than issuing tons of individual inserts and updates, can I send the strings to a text file and then have mysql do them all?? IE : query.txt insert into table1 (col1,col2) values (1,2);
7
1641
by: Martin Woolley | last post by:
Hi, could someone explain the following please? I have a Java application (app A) which "polls" a MySQL database table for records with a certain column set to 0. It runs continuously, utilising the same commection repeatedly. The other day, I had a support call raised, whereby there were clearly suitable records in the database, but my...
5
3547
by: JG | last post by:
Hi all, Does anyone know how the implementations on Linux and Windows handle synchronization between a read and write FD open to the same file. For example, if I have 2 FD open to file X.txt. 1 I use for reading, the other for writing. If I write to position 125 on the write_FD, call flush, and then turn around and read from the read_FD...
0
983
by: Rob Smeets | last post by:
Hi, i'm trying to grasp the concept of syncronizing threads, but without success Here is the situation: I'm using an object which connects to a server. After connection i want to send informational requests. If i send a request and the object is not connected yet i tell the Component to connect(sub RequestInfo).
0
1172
by: mmcquade.forums | last post by:
Hey everyone, Let me give you a rundown on our setup. We're a small, small firm, so please take this setup with a grain of salt, with both of us knowing it's probably not the best setup ever (and I'm more than happy to hear suggestions). On our webserver we have a MySQL database that collects information on our clients (name, address,...
1
1971
by: Jon Ebersole | last post by:
I am developing a webservice and a windows application that talk to each other. They are using a standard VB class library in the background. I am having problems understanding why I can't sync my namespaces properly. Example; My Windows namespace is MyCompany.MyWindowsSpace My Webservice namespace is MyCompany.MyWebService My Class...
0
2910
by: D0c | last post by:
Hey, I would like to syncronize my local database with my website database. Scenarios are 1. New rows / row updates in the local database to be updated on the website database (local -net) 2. Updates on the website database to be updated on the local database (net -local) * Updates for both databases are possibly on different fields
2
1148
juve11
by: juve11 | last post by:
hello, i have an app (WICH IS NOT MINE so i dont have source code) installed on 5 computers and a mysql server. this app works with two tables from a mysql database (lets say table_A and table_B) i need to change the server,so i made a backup of mysql database and put it on the new server,i created a mysql user to handle connections and i...
0
7924
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8122
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7673
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7970
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6284
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5219
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3640
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2113
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1213
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.