Johanne, have you moved .ibd files and .frm files around?
Looks like the .frm file and the .ibd file exists, but the InnoDB table is missing from the InnoDB data dictionary inside the ibdata1 file. Try removing BOTH the .frm file and .ibd file manually. Regards, Heikki ----- Alkuperäinen 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 to delete the frm for every tables (copy somewhere else out ouf the databases) but still the drop database did not work. I then have: ERROR 1010: Error dropping database (can't rmdir './taptag', errno: 17) because the tablespace files exists Thank you very much for your help. JOhanne -----Message d'origine----- De : Heikki Tuuri [mailto:[EMAIL PROTECTED] Envoyé : 16-Sep-04 3:46 AM À : [EMAIL PROTECTED] Objet : Re: drop database after lost of synchro in innodb Johanne, looks like the file Alias.frm exists, but the corresponding InnoDB table does not exist. Delete manually the .frm file. Then it should be in sync again. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Order MySQL technical support from https://order.mysql.com/ ----- Original Message ----- From: ""Duhaime Johanne"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Wednesday, September 15, 2004 10:26 PM 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: 'Alias.InnoDB' (errno: 1) =20 > In fact it looks like the synchro is lost between FRM and IBD. (I use a = > multiple tablespace configuration) according to=20 > http://www.innodb.com/ibman.php section 15.1. > =20 > =20 > What is the proper way to drop the database in that case. Can I use the = > unix command on the file system?=20 > =20 > Thank you in advance for your help. > =20 > =20 > Johanne Duhaime > IRCM > 110 avenue des Pins Ouest > Montr=E9al, Qu=E9bec > Canada > H2W 1R7 > courrier: [EMAIL PROTECTED] > tel: (514) 987-5556 > fax: (514) 987-5644 > =20 > =20 > > ------_=_NextPart_001_01C49B59.D21B539E-- -- 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]
