On Thu, Oct 09, 2003 at 01:33:39PM +0200, Harald Fuchs wrote:
> In article <20031009061602.GB8513@zf.jcu.cz>,
> Karel Zak <zakkr@zf.jcu.cz> writes:
>
> > BTW, MySQL versions without transactions are unusable for 365/7/24
> > systems, because you cannot make backup of DB without transaction or
> > redo log.
>
> Huh? People have backed up their MyISAM tables with "mysqlhotcopy" or
> something like that for ages. This tool locks all tables and can take
^^^^^
:-)
> a significant amount of time for large databases. Since many people
> don't want that, they just create a small replication slave used
> exclusively for backup.
How sure you with integrity of backup without transaction? For example
references between tables...
Karel
--
Karel Zak <zakkr@zf.jcu.cz>
http://home.zf.jcu.cz/~zakkr/