> -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
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
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
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 there anything "wrong" (dangerous, disasterous, etc)
w
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
Hi,
Please tell me how to rename a database. I couldn't find this in the manual.
I have tried to rename manually the name of the directory that holds that
database, but some tables can't be accessed after that. (I have found that
they are InnoDB tables, even though I never specified that I want th
lprint |
|
mysql
|
|
test1
|
++
5 rows in set (0.00 sec)
-Original Message-
From: Scott Hamm [mailto:[EMAIL PROTECTED]
Sent: Monday, July 18, 2005 11:02 AM
To: 'Mysql '
Subject: Renaming a database
How do I rename a da
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 databas
How do I rename a database? The help online is pretty ambigous.
--
Power to people, Linux is here.
At 11:16 -0500 10/7/04, gerald_clark wrote:
Carolina wrote:
using mysql version 4.0.13
- **total newbie here**... something as simple as renaming a
database...i've not found anything relating to that on the mysql site
or anywhere else. what i have found is that in order to do this, i'
Carolina wrote:
using mysql version 4.0.13
- **total newbie here**... something as simple as renaming a
database...i've not found anything relating to that on the mysql site
or anywhere else. what i have found is that in order to do this, i'd
have to shutdown and restart the mysql d
using mysql version 4.0.13
- **total newbie here**... something as simple as renaming a
database...i've not found anything relating to that on the mysql site
or anywhere else. what i have found is that in order to do this, i'd
have to shutdown and restart the mysql database in o
What would I do if there are InnoDB tables ?
--
Dimitry
Wednesday, January 30, 2002, 9:31:09 PM, Paul DuBois wrote:
> 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
system.
# Nathan
- Original Message -
From: "JC" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 30, 2002 12:10 PM
Subject: renaming a database
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I'm kind of interested to find if there is a wa
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
-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
Looking through the Manual for version 3
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
Can you rename a database? If so, how does it handle all the tables inside it?
Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Hi!
I'm running MySQL on Win NT 4. I'm trying to rename a database from my
(Delphi) program, but I haven't found any inforamtion about this on the
MySQL site. Can anybody help me?
P.S.: Can a database named 2001 be created?
regards,
m@rko
-
30 matches
Mail list logo