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 je...@gii.co.jp wrote:
It looks like there’s no way to rename a database. Is that true?
I have two
- Original Message -
From: Jerry Schwartz je...@gii.co.jp
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
-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 je...@gii.co.jp
It looks like there's no way
-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
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 je...@gii.co.jp 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
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
-Original Message-
On Tue, May 24, 2011 at 4:19 PM, Jerry Schwartz je...@gii.co.jp 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
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 the new
: 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 (dangerous, disasterous, etc
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 (dangerous
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
Octavian Rasnita wrote:
Is there a command for renaming a MySQL database?
Sorry, there is no command for that. For small databases you can use
administration tools like phpMyAdmin, etc. which will do it for you by
duplicating the database structure and data, and then drop the 'old'
PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Monday, October 17, 2005 12:11 PM
Subject: Re: renaming the database
Octavian Rasnita wrote:
Is there a command for renaming a MySQL database?
Sorry, there is no command for that. For small databases you can use
administration tools like phpMyAdmin, etc
, 2005 12:11 PM
Subject: Re: renaming the database
Octavian Rasnita wrote:
Is there a command for renaming a MySQL database?
Sorry, there is no command for that. For small databases you can use
administration tools like phpMyAdmin, etc. which will do it for you by
duplicating the database
C.R. Vegelin wrote:
What about renaming the folder indicating the database name.
I work with Windows XP and renaming a folder works well.
Cor,
Have you tried it with InnoDB tables or anything other than MyISAM
tables? InnoDB uses a single tablespace per server (unless specified
that it
I think you can just rename the directory that that database lives in.
If you read the documentation for CREATE DATABASE in dev.mysql.com,
you'll see they discuss renaming the directory (although it does not
directly say this can be done to rename the database, but it comes
really close to
Robert L Cochran [EMAIL PROTECTED] wrote on 10/17/2005 07:37:26 AM:
I think you can just rename the directory that that database lives in.
If you read the documentation for CREATE DATABASE in dev.mysql.com,
you'll see they discuss renaming the directory (although it does not
directly say
And, of course, you need to grant permissions for the new database name.
Bob
[EMAIL PROTECTED] wrote:
Robert L Cochran [EMAIL PROTECTED] wrote on 10/17/2005 07:37:26 AM:
I think you can just rename the directory that that database lives in.
If you read the documentation for CREATE
Robert L Cochran [EMAIL PROTECTED] wrote on 10/17/2005 11:00:33 AM:
And, of course, you need to grant permissions for the new database name.
Bob
[EMAIL PROTECTED] wrote:
Robert L Cochran [EMAIL PROTECTED] wrote on 10/17/2005 07:37:26
AM:
I think you can just rename the
Hello.
This is a frequently asked question. See:
http://lists.mysql.com/mysql/188094
For more solutions search in the archives at:
http://lists.mysql.com
Octavian Rasnita wrote:
Hi,
Is there a command for renaming a MySQL database?
Thank you.
Teddy
Shawn wrote
I have a 2.1GB database with all InnoDB tables in it that I wanted
to
change the name of. It took me longer to write my RENAME TABLE
script than it did to actually move the data.
It's easier less error-prone to do it in an sproc which prepares
executes the rename cmds. Only
Errm, needed to take the grants table updates out of the repat loop:
CREATE PROCEDURE RenameDatabase (IN oldname CHAR(64), IN newname CHAR(64))
BEGIN
DECLARE sname CHAR(64) DEFAULT NULL;
DECLARE rows INT DEFAULT 1;
DECLARE total INT DEFAULT 0;
CREATE DATABASE IF NOT EXISTS newname;
REPEAT
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 find this
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
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 to a new
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
|
| mailprint |
|
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
Looking
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
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 inside
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 of
30 matches
Mail list logo
