#26 drop database if exists in initdb-mysql

Bugfix
closed-fixed
DB backends (8)
5
2003-05-02
2002-08-05
Anonymous
No

At least in the version used here (3.23.49), mysql
accepts "drop database if exists" (as stated in the
mysql documentation), but does not accept "drop if
exists database".

--- initdb-mysql~ Mon Aug 5 18:40:29 2002
+++ initdb-mysql Mon Aug 5 18:40:29 2002
@@ -1,7 +1,7 @@
/* Read this into mysql with "\. initdb-mysql" when
logged in as root
to delete the old lxr database and create a new */

-drop if exists database lxr;
+drop database if exists lxr;
create database lxr;
use lxr;

Discussion

  • Barry Rountree

    Barry Rountree - 2002-08-18

    Logged In: YES
    user_id=534369

    Verified here as well, mysql 3.23.47.

    Barry Rountree

     
  • Malcolm Box

    Malcolm Box - 2003-05-02

    Logged In: YES
    user_id=215386

    Fixed in latest CVS

     
  • Malcolm Box

    Malcolm Box - 2003-05-02
    • assigned_to: nobody --> mbox
    • status: open --> closed-fixed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks