check if you might have used

harishaero — Wed, 19 Jun 2013 08:33:59 +0000

check if you might have used dot anywhere in the database.. be it in the name of table or column...
I used a dot in "D.O.B" which is the reason for error..
working fine after i removed the dot

The directory has been

timjpriebe — Mon, 25 Feb 2008 06:30:07 +0000

The directory has been deleted, and there seems to be no adverse effects. Thanks for all the help!

Plus, unfortunately, I do

JeevesBond — Mon, 25 Feb 2008 00:41:17 +0000

Plus, unfortunately, I do not have root access to my server, even though it's a dedicated server.

If what Greg K suggested doesn't work, you're probably going to have to raise a support ticket with your hosts. Not having root access is a pain! We have that problem here.

I gave it a try myself, by manually creating a folder in /var/lib/mysql/borked.name, then tried to DROP DATABASE on it. It failed with the usual 'incorrect database name' error.

It doesn't help much, because you don't have root access, but deleting the database directory didn't have any nasty side-effects (as far as I could see: your mileage may vary).

try properly calling it's

Greg K — Sun, 24 Feb 2008 21:10:37 +0000

try properly calling it's name wrapping it with mySQL's quoting character, the backtick. ` <- to the left of the 1 key

SELECT `fieldname` FROM `database`.`table`;

DROP DATABASE `data.base`;

-Greg

The repercussions are what

timjpriebe — Sun, 24 Feb 2008 19:13:30 +0000

The repercussions are what worries me. I have over a dozen clients using databases on the same db server, so I need to know that whatever fix I try is not going to screw their stuff up.

Plus, unfortunately, I do not have root access to my server, even though it's a dedicated server.

Do you have root access to

teammatt3 — Sun, 24 Feb 2008 16:36:32 +0000

Do you have root access to the server? You should be able to go into the mysql data dir and delete the database at a file level. My data dir is /var/lib/mysql. Inside that directory, you will see all your databases (as directories), just remove the directory named after the database.

It worked for me. I don't know about the repercussions of doing it though...

I actually don't even need

timjpriebe — Sun, 24 Feb 2008 15:06:17 +0000

I actually don't even need the db any more. However, it won't let me delete or rename it, or even view the tables within it. I'm fine with completely deleting it, as it was just a temporary copy of another table.

Urm, I know this sounds

greg — Sun, 24 Feb 2008 09:28:50 +0000

Urm, I know this sounds kinda obvious which leaves me thinking it's not possible or you have already tried it, can't you rename the DB?

Or export all the tables, create another DB with the name you want and import the tables into that.

Yes, I did try that, to no

timjpriebe — Sun, 24 Feb 2008 07:53:02 +0000

Yes, I did try that, to no avail.

Have you tried escaping the

pr0gr4mm3r — Sun, 24 Feb 2008 01:10:43 +0000

Have you tried escaping the dot? So, if the database was "Some.DB", type in "Some\.DB".