List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:June 7 2011 6:06am
Subject:Re: Doubt regarding Mysqlsump
View as plain text  
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.sharma@stripped> 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=1
>

Thread
Doubt regarding MysqlsumpAdarsh Sharma7 Jun
  • Re: Doubt regarding MysqlsumpClaudio Nanni7 Jun
    • Re: Doubt regarding MysqlsumpJohan De Meersman7 Jun
      • Re: Doubt regarding MysqlsumpAdarsh Sharma7 Jun
        • Re: Doubt regarding MysqlsumpJohan De Meersman7 Jun
          • Re: Doubt regarding MysqlsumpKaren Abgarian9 Jun
            • Re: Doubt regarding MysqlsumpJohan De Meersman9 Jun
              • Re: Doubt regarding MysqlsumpKaren Abgarian9 Jun
              • RE: Doubt regarding MysqlsumpJerry Schwartz9 Jun
                • RE: Doubt regarding MysqlsumpWm Mussatto9 Jun
                  • MySQL loses password?Tim Thorburn12 Jun
                    • Re: MySQL loses password?Johan De Meersman12 Jun
                      • Re: MySQL loses password?Tim Thorburn12 Jun
                        • Re: MySQL loses password?Claudio Nanni12 Jun
                          • Re: MySQL loses password?Tim Thorburn13 Jun
                            • Re: MySQL loses password?Claudio Nanni13 Jun
                            • Re: MySQL loses password?Andrew Moore13 Jun
  • Re: Doubt regarding MysqlsumpNilnandan Joshi7 Jun
    • Re: Doubt regarding MysqlsumpAdarsh Sharma7 Jun
  • Re: Doubt regarding Mysqlsumpmark carson7 Jun