> -Original Message-
> On Tue, May 24, 2011 at 4:19 PM, Jerry Schwartz wrote:
>
> > It looks like there’s no way to rename a database. Is that true?
I know. Retarded right? Version 5.1.x and still what would seem the most basic
of tasks is still impossible.
Maybe Oracle can fix what M
From: Andrew Moore [mailto:eroomy...@gmail.com]
Sent: Tuesday, May 24, 2011 2:56 PM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: Renaming a database?
Could you try restoring the other db with another name and changing the
connection string in the app?
[JS] I could, but it wou
Could you try restoring the other db with another name and changing the
connection string in the app?
On 24 May 2011 16:20, "Jerry Schwartz" wrote:
> It looks like there’s no way to rename a database. Is that true?
>
>
>
> I have two reasons for wanting to do this:
>
>
>
> - I want to get a curren
>-Original Message-
>From: Andrew Moore [mailto:eroomy...@gmail.com]
>Sent: Tuesday, May 24, 2011 11:31 AM
>To: Jerry Schwartz
>Cc: mysql@lists.mysql.com
>Subject: Re: Renaming a database?
>
>Instead of renaming it, revoke permissions to it. If it's being used you
>should see some problems
>-Original Message-
>From: Johan De Meersman [mailto:vegiv...@tuxera.be]
>Sent: Tuesday, May 24, 2011 11:52 AM
>To: Jerry Schwartz
>Cc: mysql@lists.mysql.com
>Subject: Re: Renaming a database?
>
>- Original Message -
>> From: "Jerry Schwartz"
>>
>> It looks like there's no way to r
- Original Message -
> From: "Rik Wasmus"
>
> OK, but that would mean that the answer to the question:
>
> "I may be wrong here, but I tend to interpret this as
> '140054029002496' is trying to get an exclusive lock on 0x78733f8, on which
> it already has
> an exclusive lock, and hence
On 2011-05-24 16:30:13 you wrote:
> > 2 simultaneous queries with the same thread-id? Is that possible?
>
> No, not with the same thread-id. Deadlock occurs when two threads attempt
> to lock the same resources, but do so in an order which causes both sides
> to hold part of the resources the othe
- Original Message -
> From: "Jerry Schwartz"
>
> It looks like there’s no way to rename a database. Is that true?
Yes. Silly oversight, although there's probably complexity reasons behind it.
> - I want to get a current version of a database out of the way so
> that I can load in an old
Instead of renaming it, revoke permissions to it. If it's being used you
should see some problems in the application due to access denied.
Andy
On Tue, May 24, 2011 at 4:19 PM, Jerry Schwartz wrote:
> It looks like there’s no way to rename a database. Is that true?
>
>
>
> I have two reasons fo
It looks like there’s no way to rename a database. Is that true?
I have two reasons for wanting to do this:
- I want to get a current version of a database out of the way so that I can
load in an older version, without having to pay the penalty of reloading the
current version.
- I think
- Original Message -
> From: "Rik Wasmus"
>
> 2 simultaneous queries with the same thread-id? Is that possible?
No, not with the same thread-id. Deadlock occurs when two threads attempt to
lock the same resources, but do so in an order which causes both sides to hold
part of the resour
> > I may be wrong here, but I tend to interpret this as '140054029002496' is
> > trying to get an exclusive lock on 0x78733f8, on which it already has an
> > exclusive lock, and hence is deadlocked in some manner. Am I right
> > there? How can this happen?
>
> I'm not too hot on the internals, b
- Original Message -
> From: r...@grib.nl
>
> I may be wrong here, but I tend to interpret this as '140054029002496' is
> trying to get an exclusive lock on 0x78733f8, on which it already has an
> exclusive lock, and hence is deadlocked in some manner. Am I right there? How
> can this hap
This may be entirely down the wrong path, but I seem vaguely to remember that
RedHat has the datadir and stuff (semi-) hardcoded in /etc/init.d/mysql.
- Original Message -
> From: "Mario Deng"
> To: mysql@lists.mysql.com
> Sent: Tuesday, 24 May, 2011 1:08:41 PM
> Subject: MySQL Datadir
Hi all,
yesterday the mysql process on a database server became totallly unresponsive
after some long semaphore waits (load/cpu/memory were OK, as were all other
processes). The debug output started with this:
InnoDB: Warning: a long semaphore wait:
--Thread 140054029002496 has waited at /btr/b
Hi Folks,
I am trying to change the datadir for mysql. For this I performed the following
steps:
1: Create a new location for my datadir, e.g.: /media/spare/databases
2: Changed the ownership and permissions of this directory, e.g. "chown -R
mysql:mysql /media/spare/databases" and "chmod -R 755
- Original Message -
> From: "Rocio Gomez Escribano"
> Hello! Have this anwer from mysql,
> ++
> | TIMEDIFF(Date,now()) |
> -++
> | 70:56:06 |
> ++
> Is it possible to
Hello! Have this anwer from mysql,
++
| TIMEDIFF(Date,now()) |
-++
| 70:56:06 |
++
Is it possible to
18 matches
Mail list logo
