Dan, have you tried this? It's been a really long time since I pored over the file system internals, and it was on HFS, but what happens when you move a file to another file system? I would think the inode for the open, original file would stay in place and the daemon would keep merrily using it until it was shut down.
"UNIX don't care..." Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -----Original Message----- > From: Dan Buettner [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 18, 2006 2:16 PM > To: George-Cristian Bîrzan > Cc: mysql@lists.mysql.com > Subject: Re: InnoDB messup > > Can you just put the files back where they were originally? > Ordinarily that would be in the path set up in mysql - see SHOW > VARIABLES LIKE "datadir" > > You do need to have your ibdata* files and ib_logfile* files all in > there, assuming you weren't using the file-per-table setup (if you > were then I am not sure; haven't tried that one yet myself). > > I'd shut down the server process, move everything into place, > double-check permissions on the files, and then start the mysqld > server process back up. > > Dan > > > On 10/18/06, George-Cristian Bîrzan > <[EMAIL PROTECTED]> wrote: > > Hello! I'm having some troubles fixing an InnoDB messup, > maybe somebody will > > be able to help me with at least knowing if it's a lost cause... > > > > A colleague of mine moved the ib* files around, with MySQL > (5.0.15) still > > running, which didn't really do it justice... The problem > might've been made > > worse by the fact that the server was out of space at the > time, which was what > > he was trying to fix. > > > > Now, when starting MySQL with innodb_force_recovery set to > 1, I get the errors > > in http://hephaestus.rdsct.ro/~gcbirzan/mysql.log. > > > > So, bottom line, lacking any relevant backups, is there a > way to fix this? > > (Well, I have the .MYD and .MYI from back when the table > was MyISAM, but I > > lack the .frm, and using an older one makes MySQL segfault...) > > > > -- > > George-Cristian Bîrzan > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
