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
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
Fo
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 sour
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 Fer
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
ginal 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 s
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?
Re
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
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
---
*
Hi Bruce,
Do you have any messages in the MySQL log?
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/* Hewlett-Packard Australia Ltd
*
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
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 an
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
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 t
> > 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 ques
> > 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 con
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 |
>
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.
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.
Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
> Mikel King
> Sent: den 25 januari 2001 09:14
> To: David Lidström
> Cc: Mysql@Lists. Mysql. Com
> Subject: Re: Drop Database
>
> Hi David,
>
> Have you tried D
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://w
Lidström
Cc: Mysql@Lists. Mysql. Com
Subject: Re: Drop Database
Hi David,
Have you tried DROP DATABASE "\#Muffin" ; ?
Cheers,
Mikel
David Lidström wrote:
> Hi!
>
> I was testing some queries and now I've created a database
> named "#Muffin", and I c
Hi David,
Have you tried DROP DATABASE "\#Muffin" ; ?
Cheers,
Mikel
David Lidström 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'
>
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];
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.p
25 matches
Mail list logo
