RE: Doubt regarding Mysqlsump

[Jerry Schwartz]

<snip>

>
>A single table is always consistent. Data inconsistency occurs in sets of
>interrelated tables, in other words, on the database level.
>
[JS] Not even a single table is always consistent (unless there is 
transactions). Consider a single transaction that consists of two steps:

1. Delete record A
2. Add record B

Now consider

1. Delete record A
-Backup starts-
2. Add record B

You have no idea whether or not record B will be in your backup.

Worse things can happen, of course:

1. Delete record A
!!KABOOM!!

The data in the table is not going to be consistent. You'd have to analyze the 
data to find out what did and didn't happen before the crash, back out step 1, 
and re-run that transaction in the application.


Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: [phone]
E-mail: jerry@stripped
Web site: www.the-infoshop.com



>
>--
>Bier met grenadyn
>Is als mosterd by den wyn
>Sy die't drinkt, is eene kwezel
>Hy die't drinkt, is ras een ezel
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:    http://lists.mysql.com/mysql?unsub=1