Re: fairly current mysql v postgresql comparison need for

On Mon, 24 Mar 2003, Arjen van der Meijden wrote:

> > [mailto:pgsql-general-owner(at)postgresql(dot)org] Namens scott.marlowe
> > Verzonden: maandag 24 maart 2003 19:26
>
> > Oh, and another thing. How do you do hot backups of a MySQL database
> > running Innodb tables? Better get out the checkbook for some closed
> > source software.
> Please elaborate what you see as a hot backup tool?

For MySQL you need a special tool to backup innodb tables "hot". i.e.
while transactions are running or the database is in use. For Postgresql,
hot backups as well as cold are handled by pg_dump. The elaboration on
the tool needed is here:

http://www.mysql.com/doc/en/Backing_up.html

> Is that, for postgresql, the pg_dump tool? In that case, mysql has the
> same. Mysqldump works fine with innodb-tables as well as for myisam
> tables.

As long as there aren't any transactions pending while you run it. It
does have issues then. The hotbackuptool that MySQL comes with is
explicitly documented by the mysql folks as NOT working for innodb tables.