Can't drop database that shows up in show databases

SHOW DATABASES; shows that I have a database called test, but when I call DROP DATABASE test, I get ERROR 1008 (HY000): Can't drop database 'test'; database doesn't exist When I run any queries on that database, I get errors like: mysql select * from Users; ERROR 1017 (HY000): Can't find file:

Re: DBDesigner 4 and MySQL

look at this: http://forums.mysql.com/read.php?113,27031,39226#msg-39226 -- arman p. Sinapsis Peru http://www.sinapsisperu.com http://armandfp.blogspot.com/

Re: Can't drop database that shows up in show databases

Waynn- does the OS user you use to execute mysql have create/write/read/execute rights to the ./test folder? Martin- - Original Message - From: Waynn Lue [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Saturday, March 08, 2008 6:58 AM Subject: Can't drop database that shows up in show

Re: Can't drop database that shows up in show databases

Waynn: What user are you using to execute mysql from the command line? Perhaps run mysql (from command line) as root then execute the desired actions (such as drop). This will make sure you can drop the table and avoid any further problems. Sincerely, Craig Huffstetler On Sat, Mar 8, 2008 at

Re: Can't drop database that shows up in show databases

Hi, On Sat, Mar 8, 2008 at 6:58 AM, Waynn Lue [EMAIL PROTECTED] wrote: SHOW DATABASES; shows that I have a database called test, but when I call DROP DATABASE test, I get ERROR 1008 (HY000): Can't drop database 'test'; database doesn't exist When I run any queries on that database, I get

Re: Can't drop database that shows up in show databases

This problem actually started after I moved the datadir to another folder, so that's quite possible. We stopped everything, rsynced the folders over, then restarted mysql. But I do notice a permissions problem, since the owner currently is root. I'll chown it to mysql then see what happens. I'll

Regular Expressions in MySQL -- how to show addresses that have the same numbers?

Hi All, We've got a database (legacy, running MySQL 4.1.22 Standard) of constituents. We want to search through it for duplicates, and I've found that a good way to generate a list of potential duplicate addresses is to look for addresses that have matching street numbers, zipcodes, and last

Re: Comma's in data?

Use \ to escape. mysql insert into table1 values ('algo\,otra'); Query OK, 1 row affected (0.00 sec) mysql select * from table1; +---+ | a | +---+ | algo | | algo,otra | +---+ 2 rows in set (0.00 sec) On Sat, Mar 8, 2008 at 1:52 AM, J. Todd Slack [EMAIL

Re: Comma's in data?

At 12:23a -0500 on Sat, 08 Mar 2008, obed wrote: Use \ to escape. mysql insert into table1 values ('algo\,otra'); As an aside, I'm curious why the parser doesn't understand that the comma is part of the string in this context? It's already between two single quotes ... ? Shouldn't that be

Re: Comma's in data?

At 11:52 PM -0800 3/7/08, J. Todd Slack wrote: Hi All, I have a client that wants to insert data into a VarChar field that contains commas. These are property addresses. Example: 2966 Moorpark Ave, San Jose, CA, 95128 1 Infinite Loop, Cupertino, CA, 95 How can I allow this? Thanks!

mysqldump on specific columns only?

I'm trying to dump all the columns of a table but one in a restructuring of my schema. I found this post: http://www.jsw4.net/info/listserv_archives/mysql/05-wk49/msg00131.html which seems to indicate that this isn't possible, but I was wondering if anyone had any suggestions. My current