Sri Gupta wrote:
Oh boy.
Well, luckily for me, I happened to have about 400,000 records in the messages
table, delete where status = 6 trimmed that down to four more than my
physmessages table.
Not sure where all the extra messages came from, maybe a bug in a long
discarded version. The DB is in 2.0 format and working well.
Now, I may awful person for saying this, but the thing with InnoDB is that
it's exceedingly complicated to make hot backups of, and I like having a nice
revisioned history of my mysql store, updated nightly with mysqlhotcopy
and rdiff-backup. I know that innodb has wonderful binary logging, but I'm
still not sure how to make backups of the DB without taking the database
offline..
Anyway, that discussion should be reserved for the mysql user mailing list.
mysqldump works-for-me.
--
________________________________________________________________
Paul Stevens mailto:[EMAIL PROTECTED]
NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED]
The Netherlands________________________________http://www.nfg.nl
