Re: Backup Question from newbie.
Posted by:
paddy
Date: May 23, 2006 04:34PM
Backing up data directories using tar after shutting MySQL server should work for MyISAM and other tables. It may not work for InnoDB tables (depends on the location of data and log directories).
mysqldump creates a dump file that contains SQL statements (CREATE TABLE, INSERT, ....) that might be larger than the actual data and log file. So it is ok for the mysqldump file to be larger than
the tar image.
Have you looked at using LVM or EVMS snapshots or MySQL replication so that you can do live backups instead of shutting down the server process
Paddy
http://www.zmanda.com
Subject
Views
Written By
Posted
2920
April 09, 2006 09:44AM
Re: Backup Question from newbie.
2029
May 23, 2006 04:34PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.