#36 mysql5 support - completely cleaned up initdb-mysql

closed-out-of-date
nobody
None
5
2011-03-13
2006-09-13
Auke Kok
No

Here's a gratuitous mysql initdb file that not only
fixes the mysql5 setup problem but does a full cleanup
to the file which was badly needed. For 0.9.5.

Discussion

  • Auke Kok
    Auke Kok
    2006-09-13

     
    Attachments
  • Paul D. Smith
    Paul D. Smith
    2007-03-20

    Logged In: YES
    user_id=30808
    Originator: NO

    Nice, but there's a bug here; the last line should read:

    GRANT ALL ON `lxrtest`.* TO `lxr`@`localhost`;

    (note the extra backticks in the user@host field).

     
  • Paul D. Smith
    Paul D. Smith
    2007-03-20

    Logged In: YES
    user_id=30808
    Originator: NO

    Whoops. Change `lxrtest` back to `lxr` :)

     
  • Paul D. Smith
    Paul D. Smith
    2007-03-22

    Logged In: YES
    user_id=30808
    Originator: NO

    Ouch, there's another bug in this version of initdb-mysql. In the lxr_releases table, one of the fields is left off the primary key. The line:

    PRIMARY KEY     \(\`fileid\`\)
    

    Should instead be:

    PRIMARY KEY     \(\`fileid\`,\`release\`\)
    

    Also, I don't know why the comment "/* Broken */" appears before this table... it's certainly broken without the release in the primary key, since many different releases can have the same fileid present!

     
  • Andre-Littoz
    Andre-Littoz
    2011-03-13

    • status: open --> closed
     
  • Andre-Littoz
    Andre-Littoz
    2011-03-13

    Fixed sometime in the past

     
  • Andre-Littoz
    Andre-Littoz
    2011-03-13

    • status: closed --> closed-out-of-date