Is it possible to setup replication so you would have another server to do backups on? Replicate the data, do whatever you want to the spare, and then delete the data from the production server.
On 4/19/06, balaraju mandala <[EMAIL PROTECTED]> wrote: > > Hi Everybody, > > I need a suggestion regarding mysqldump. My problem is my application is > creatiing around 500Mb of data per day. As i want my application run > 24*7*365. I need a mechanisem where i can move, previous day's data to > another location(i.e) at any given time i just want to store one or two > days > data only in my current DB. > > So i planned to make this by using mysqldump, as u know it will create > files > which we can upload where ever we need. Is this is a good idea, or we have > another better mechanisem? > > I am planning to automate this using Java. Is we have any prebiuild tools > for this? > >
