So, mysql has an extension of SELECT, "INTO OUTFILE 'file_name'" This is great. Until you use a relative filename for file_name. (For example, their example).
At which point *the server* writes the output file into the directory that holds the database itself. Which, you don't notice. Until you come to try to drop that directory. Which fails, because it's not empty, because after removing all the files corresponding to the tables, there's still a file in there. OWNED BY THE SERVER. Not me. So my user can't delete it. Rah. mysql, I love you. Nicholas Clark
