> -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
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 be
>-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"
- 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
t; New York, NY 10013
> 212-625-5307 (Work)
> 201-660-3221 (Cell)
> AIM & Skype : RolandoLogicWorx
> redwa...@logicworks.net
>
> -Original Message-
> From: Matt Neimeyer [mailto:m...@neimeyer.org]
> Sent: Wednesday, August 19, 2009 9:27 AM
> To: Paul DuB
mp; Skype : RolandoLogicWorx
redwa...@logicworks.net
-Original Message-
From: Matt Neimeyer [mailto:m...@neimeyer.org]
Sent: Wednesday, August 19, 2009 9:27 AM
To: Paul DuBois
Cc: mysql@lists.mysql.com
Subject: Re: Renaming a Database
>> That said... Is there anything "wrong" (da
>> That said... Is there anything "wrong" (dangerous, disasterous, etc)
>> with stopping the MySQL service and renaming the folder in the MySQL
>> data folder? By my logic (if I'm right) this should preserve any
>> permissions on the folder and since the service is stopped it should
>> simply find
On Aug 17, 2009, at 4:22 PM, Matt Neimeyer wrote:
I know the "best" way to rename a database is to use mysqldump,
extract the database and then reload to the new database. (At least
based on what I can find in the "12.1.32. RENAME DATABASE Syntax"
section of the documentation)
That said... Is
Hello.
One possible solution is to create a new database, and then RENAME TABLE
each table from the original database into the new database. Then
drop the original database.
"Octavian Rasnita" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Please tell me how to rename a database. I couldn't fin
Octavian
>Please tell me how to rename a database.
As you already found, there are database features that don't survive
renaming its directory. Best method I know is to mysqldump it and
recreate it
from the dump under the desired name.
PB
http://www.artfulsoftware.com
-
Octavian Rasni
A database in MySQL is simply a directory.
So just rename the directory with appropriate tool for your platform.
On my test box this becomes
mysql> show databases;
++
| Database
|
++
| information_schema |
|
lois
Scott Hamm <[EMAIL PROTECTED]> wrote on 07/18/2005 12:01:49 PM:
> How do I rename a database? The help online is pretty ambigous.
>
> --
> Power to people, Linux is here.
I wouldn't say "ambiguous". I would rather say "indirect".
Renaming a database is nearly the same thing as moving tables t
This may already be implemented, but the MySQL Technical Reference for Version 3.23.41
states:
1.6.2 Things that must be done in the real near future:
- Implement RENAME DATABASE. To make this safe for all table handlers, it should work
as follows:
- Create the new database.
- For every tab
At 11:10 -0800 1/30/02, JC wrote:
>-BEGIN PGP SIGNED MESSAGE-
>Hash: SHA1
>
>I'm kind of interested to find if there is a way to rename a database
>with something like the alter command.
>Looking in the index of the New Riders MySQL book I don't see
>anything other than renaming tables
>Lo
Hi!
>> Can you rename a database? If so, how does it handle all the
>> tables inside it?
>
>By shutting down the server, renaming the directory
>of that database and restarting the server.
>
>The server will be able to handle the change just fine.
Sorry, but InnoDB tables do not get renamed
> Can you rename a database? If so, how does it handle all the
> tables inside it?
By shutting down the server, renaming the directory
of that database and restarting the server.
The server will be able to handle the change just fine.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer o
19 matches
Mail list logo
