Hi Adarsh, I think this is the best option for you: http://www.percona.com/docs/wiki/percona-xtrabackup:start
There is also a commercial alternative, InnoBackup, but I imagine you like it free. Cheers Claudio On Jun 7, 2011 7:59 AM, "Adarsh Sharma" <adarsh.sha...@orkash.com> wrote: > Dear all, > > Is it possible to take backups of a table or complete database without > stopping the application that continuously inserts and select data from > the tables. > > For taking complete backup of a database I follow the below steps :- > > 1. First stop the application that insert & modifies tables. > 2. Mysqldump command to backup the tables. > 3. After complete backup , start the application. > > I know Mysql-Replication helps a lot to solve this issue but I have not > any extra server to configure it. > > So , Can I solve this issue without Replication so that I don't need to > stop my application & I must have consistent backups too. > > Please note that size of databases may be more than 100GB > > > Thanks > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com >
