restoring datewise data

2005-12-06 Thread prathima rao
hello,

i have a database in mysql i want to restore the backup server every 15
minutes if i take a backup in sql its huge and my transfer cost of the data
will be very high can anyone suggest how to restore the data in small size

regards

prao



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



Re: restoring datewise data

2005-12-06 Thread anu bhaskar

prathima rao wrote:

hello,
i have a database in mysql i want to restore the backup server every 15
minutes if i take a backup in sql its huge and my transfer cost of the data
will be very high can anyone suggest how to restore the data in small size
regards
prao
  

time to think about replication..

thank you

--
anu bhaskar


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



Re: restoring datewise data

2005-12-06 Thread Gleb Paharenko
Hello.



 will be very high can anyone suggest how to restore the data in small

size



Have you thought about using binary logs or compressing the sql file?







prathima rao wrote:

 hello,

 

 i have a database in mysql i want to restore the backup server every 15

 minutes if i take a backup in sql its huge and my transfer cost of the data

 will be very high can anyone suggest how to restore the data in small size

 

 regards

 

 prao

 

 

 



-- 
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]