y, March 04, 2004 12:09 PM
Subject: Re: MySQL Backup advice
> Hi Ware Adams,
>
> thanks for your answer. Here's another question:
>
> Is it possible to set MySQL to save all the changes that can happen,
for
> example, if some one insert a new record into table X, MySQL save a
l
Andre MATOS wrote:
>Is it possible to set MySQL to save all the changes that can happen,
>for example, if some one insert a new record into table X, MySQL save
>a log about this task performed and all data that was inserted. I
>another person update one field from table Y, MySQL save all the
>info
Hi Ware Adams,
thanks for your answer. Here's another question:
Is it possible to set MySQL to save all the changes that can happen, for
example, if some one insert a new record into table X, MySQL save a log
about this task performed and all data that was inserted. I another person
update one
Andre MATOS wrote:
>What is the best way to make a good and trustable backup from a live
>database, in other words, without shutdown the database? Is there any
>free open source tool for this also?
There's no free/open source tool that makes a true hot backup when
you're using InnoDB.
mysqldump
Hi,
I am using MySQL 4.0.18 with InnoDB and I would to have some suggestions
about how can I backup the data. I read in this list that some people are
using mysqldump, others are using some tools such as Hot Backup.
What is the best way to make a good and trustable backup from a live
database,
