Re: DROP DATABASE
Hi, Does drop database command removes all the users permissions related with that databases or those user permissions has to be revoke manually. DROP DATABASE does not remove the privileges. You have to remove that separately. Best regards, Aleksandar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: DROP DATABASE
Hi Bradaric, On my system innodb storage engine is used. If i drop all the databases even then also i cannot reclaim the free space. For that i need to remove the ibdata , ib_logfile0, ib_logfile1 and other databases folder. then restart mysql. What will be the impact if i don't remove the users privileges. Does mysql will restart successfully or not. OR should i remove the users privileges before dropping the database. Please guide me. Regards, krishna On 8/17/07, Aleksandar Bradaric [EMAIL PROTECTED] wrote: Hi, Does drop database command removes all the users permissions related with that databases or those user permissions has to be revoke manually. DROP DATABASE does not remove the privileges. You have to remove that separately. Best regards, Aleksandar
RE: DROP DATABASE weirdness
Hi Bruce, Do you have any messages in the MySQL log? Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +61 8 8408 4273 _/ _/ _/_/_/ Mobile: +61 417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: Bruce Ferrell [mailto:[EMAIL PROTECTED] Sent: Thursday, 30 November 2006 9:42 AM To: mysql@lists.mysql.com Subject: DROP DATABASE weirdness I'm running MySQL 5.0.24a and I have a database I need to drop. When I issue the command DROP DATABASE webdb the client seems to just hang. I see the command hit the server in the full log but the database never drops. Anyone have any suggestions? -- One day at a time, one second if that's what it takes -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: DROP DATABASE weirdness
I get this error: /usr/sbin/mysqld-max: relocation error: /usr/sbin/mysqld-max: undefined symbol: zlibCompileFlags Logan, David (SST - Adelaide) wrote: Hi Bruce, Do you have any messages in the MySQL log? Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +61 8 8408 4273 _/ _/ _/_/_/ Mobile: +61 417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: Bruce Ferrell [mailto:[EMAIL PROTECTED] Sent: Thursday, 30 November 2006 9:42 AM To: mysql@lists.mysql.com Subject: DROP DATABASE weirdness I'm running MySQL 5.0.24a and I have a database I need to drop. When I issue the command DROP DATABASE webdb the client seems to just hang. I see the command hit the server in the full log but the database never drops. Anyone have any suggestions? -- One day at a time, one second if that's what it takes -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: DROP DATABASE weirdness
Hi Bruce, Sounds like you are missing a library or two on the system. Did you compile the server yourself? Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +61 8 8408 4273 _/ _/ _/_/_/ Mobile: +61 417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: Bruce Ferrell [mailto:[EMAIL PROTECTED] Sent: Thursday, 30 November 2006 9:52 AM To: Logan, David (SST - Adelaide) Cc: mysql@lists.mysql.com Subject: Re: DROP DATABASE weirdness I get this error: /usr/sbin/mysqld-max: relocation error: /usr/sbin/mysqld-max: undefined symbol: zlibCompileFlags Logan, David (SST - Adelaide) wrote: Hi Bruce, Do you have any messages in the MySQL log? Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +61 8 8408 4273 _/ _/ _/_/_/ Mobile: +61 417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: Bruce Ferrell [mailto:[EMAIL PROTECTED] Sent: Thursday, 30 November 2006 9:42 AM To: mysql@lists.mysql.com Subject: DROP DATABASE weirdness I'm running MySQL 5.0.24a and I have a database I need to drop. When I issue the command DROP DATABASE webdb the client seems to just hang. I see the command hit the server in the full log but the database never drops. Anyone have any suggestions? -- One day at a time, one second if that's what it takes -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: DROP DATABASE weirdness
Yes, built with SSL support the build seemed to go OK and sometimes it works. I'm building on SuSE 9.2 using the src.rpm and the included spec file Logan, David (SST - Adelaide) wrote: Hi Bruce, Sounds like you are missing a library or two on the system. Did you compile the server yourself? Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +61 8 8408 4273 _/ _/ _/_/_/ Mobile: +61 417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: Bruce Ferrell [mailto:[EMAIL PROTECTED] Sent: Thursday, 30 November 2006 9:52 AM To: Logan, David (SST - Adelaide) Cc: mysql@lists.mysql.com Subject: Re: DROP DATABASE weirdness I get this error: /usr/sbin/mysqld-max: relocation error: /usr/sbin/mysqld-max: undefined symbol: zlibCompileFlags Logan, David (SST - Adelaide) wrote: Hi Bruce, Do you have any messages in the MySQL log? Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +61 8 8408 4273 _/ _/ _/_/_/ Mobile: +61 417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: Bruce Ferrell [mailto:[EMAIL PROTECTED] Sent: Thursday, 30 November 2006 9:42 AM To: mysql@lists.mysql.com Subject: DROP DATABASE weirdness I'm running MySQL 5.0.24a and I have a database I need to drop. When I issue the command DROP DATABASE webdb the client seems to just hang. I see the command hit the server in the full log but the database never drops. Anyone have any suggestions? -- One day at a time, one second if that's what it takes -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: DROP DATABASE weirdness
I think I found it. The system has zlib 1.1.4 the sources have zlib 1.2.3. Trying a static build now. Anyone wanna bet? :) Bruce Ferrell wrote: Yes, built with SSL support the build seemed to go OK and sometimes it works. I'm building on SuSE 9.2 using the src.rpm and the included spec file Logan, David (SST - Adelaide) wrote: Hi Bruce, Sounds like you are missing a library or two on the system. Did you compile the server yourself? Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +61 8 8408 4273 _/ _/ _/_/_/ Mobile: +61 417 268 665 *_/ **** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia inve nt --- -Original Message- From: Bruce Ferrell [mailto:[EMAIL PROTECTED] Sent: Thursday, 30 November 2006 9:52 AM To: Logan, David (SST - Adelaide) Cc: mysql@lists.mysql.com Subject: Re: DROP DATABASE weirdness I get this error: /usr/sbin/mysqld-max: relocation error: /usr/sbin/mysqld-max: undefined symbol: zlibCompileFlags Logan, David (SST - Adelaide) wrote: Hi Bruce, Do you have any messages in the MySQL log? Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +61 8 8408 4273 _/ _/ _/_/_/ Mobile: +61 417 268 665 *_/ **** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia inve nt --- -Original Message- From: Bruce Ferrell [mailto:[EMAIL PROTECTED] Sent: Thursday, 30 November 2006 9:42 AM To: mysql@lists.mysql.com Subject: DROP DATABASE weirdness I'm running MySQL 5.0.24a and I have a database I need to drop. When I issue the command DROP DATABASE webdb the client seems to just hang. I see the command hit the server in the full log but the database never drops. Anyone have any suggestions? -- One day at a time, one second if that's what it takes -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: DROP DATABASE weirdness
Nope, That didn't fix it. I'd uses MySQl provided rpms but they don't seem to have them got glib23 anymore. Suggestions? Bruce Ferrell wrote: I think I found it. The system has zlib 1.1.4 the sources have zlib 1.2.3. Trying a static build now. Anyone wanna bet? :) Bruce Ferrell wrote: Yes, built with SSL support the build seemed to go OK and sometimes it works. I'm building on SuSE 9.2 using the src.rpm and the included spec file Logan, David (SST - Adelaide) wrote: Hi Bruce, Sounds like you are missing a library or two on the system. Did you compile the server yourself? Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +61 8 8408 4273 _/ _/ _/_/_/ Mobile: +61 417 268 665 *_/ **** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia inve nt --- -Original Message- From: Bruce Ferrell [mailto:[EMAIL PROTECTED] Sent: Thursday, 30 November 2006 9:52 AM To: Logan, David (SST - Adelaide) Cc: mysql@lists.mysql.com Subject: Re: DROP DATABASE weirdness I get this error: /usr/sbin/mysqld-max: relocation error: /usr/sbin/mysqld-max: undefined symbol: zlibCompileFlags Logan, David (SST - Adelaide) wrote: Hi Bruce, Do you have any messages in the MySQL log? Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +61 8 8408 4273 _/ _/ _/_/_/ Mobile: +61 417 268 665 *_/ **** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia inve nt --- -Original Message- From: Bruce Ferrell [mailto:[EMAIL PROTECTED] Sent: Thursday, 30 November 2006 9:42 AM To: mysql@lists.mysql.com Subject: DROP DATABASE weirdness I'm running MySQL 5.0.24a and I have a database I need to drop. When I issue the command DROP DATABASE webdb the client seems to just hang. I see the command hit the server in the full log but the database never drops. Anyone have any suggestions? -- One day at a time, one second if that's what it takes -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: DROP DATABASE weirdness
Hi Bruce, Have a squiz here http://bugs.mysql.com/bug.php?id=16586 sounds suspiciously like your issue. Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +61 8 8408 4273 _/ _/ _/_/_/ Mobile: +61 417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: Bruce Ferrell [mailto:[EMAIL PROTECTED] Sent: Thursday, 30 November 2006 11:17 AM To: mysql@lists.mysql.com Cc: Logan, David (SST - Adelaide) Subject: Re: DROP DATABASE weirdness Nope, That didn't fix it. I'd uses MySQl provided rpms but they don't seem to have them got glib23 anymore. Suggestions? Bruce Ferrell wrote: I think I found it. The system has zlib 1.1.4 the sources have zlib 1.2.3. Trying a static build now. Anyone wanna bet? :) Bruce Ferrell wrote: Yes, built with SSL support the build seemed to go OK and sometimes it works. I'm building on SuSE 9.2 using the src.rpm and the included spec file Logan, David (SST - Adelaide) wrote: Hi Bruce, Sounds like you are missing a library or two on the system. Did you compile the server yourself? Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +61 8 8408 4273 _/ _/ _/_/_/ Mobile: +61 417 268 665 *_/ **** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia inve nt --- -Original Message- From: Bruce Ferrell [mailto:[EMAIL PROTECTED] Sent: Thursday, 30 November 2006 9:52 AM To: Logan, David (SST - Adelaide) Cc: mysql@lists.mysql.com Subject: Re: DROP DATABASE weirdness I get this error: /usr/sbin/mysqld-max: relocation error: /usr/sbin/mysqld-max: undefined symbol: zlibCompileFlags Logan, David (SST - Adelaide) wrote: Hi Bruce, Do you have any messages in the MySQL log? Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +61 8 8408 4273 _/ _/ _/_/_/ Mobile: +61 417 268 665 *_/ **** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia inve nt --- -Original Message- From: Bruce Ferrell [mailto:[EMAIL PROTECTED] Sent: Thursday, 30 November 2006 9:42 AM To: mysql@lists.mysql.com Subject: DROP DATABASE weirdness I'm running MySQL 5.0.24a and I have a database I need to drop. When I issue the command DROP DATABASE webdb the client seems to just hang. I see the command hit the server in the full log but the database never drops. Anyone have any suggestions? -- One day at a time, one second if that's what it takes -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: DROP DATABASE weirdness
Yeah, that is the bug exactly. I can't even get 5.0.27 to start it comes up with the exact same error. Maybe if I get rid of the SSL option but this sucks! Thanks for the help Logan, David (SST - Adelaide) wrote: Hi Bruce, Have a squiz here http://bugs.mysql.com/bug.php?id=16586 sounds suspiciously like your issue. Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +61 8 8408 4273 _/ _/ _/_/_/ Mobile: +61 417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: Bruce Ferrell [mailto:[EMAIL PROTECTED] Sent: Thursday, 30 November 2006 11:17 AM To: mysql@lists.mysql.com Cc: Logan, David (SST - Adelaide) Subject: Re: DROP DATABASE weirdness Nope, That didn't fix it. I'd uses MySQl provided rpms but they don't seem to have them got glib23 anymore. Suggestions? Bruce Ferrell wrote: I think I found it. The system has zlib 1.1.4 the sources have zlib 1.2.3. Trying a static build now. Anyone wanna bet? :) Bruce Ferrell wrote: Yes, built with SSL support the build seemed to go OK and sometimes it works. I'm building on SuSE 9.2 using the src.rpm and the included spec file Logan, David (SST - Adelaide) wrote: Hi Bruce, Sounds like you are missing a library or two on the system. Did you compile the server yourself? Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +61 8 8408 4273 _/ _/ _/_/_/ Mobile: +61 417 268 665 *_/ **** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia inve nt --- -Original Message- From: Bruce Ferrell [mailto:[EMAIL PROTECTED] Sent: Thursday, 30 November 2006 9:52 AM To: Logan, David (SST - Adelaide) Cc: mysql@lists.mysql.com Subject: Re: DROP DATABASE weirdness I get this error: /usr/sbin/mysqld-max: relocation error: /usr/sbin/mysqld-max: undefined symbol: zlibCompileFlags Logan, David (SST - Adelaide) wrote: Hi Bruce, Do you have any messages in the MySQL log? Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +61 8 8408 4273 _/ _/ _/_/_/ Mobile: +61 417 268 665 *_/ **** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia inve nt --- -Original Message- From: Bruce Ferrell [mailto:[EMAIL PROTECTED] Sent: Thursday, 30 November 2006 9:42 AM To: mysql@lists.mysql.com Subject: DROP DATABASE weirdness I'm running MySQL 5.0.24a and I have a database I need to drop. When I issue the command DROP DATABASE webdb the client seems to just hang. I see the command hit the server in the full log but the database never drops. Anyone have any suggestions? -- One day at a time, one second if that's what it takes -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: DROP DATABASE doesn't actually drop the database?
Thanks for your comments! I ran my entire script (DROP DATABASE and all) with the command-line client, and got no errors. Perhaps there is something with the Query Browser that is causing this problem. I added the IF EXISTS and IF NOT EXISTS in appropriate places (although I can see the database there beforehand, and see it disappear in MySQL Administrator, it shouldn't be necessary in this case because I know what is there). Of course, I still get the duplicate index errors in Query Browser, but I suspect it is that program and not the database server that is causing this. The reason I am scripting this manually is because I am trying to learn and practice MySQL (I come from a MS SQL Server background), and this database is very small (3 or 4 tables, a view and 2 stored procedures so far). It is not difficult to make a change and re-run the script. When I get anything good (and of decent size) going I'll start using the other options; right now I'm just playing with a throwaway database to get a feel for the syntax. On 3/13/06, Andreas Krüger [EMAIL PROTECTED] wrote: Stephen, the behavior of MySQL server sounds bizarre, as to what information you give us. For the DROP DATABASE and DROP TABLE statements, there is an option that prevents an error, if database or table don' t exist: DROP DATABASE* IF EXISTS *db_name DROP TABLE* IF EXISTS *tbl_name You might also want to have a look at the 5.0 manual: http://dev.mysql.com/doc/refman/5.0/en/drop-database.html http://dev.mysql.com/doc/refman/5.0/en/drop-table.html I am further astonished that you do script files manually for re-creating databases and tables.* Why don' t you use mysqldump for dumping a database and its tables mysql for loading the dumped information?* You can dump a database by mysqldump db_name db_name.sql There are many handy options to mysqldump as --add-drop-table and -all that you should consider to use You then can manually update the dump files in a text editor. mysql db_name db_name.sql recreates the dumped data with all tables. Andy Stephen Cook wrote: I am scripting out the creation of a database so I can make changes and then run the script to generate a clean copy (by running it in MySQL Query Browser). The script DROPs all the tables, then CREATEs them again along with all the indices and whatnot. However, if I run the script after having run it once (if I close the Query Browser and then open it again and reload the script later), I get error 1061 Duplicate key name on all of the indices. So I figured I missed something, and I'll just DROP the whole database and then run the script. I add a DROP DATABASE databasename; and a CREATE DATABASE databasename; at the start of my script and try to run it again. Now I get errors 1008 Can't drop database 'databasename'; database doesn't exist and 1007 Can't create database 'databasename'; database exists, followed by the index errors above. If I drop the database from MySQL Administrator (or the command-line client), and then run the script again I get the same errors. The database and all of the scripted objects are created (properly as far as I can tell), but why would I get these errors? I am using the latest version of MySQL (5.0.19) with InnoDB as the storage engine on Windows 2000 Professional SP4, but I have the same problem with 5.0.17. If there is any other information you need I'd be happy to supply it.
Re: drop database after lost of synchro in innodb
Johanne, DROP DATABASE is rather safe, if it succeeds. http://dev.mysql.com/doc/mysql/en/InnoDB.html is the best reference. Best regards, Heikki Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Order MySQL support from http://www.mysql.com/support/index.html - Alkuperäinen viesti - Lähettäjä: Duhaime Johanne [EMAIL PROTECTED] Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED] Lähetetty: Thursday, September 16, 2004 10:01 PM Aihe: RE : drop database after lost of synchro in innodb Thank a lot I succeeded in dropping the tablespace after deleting manually the files. I was just wondering if this is a good way to do thing. Nothing left in the bd that way? Would you have any suggestion on any book that would go deep in the mysql/innodb stuff. For example what to do in the present case? Thank you very much and have a nice day. Johanne -Message d'origine- De : Heikki Tuuri [mailto:[EMAIL PROTECTED] Envoyé : 16-Sep-04 11:14 AM À : [EMAIL PROTECTED] Objet : Re: drop database after lost of synchro in innodb Johanne, have you moved .ibd files and .frm files around? Looks like the .frm file and the .ibd file exists, but the InnoDB table is missing from the InnoDB data dictionary inside the ibdata1 file. Try removing BOTH the .frm file and .ibd file manually. Regards, Heikki - Alkuperäinen viesti - Lähettäjä: Duhaime Johanne [EMAIL PROTECTED] Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED] Lähetetty: Thursday, September 16, 2004 3:27 PM Aihe: RE : drop database after lost of synchro in innodb Thank you for your answer. But both frm and ibd exist for every tables. I tried to delete the frm for every tables (copy somewhere else out ouf the databases) but still the drop database did not work. I then have: ERROR 1010: Error dropping database (can't rmdir './taptag', errno: 17) because the tablespace files exists Thank you very much for your help. JOhanne -Message d'origine- De : Heikki Tuuri [mailto:[EMAIL PROTECTED] Envoyé : 16-Sep-04 3:46 AM À : [EMAIL PROTECTED] Objet : Re: drop database after lost of synchro in innodb Johanne, looks like the file Alias.frm exists, but the corresponding InnoDB table does not exist. Delete manually the .frm file. Then it should be in sync again. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Order MySQL technical support from https://order.mysql.com/ - Original Message - From: Duhaime Johanne [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Wednesday, September 15, 2004 10:26 PM Subject: drop database after lost of synchro in innodb --_=_NextPart_001_01C49B59.D21B539E Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hello =20 I am trying to drop a database but I have the following: ERROR 1016: = Can't open file: 'Alias.InnoDB' (errno: 1) =20 In fact it looks like the synchro is lost between FRM and IBD. (I use a = multiple tablespace configuration) according to=20 http://www.innodb.com/ibman.php section 15.1. =20 =20 What is the proper way to drop the database in that case. Can I use the = unix command on the file system?=20 =20 Thank you in advance for your help. =20 =20 Johanne Duhaime IRCM 110 avenue des Pins Ouest Montr=E9al, Qu=E9bec Canada H2W 1R7 courrier: [EMAIL PROTECTED] tel: (514) 987-5556 fax: (514) 987-5644 =20 =20 --_=_NextPart_001_01C49B59.D21B539E-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: drop database after lost of synchro in innodb
Johanne, looks like the file Alias.frm exists, but the corresponding InnoDB table does not exist. Delete manually the .frm file. Then it should be in sync again. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Order MySQL technical support from https://order.mysql.com/ - Original Message - From: Duhaime Johanne [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Wednesday, September 15, 2004 10:26 PM Subject: drop database after lost of synchro in innodb --_=_NextPart_001_01C49B59.D21B539E Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hello =20 I am trying to drop a database but I have the following: ERROR 1016: = Can't open file: 'Alias.InnoDB' (errno: 1) =20 In fact it looks like the synchro is lost between FRM and IBD. (I use a = multiple tablespace configuration) according to=20 http://www.innodb.com/ibman.php section 15.1. =20 =20 What is the proper way to drop the database in that case. Can I use the = unix command on the file system?=20 =20 Thank you in advance for your help. =20 =20 Johanne Duhaime IRCM 110 avenue des Pins Ouest Montr=E9al, Qu=E9bec Canada H2W 1R7 courrier: [EMAIL PROTECTED] tel: (514) 987-5556 fax: (514) 987-5644 =20 =20 --_=_NextPart_001_01C49B59.D21B539E-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: drop database after lost of synchro in innodb
Johanne, have you moved .ibd files and .frm files around? Looks like the .frm file and the .ibd file exists, but the InnoDB table is missing from the InnoDB data dictionary inside the ibdata1 file. Try removing BOTH the .frm file and .ibd file manually. Regards, Heikki - Alkuperäinen viesti - Lähettäjä: Duhaime Johanne [EMAIL PROTECTED] Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED] Lähetetty: Thursday, September 16, 2004 3:27 PM Aihe: RE : drop database after lost of synchro in innodb Thank you for your answer. But both frm and ibd exist for every tables. I tried to delete the frm for every tables (copy somewhere else out ouf the databases) but still the drop database did not work. I then have: ERROR 1010: Error dropping database (can't rmdir './taptag', errno: 17) because the tablespace files exists Thank you very much for your help. JOhanne -Message d'origine- De : Heikki Tuuri [mailto:[EMAIL PROTECTED] Envoyé : 16-Sep-04 3:46 AM À : [EMAIL PROTECTED] Objet : Re: drop database after lost of synchro in innodb Johanne, looks like the file Alias.frm exists, but the corresponding InnoDB table does not exist. Delete manually the .frm file. Then it should be in sync again. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Order MySQL technical support from https://order.mysql.com/ - Original Message - From: Duhaime Johanne [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Wednesday, September 15, 2004 10:26 PM Subject: drop database after lost of synchro in innodb --_=_NextPart_001_01C49B59.D21B539E Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hello =20 I am trying to drop a database but I have the following: ERROR 1016: = Can't open file: 'Alias.InnoDB' (errno: 1) =20 In fact it looks like the synchro is lost between FRM and IBD. (I use a = multiple tablespace configuration) according to=20 http://www.innodb.com/ibman.php section 15.1. =20 =20 What is the proper way to drop the database in that case. Can I use the = unix command on the file system?=20 =20 Thank you in advance for your help. =20 =20 Johanne Duhaime IRCM 110 avenue des Pins Ouest Montr=E9al, Qu=E9bec Canada H2W 1R7 courrier: [EMAIL PROTECTED] tel: (514) 987-5556 fax: (514) 987-5644 =20 =20 --_=_NextPart_001_01C49B59.D21B539E-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 'drop database' failing silently?
Kevin O' Riordan [EMAIL PROTECTED] wrote: this morning, I had a problem dropping a database from within mysql. mysql drop database mis; Query OK, 0 rows affected (0.00 sec) mysql show databases; +--+ | Database | +--+ | mis | | mysql| +--+ 2 rows in set (0.00 sec) mysql use mis; Database changed mysql show tables; Empty set (0.00 sec) I was logged in as mysql's root user at the time, and had successfully deleted other databases. I also tried dropping the database with 'mysqladmin', which likewise told me the database had been dropped, but didn't actually drop it. The solution I used was to stop mysqld and then rm the database from the filesystem. I'm using mysql version 3.23.58 on redhat 7.3. Apologies if this has been discussed before, but I couldn't find a reference to it in the archive. Elsewhere, I found that someone else has seen this problem[1], but found no answer. If anyone can give any hints as to what I should've done, or what went might've gone wrong at the time, I'd be grateful. Are there any non-mysql files in the directory of the database 'mis'? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 'drop database' failing silently?
this morning, I had a problem dropping a database from within mysql. Are there any non-mysql files in the directory of the database 'mis'? Should've added this. There was only one file in the 'mis' directory: -rw-rw-rw-1 mysqlmysql 44 Apr 30 09:51 file.out Which consisted of the following 186 char long line: 2 0 0 0 0 2004032200 no no no The file's access/mod/change times looked like: Access: Wed May 5 07:28:38 2004 Modify: Fri Apr 30 09:51:16 2004 Change: Fri Apr 30 09:51:16 2004 thanks, -kev -- eth0_ we sail inthe esat ship! eth0_ on grand canal dock! eth0_, declaring her loyalty in #phishtank (irc.indigo.ie) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 'drop database' failing silently? - solved.
this morning, I had a problem dropping a database from within mysql. [snip] The solution I used was to stop mysqld and then rm the database from the filesystem. Are there any non-mysql files in the directory of the database 'mis'? After a while, I realised you weren't asking a question, but rather giving an answer. In case it's of any use to anyone else here: if a database's dir contains non-database files, the dir will not be removed following a 'DROP DATABASE'. thanks Victoria! -kev -- My lord, this is our first offense, but not our last. If you will be easy with us this once, we promise, on our word as gentlemen, to try to do better next time. And next time sure we won't be fools to get caught. -Thomas Francis Meagher, being sentenced for treason, 1848. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: DROP DATABASE executes but fails to remove database!
Gartside, Friday, May 10, 2002, 3:45:07 AM, you wrote: G Windows 2K MySQL V ? (recent). Sorry, I'm not at my own machine at present, G can't check actual version number. G Installed, running and everything is ok, except I created a database called G 'xyz' as a test then decided to delete it. G I used the command: DROP DATABASE 'xzy';which returns a message that G the command executed successfully, affecting however many rows were in the G database at the time. G SHOW DATABASES; shows that the database is still there. G I then re-tried using command: DROP DATABASE if exists 'xyz'; with G the same result (no error messages). Please, check you database directory if there are any other files than MySQL table files (*.MYD. *.MYI, .frm etc.). MySQL doesn't remove database if there are any non-MySQL files in the dir. G I then tried using mysqladmin to do the job, with the same result. G I then used:DELETE G FROM mysql.db G WHERE Db = xyz; G which also executes successfully. :) You removed _users_ with _privileges_ on 'xyz' database, it's not related with database removal. G I test by using:SELECT db G FROM mysql.Db; G which reveals that the database is NOT there. Sure, you removed all matched rows from table 'db' :) G However! SHOW DATABASES; still G shows that the database is there! G I have also tried right click drop database in the GUI MySQL management G window. It fails to remove it. G I have stopped and re-started the service and the computer several times. G DROP DATABASE works fine for other databases I create and remove, just not G this one. Please, check your database directory! You have posted your letter 3 times and Heikki already asked you to check the dir. G Is this a curly one? Any help appreciated. G Andrew -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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 Database
David, Firstly are you sure it`s a database you have created and not a table? Either way try the following DROP DATABASE #Muffin; or DROP TABLE #Muffin; HTH Ade - 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 Database
Hi! Yes, it is a database. I recieve these errors, regardless if I use the semi-colon: Query: DROP DATABASE #Muffin Returns: ERROR 1064: You have an error in your SQL syntax near '' Query: DROP DATABASE '#Muffin' Returns: ERROR 1064: You have an error in your SQL syntax near ''#Muffin'' I assume the # character is the bandit I can also mention it's mysql-version 3.23.23-beta Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: den 25 januari 2001 11:45 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Drop Database David, Firstly are you sure it`s a database you have created and not a table? Either way try the following DROP DATABASE #Muffin; or DROP TABLE #Muffin; HTH Ade - 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 Database
Yes I've tried that, but it didn't work either... But now I recieved a "Database Muffin doesn't exist"-error instead! /d -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mikel King Sent: den 25 januari 2001 09:14 To: David Lidstrm Cc: Mysql@Lists. Mysql. Com Subject: Re: Drop Database Hi David, Have you tried DROP DATABASE "\#Muffin" ; ? Cheers, Mikel David Lidstrm wrote: Hi! I was testing some queries and now I've created a database named "#Muffin", and I cannot drop it! I've tried the following: DROP DATABASE #Muffin DROP DATABASE '#Muffin' DROP DATABASE "#Muffin" But it doesn't work! Please help! / David - 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 - 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 Database
Outside of MySQL, use a native OS command to rename or remove the directory named '#Muffin' . If you rename it 'foobar', you should be able to DROP it with MySQL. Cheers, Kent Hoover - 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 Database
Yes! This worked! I shut down mysqld, renamed the folder and then I could use a regular DROP query to get rid of the database! Thank you for the help, and all answers! Regards David -Original Message- From: Kent Hoover [mailto:[EMAIL PROTECTED]] Sent: den 25 januari 2001 14:55 To: [EMAIL PROTECTED] Subject: RE: Drop Database Outside of MySQL, use a native OS command to rename or remove the directory named '#Muffin' . If you rename it 'foobar', you should be able to DROP it with MySQL. Cheers, Kent Hoover - 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