Thank you guys, let me try in this way, i will come back if i get any problems.
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? > > >