Hi all. My boss just pulled the power on our MySQL server. Yes, I've already thanked him. It's a 4.0.18 server, with MyISAM tables and InnoDB tables, running on a 2.6.5 kernel and XFS filesystem. The XFS recovery proceeded without any complaints. The InnoDB recovery also seemed to go smoothly ( great work by the way ): 040506 9:38:41 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 1032429395 InnoDB: Doing recovery: scanned up to log sequence number 0 1032430197 040506 9:38:42 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed InnoDB: Last MySQL binlog file position 0 139443, file name ./screamer-bin.210 040506 9:38:42 InnoDB: Flushing modified pages from the buffer pool... 040506 9:38:42 InnoDB: Started I've done a 'myisamchk' on all the MyISAM tables. They were all OK. My question is: should I trust my data now? I have plain-text logs and nightly backups, so I can ( and have before ) drop the whole thing tonight after work and import from last night's backup, then run the transaction logs through. However this is a lengthy and painful process, largely due to us having a lot of 'create temporary table' statements without matching 'drop table' statements - so I have to manually edit the log and delete this stuff ( it's only used for selects anyway ). I've been meaning to learn up on the binary logs, but never gotten around to it. So anyway, should I bother with a restore? What's the chance of having data corrupted / missing after a power 'failure' and recovery as above? Thanks! Dan --
IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au |
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]