> The general answer to your question, if you're willing to cooperate
> with the server, is to lock the tables from within the server so that
> no other clients can modify them, and use FLUSH TABLES to flush any
> changes to disk.  While the lock remains in place, copy the table
> files.  Then unlock the tables.  Remember that the client that locks
> the table *must remain connected* while you copy the table files, because
> any locks are released automatically when the client connection ends.
> 
> Have a look at the mysqlhotcopy source for any idea of how it uses
> this approach.  Essentially, what it does is open a connection to the
> server, tells the server to lock the tables, and then while the tables
> are locked, goes "behind the server's back" to directly copy table files.
> (This is why mysqlhotcopy must be run on the server host.  It's also
> (I believe) why it doesn't work on WIndows: Windows file locking
> semantics do not allow you to copy a file while the server has it locked.)
> 
> By the way, it's difficult to see how automysqlbackup could corrupt any
> tables.  A quick look through it seems to indicate that it only uses
> mysqldump to perform backups.


Yes the script is using mysqldump with --opt , so these seems like what to
expect for mysqlhotcopy. When you read the MYSQL docs, mysqlhotcopy apears
to be the tool for choice for live servers. Maybe I'm not interpeting the
documentation correctly, maybe it refers to having to be on the SAME server
to run. 

I want the automysqlbackup script to run from cron at 4am..one site in
question is very busy still during that time. What does the user experience
who may in the middle of a write action to the database as the server starts
the mysqldump --opt process?

How can I do myisamchk with tables locked to make sure the tables are not
corrupt before I try this shell script again? I want to make sure I start
clean before I try it so that if it repeats the problem I can relate the
problem to the action just performed.


Mark Súsol
-------------------------------
u l t i m a t e ­ CreativeMedia
Web | Print | CD Media | eCommerce
www.ultimatecreativemedia.com
Ph: 301-668-0588


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to