MySQL Forums
Forum List  »  Backup

Re: Backup script using mysqlhotcopy question
Posted by: Troy Meyerink
Date: May 26, 2005 10:16AM

From what I have tested so far, it looks like if the table hasn't changed then its correlating file doesn't get copied over. I am using the --allow-old option, so the dbname_old directory is being deleted after successful copies and that is probably changing my backup dir timestamps. As I look inside the hot backup directory over time, I see only some of the table file timestamps being changed, which leads me to believe that the changed tables are being copied over. As soon as I get a test box, I will validate this test.

Troy Meyerink
SGT Inc.
National Center for Earth Resources Observation and Science
Sioux Falls, SD
meyerink@usgs.gov

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Backup script using mysqlhotcopy question
2964
May 26, 2005 10:16AM


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.