Re: drop database after lost of synchro in innodb

2004-09-17 Thread Heikki Tuuri
: drop database after lost of synchro in innodb Thank a lot I succeeded in dropping the tablespace after deleting manually the files. I was just wondering if this is a good way to do thing. Nothing left in the bd that way? Would you have any suggestion on any book that would go deep in the mysql

Re: drop database after lost of synchro in innodb

2004-09-16 Thread Heikki Tuuri
Subject: drop database after lost of synchro in innodb --_=_NextPart_001_01C49B59.D21B539E Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hello =20 I am trying to drop a database but I have the following: ERROR 1016: = Can't open file

Re: drop database after lost of synchro in innodb

2004-09-16 Thread Heikki Tuuri
viesti - Lähettäjä: Duhaime Johanne [EMAIL PROTECTED] Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED] Lähetetty: Thursday, September 16, 2004 3:27 PM Aihe: RE : drop database after lost of synchro in innodb Thank you for your answer. But both frm and ibd exist for every tables. I tried

drop database after lost of synchro in innodb

2004-09-15 Thread Duhaime Johanne
Hello I am trying to drop a database but I have the following: ERROR 1016: Can't open file: 'Alias.InnoDB' (errno: 1) In fact it looks like the synchro is lost between FRM and IBD. (I use a multiple tablespace configuration) according to http://www.innodb.com/ibman.php section 15.1.