Don't know if this is related but database drop can run into trouble
if there are foriegn key relationships.  My understanding is that Drop
Database in Mysql deletes tables in a random order, and so if it tries
to delete the wrong parent/child table before the correct one there
will be an error and it misses that table from the drop.  Re-running
the drop command it then selects the tables again in a different order
and you might get lucky and it delete them all (at which point it
drops the database).

There is a better description of this problem in the user comments
here:
http://dev.mysql.com/doc/refman/5.0/en/drop-database.html

Antony

PS How did anyone ever learn to program before the invention of search
able online help forums?

--~--~---------~--~----~------------~-------~--~----~
Insoshi developer site: http://dogfood.insoshi.com/
Insoshi documentation: http://docs.insoshi.com/

You received this message because you are subscribed to the Google
Groups "Insoshi" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/insoshi?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to