Updating mysql database only with delta data

2005-04-04 Thread BG Mahesh 

hi

I have a huge mysql database on the live server. Every 15 days few 1000 records 
change in that database [additions/updations/deletions]

I don't want to upload the entire mysql database every 15 days as the file size 
is huge. Is there anyway for me to just upload the delta data and use some 
script to apply those delta changes on the live server?

regards,

--
B.G. Mahesh
[EMAIL PROTECTED]
http://www.indiainfo.com/

-- 
__
IndiaInfo Mail - the free e-mail service with a difference! www.indiainfo.com 
Check out our value-added Premium features, such as an extra 20MB for mail 
storage, POP3, e-mail forwarding, and ads-free mailboxes!

Powered by Outblaze

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Updating mysql database only with delta data

2005-04-04 Thread Gleb Paharenko 
Hello.



MySQL supports incremental backups. See:



  http://dev.mysql.com/doc/mysql/en/backup.html











BG Mahesh [EMAIL PROTECTED] wrote:

 

 hi

 

 I have a huge mysql database on the live server. Every 15 days few 1000 rec=

 ords change in that database [additions/updations/deletions]

 

 I don't want to upload the entire mysql database every 15 days as the file =

 size is huge. Is there anyway for me to just upload the delta data and use =

 some script to apply those delta changes on the live server?

 

 regards,

 

 --

 B.G. Mahesh

 [EMAIL PROTECTED]

 http://www.indiainfo.com/

 

 --=20

 __

 IndiaInfo Mail - the free e-mail service with a difference! www.indiainfo.c=

 om=20

 Check out our value-added Premium features, such as an extra 20MB for mail =

 storage, POP3, e-mail forwarding, and ads-free mailboxes!

 

 Powered by Outblaze

 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   ___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]