Posted by Jerry Stuckle on 12/25/75 11:46

Gordon Burditt wrote:
>>>If you're just doing backups, you can also just tarzip the mysql data dir
>>>and do a quick and dirty backup that way.
>
>
> "dirty" is a good word for it. Unless you make sure that all changes
> have been flushed to disk, and that no other changes are made during
> making the backup, what you save may not be up to date (or even
> consistent). For example, shut down the server (cleanly) first.
>
>
>>That's not safe at all. For instance - if MySQL is upgraded, your backups may
>>suddenly be unusable.
>
>
> To the extent that the backups are good at all, you can still restore
> those backups on a machine running the old version, then mysqldump,
> and restore on the new version. This is, of course, a lot of
> trouble compared to doing it right with mysqldump the first time.
>
> Gordon L. Burditt

If you have a machine running the old version, that is.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]