|
|
Posted by Gordon Burditt on 10/23/86 11:46
>> 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
Navigation:
[Reply to this message]
|