mysql problem

[Rick Rosinski]

How do you "cycle" mysql?

Creating a dummy directory wouldn't help anything, because mysql is reporting 
that I have an actual error in my code.  I don't think it likes databases 
with dots in the file name.  I couldn't create or delete a database with a 
dot in the name, only by naming the directories "incorrectly".  (what a way 
to cause hell).



\On Wednesday 23 May 2001 07:29, you wrote:
> \_ SMTP quoth Rick Rosinski on 5/22/2001 22:53 as having spake thusly:
> \_
> \_ I am using mySQL 3.23.33.
> \_
> \_ Once, I had backed up my entire var directory into var.bak, but I made
> the \_ mistake of putting that subdirectory in var  ... so var/var.bak. 
> Now, \_ var.bak shows up in the list of databases that I have.  The var.bak
> \_ subdirectory is long gone, but I can't get rid of var.bak from my
> database \_ list.  When I invoke "drop database var.bak;", I get an error
> "You have an \_ error in your sql ... near '.bak'".  I don't know what to
> do about this, and \_ I need some help.
>
> Have you tried cycling mysql?
>
> Perhaps create a dummy directory and drop that?
>
> David
> ________________________________________________
> See http://PLUG.phoenix.az.us/navigator-mail.shtml if your mail doesn't
> post to the list quickly and you use Netscape to write mail.
>
> PLUG-discuss mailing list  -  PLUG-discuss@lists.PLUG.phoenix.az.us
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss

-- 
Rick Rosinski
http://rickrosinski.com
rick@rickrosinski.com