Re: InnoDB messup

2006-10-19 Thread George-Cristian Bîrzan
On Thu, Oct 19, 2006 at 11:03:11AM -0500, Mazur Worden, Kathy wrote: > I had this problem just this morning and wound up fixing it by changing > the innodb data and log file directories to new folders in the .cnf > file. This enabled to server to start up (new data and log files were > created) an

Re: InnoDB messup

2006-10-19 Thread Mazur Worden, Kathy
> > > -Original Message- > > From: Dan Buettner [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, October 18, 2006 2:16 PM > > To: George-Cristian B=EErzan > > Cc: mysql@lists.mysql.com > > Subject: Re: InnoDB messup > > > > Can you just put the files back wh

Re: InnoDB messup

2006-10-18 Thread George-Cristian Bîrzan
On Wednesday 18 October 2006 23:36, Dan Buettner wrote: > George-Cristian - is it possible that the *.frm files also got moved > about?? Nope. What I'm thinking is the logs got moved, server restarted, it created new ones and... -- George-Cristian Bîrzan Network Engineer ___

Re: RE: InnoDB messup

2006-10-18 Thread Dan Buettner
0.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 origin

Re: InnoDB messup

2006-10-18 Thread George-Cristian Bîrzan
TECTED] > > 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 s

RE: InnoDB messup

2006-10-18 Thread Jerry Schwartz
day, 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&quo

Re: InnoDB messup

2006-10-18 Thread Dan Buettner
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 a