Dean, Seems your database has a table with foreign key constraints. You need to delete that table first and then you will be able to drop database successfully.
Hope that helps!!! Raza -----Original Message----- From: Dean A. Hoover [mailto:[EMAIL PROTECTED] Sent: Friday, May 14, 2004 4:13 AM To: [EMAIL PROTECTED] Subject: can't drop database: ERROR 1217 version: mysql Ver 12.22 Distrib 4.0.18, for pc-linux (i686) mysql> DROP DATABASE xxx; ERROR 1217: Cannot delete or update a parent row: a foreign key constraint fails what is this all about? how the heck can I drop the database? Dean Hoover -- 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]
