On Wed, May 01, 2002 at 04:10:38PM +0200, Svend Erik H. Jørgensen wrote: > > Some how i have manged to delete a database, i'm not quite sure how. > > When i try to create the table's i get an error : > > 020501 15:08:38 InnoDB: Error: table noah/user already exists in InnoDB > internal > InnoDB: data dictionary. Have you deleted the .frm file > InnoDB: and not used DROP TABLE? Have you used DROP DATABASE > InnoDB: for InnoDB tables in MySQL version <= 3.23.43? > InnoDB: See the Restrictions section of the InnoDB manual. > InnoDB: You can drop the orphaned table inside InnoDB by > InnoDB: creating an InnoDB table with the same name in another > InnoDB: database and moving the .frm file to the current database. > InnoDB: Then MySQL thinks the table exists, and DROP TABLE will > InnoDB: succeed. > > Is there anyway to restore the table design's ?
Grab a copy of the deleted .frm file(s) from your most recent backup and put 'em back. -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 83 days, processed 2,169,823,962 queries (300/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
