Re: Drop Table Problem
Try running a flush tables in mysql to make sure that mysqld knows about all the tables on disk. xtcsuk wrote: Running the command: Drop table if exists table1 complaints of table1 does not exist (Error: 1051). However, if table1 is swapped with another table, irrespective of its existence it works just fine. Running a Show Table command lists table1 as an existing table and trying to create table1 complaints of this table already eixsts. Please advise. regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Drop Table Problem
Running the command: Drop table if exists table1 complaints of table1 does not exist (Error: 1051). However, if table1 is swapped with another table, irrespective of its existence it works just fine. Running a Show Table command lists table1 as an existing table and trying to create table1 complaints of this table already eixsts. Please advise. regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: DROP TABLE problem!
At 12:37 31/05/2001 +0200, Vili Germic wrote: Hi! The issue mentioned is relative to the Windows security privileges. If the workstation connected or the local user doesn't has privileges to delete files on the /mysql tree, that error message is launches. Click over the MySQL folder icon with the right button and selecting the properties menu option, take a look if the folder has a sharing definition. The best way to install the MySQL Server on NT/Windows 2000 machines, is to do the install as Administrator, create a workgroup and add the users for that group. Then define individually the privileges for every user. Add the folder MySQL to the workgroup. After this use the GRANT command to edit the privileges for every user/host/db on the MySQL server. Regards, Miguel >Hello everybody, > >MySQL - 3.23.38 Win >MyODBC - 2.50.37 > >I'm using MySQL on local machine with Win2000 plattform, using MyODBC(ver. >2.50.37) to connect to db trought ODBC. Things works well, except for >dropping table. I'm using ODBC API in MS Visual C++ 6.0 to connect to ODBC. >Trought SQL statements I can create table well. But when I use sql statement >"DROP TABLE", I get error: Error on delete of 'xxx.MYI' (Errcode:13). Note, >that things works well if I'm connected from Win2000 to MySQL server that >runs on Linux, trought the same MyODBC driver (2.50.37), with the same ODBC >DSN settings! So I think (maybe I'm wrong), that the problem must be in >MySQL-Win server (not in ODBC driver)! >Do you have any idea about the problem? I would apreciate any help from you! > >Best Regards, Vili Germic. > > -- For technical support contracts, go to https://order.mysql.com/ __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano <[EMAIL PROTECTED]> /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil <___/ Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: DROP TABLE problem!
Just one thing I can think of.. Have you got GRANT privileges to drop DB? Simon -Original Message- From: Vili Germic [mailto:[EMAIL PROTECTED]] Sent: 31 May 2001 11:37 To: [EMAIL PROTECTED] Subject: DROP TABLE problem! Hello everybody, MySQL - 3.23.38 Win MyODBC - 2.50.37 I'm using MySQL on local machine with Win2000 plattform, using MyODBC(ver. 2.50.37) to connect to db trought ODBC. Things works well, except for dropping table. I'm using ODBC API in MS Visual C++ 6.0 to connect to ODBC. Trought SQL statements I can create table well. But when I use sql statement "DROP TABLE", I get error: Error on delete of 'xxx.MYI' (Errcode:13). Note, that things works well if I'm connected from Win2000 to MySQL server that runs on Linux, trought the same MyODBC driver (2.50.37), with the same ODBC DSN settings! So I think (maybe I'm wrong), that the problem must be in MySQL-Win server (not in ODBC driver)! Do you have any idea about the problem? I would apreciate any help from you! Best Regards, Vili Germic. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
DROP TABLE problem!
Hello everybody, MySQL - 3.23.38 Win MyODBC - 2.50.37 I'm using MySQL on local machine with Win2000 plattform, using MyODBC(ver. 2.50.37) to connect to db trought ODBC. Things works well, except for dropping table. I'm using ODBC API in MS Visual C++ 6.0 to connect to ODBC. Trought SQL statements I can create table well. But when I use sql statement "DROP TABLE", I get error: Error on delete of 'xxx.MYI' (Errcode:13). Note, that things works well if I'm connected from Win2000 to MySQL server that runs on Linux, trought the same MyODBC driver (2.50.37), with the same ODBC DSN settings! So I think (maybe I'm wrong), that the problem must be in MySQL-Win server (not in ODBC driver)! Do you have any idea about the problem? I would apreciate any help from you! Best Regards, Vili Germic. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php