MySQL BackUp

[Alexander Dalloz]

Jeff Vian schrieb:

>On Tue, 2006-07-18 at 16:13 +0530, Kaushal Shriyan wrote:
>  
>
[ ... ]

>  
>
>>Can I have incremental backup of MySQL Database and how do i do it
>>
>>    
>>
>short answer -- NO. 
>Only if you had a transaction log that spanned the time between backups
>would this even remotely be possible.
>
>I would NEVER consider doing an incremental back up on a database.  The
>data is only consistent at a given point in time and there would be an
>enormous risk of inconsistencies appearing if the restore was done in an
>improper sequence (even if it were possible, which AFAIK it is not).
>
>  
>
>>Kaushal
>>
>>    
>>
Doing backups for a valid restore is a serious topic for RDBMS.

http://en.wikipedia.org/wiki/Database_management_system
http://en.wikipedia.org/wiki/ACID

Just doing a copy (cp, rsync, "whatever") of the MySQL DB files is worst 
you can do. Reading the MySQL documentation is important.

http://dev.mysql.com/doc/refman/4.1/en/backup.html

You too should pay attention to different DB types MyISAM (-> mysqldump 
parameter --opt) and InnoDB (-> mysqldump parameter --single-transaction).

Alexander