nan [mailto:suzuki_b...@yahoo.com]
> Sent: Friday, December 11, 2009 2:02 PM
> To: MySql; Michael Dykman
> Subject: Re: Are you serious? mySQL 5.0 does NOT have a
> RENAME DATABASE?
>
> if you have myisam alone tables you can rename the folder of
> the database. That can work
hared table
space. Moving folder cannot work.
Thanks,
Saravanan
--- On Fri, 12/11/09, Michael Dykman wrote:
From: Michael Dykman
Subject: Re: Are you serious? mySQL 5.0 does NOT have a RENAME DATABASE?
To: "MySql"
Date: Friday, December 11, 2009, 10:54 PM
No, not a loophole. J
--- On Fri, 12/11/09, Michael Dykman wrote:
From: Michael Dykman
Subject: Re: Are you serious? mySQL 5.0 does NOT have a RENAME DATABASE?
To: "MySql"
Date: Friday, December 11, 2009, 10:54 PM
No, not a loophole. Just a plain-old management feature.. there is
nothing particularly hack
On Fri, Dec 11, 2009 at 10:40 PM, Daevid Vincent wrote:
> Will this work in 5.0?
>
Yes.
> If I'm reading this right, it seems like this is some kind of trick or
> loophole then right? If it works and solves my dilemna, I'm fine with that,
> but I'm just curious.
>
Not really, this is by desig
; Sent: Friday, December 11, 2009 6:08 AM
>> To: MySql
>> Subject: Re: Are you serious? mySQL 5.0 does NOT have a
>> RENAME DATABASE?
>>
>> If you want to move the database atomically, a RENAME TABLE statement
>> may have multiple clauses.
>>
>> RENA
mv' command where it simply changing pointers or is it a full on
copy/rm? (Assume same filesystem/directory)
> -Original Message-
> From: Michael Dykman [mailto:mdyk...@gmail.com]
> Sent: Friday, December 11, 2009 6:08 AM
> To: MySql
> Subject: Re: Are you serious? mySQ
According to MySQL docs, it should still work atomically. Granted, I
have only used this particular trick when they are on the same
filesystem. Copying across filesystems, I imagine it should still be
atomic, but your system may be locked for awhile.
Obviously, a dedicated RENAME DATABASE comman
Can you use that syntax if the databases are on different file systems? If
you can, and the original table is big, the command would take a while as it
moved data from one file system to another.
On Fri, Dec 11, 2009 at 7:58 AM, Johan De Meersman wrote:
> On Fri, Dec 11, 2009 at 1:56 PM, Ken D'A
If you want to move the database atomically, a RENAME TABLE statement
may have multiple clauses.
RENAME TABLE
olddb.foo to newdb.foo,
olddb.bar to newdb.bar;
Here, I hot-swap a new lookup table 'active.geo' into a live system
confident that, at any given point, some version of this t
On Fri, Dec 11, 2009 at 1:56 PM, Ken D'Ambrosio wrote:
> > rename table oldschema.table to newschema.table;
>
> Just to be 100% clear -- I assume you have to first create the destination
> database, and then do this for all the tables in the source database?
>
Yep. Easily scriptable, though :-)
On Fri, December 11, 2009 7:38 am, Johan De Meersman wrote:
> This only works for MyISAM :-)
Good to know -- thanks!
> However, there's another solution where you don't need to shut down, and
> that works for any engine afaik:
>
> rename table oldschema.table to newschema.table;
Just to be 100%
This only works for MyISAM :-)
However, there's another solution where you don't need to shut down, and
that works for any engine afaik:
rename table oldschema.table to newschema.table;
I agree that it's a silly thing to not have, but I can't say that I've
encountered a whole lot of instances wh
Uhhh... wow. Unless I'm very, very, very mistaken, I think you're missing
something pretty obvious: I believe you can simply
a) shut down the database
b) mv the directory to a different directory name.
*DONE* Your database now has a different name. Boy, that 30 seconds of
hard labor was sure fa
13 matches
Mail list logo