On Thu, Oct 09, 2003 at 01:33:39PM +0200, Harald Fuchs wrote:
> In article <[EMAIL PROTECTED]>,
> Karel Zak <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
