What are the implications of copying *.ISM,*.ISD,*.frm files while MySQL is
still running? Basically, I am proposing that I could copy these files
while MySQL is running, for a descent backup. Before I restore, I would
obviously have to isamchk everything.
Taking the database down is a big loss, however, so I am wondering about
this option. I know it's not the cleanest, but would it work? The files
would be messed up if copied while an insert/update was taking place, but
again , teh isamchk *should* correct that, just with a little data loss.
Are there any other GOOD options for backing up a database server with lots
of databases and lots of table sin each database, without stopping the