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]
