Jesse,
>I need to rename a database. I read somewhere that I could simply stop the
>MySQL database server and rename the folder that contains the data,
re-start
>MySQL, and I'm good-to-go. However, I tried this, and while it appears to
>have worked initially, when I try to
I need to rename a database. I read somewhere that I could simply stop the
MySQL database server and rename the folder that contains the data, re-start
MySQL, and I'm good-to-go. However, I tried this, and while it appears to
have worked initially, when I try to access one of the tables i
Ok so I'm using Win98, and with this all I do to rename a database is go
into the MySQL folder then into Data folder and there you have all your
databases in their own folders, and then to change the database name just
change the folders name. It works for me. I have no idea how it'
ALTER TABLE Customers RENAME Customer_Table;
-Original Message-
From: TOMASSONI Dominique [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 23, 2001 7:48 PM
To: 'MySQL_mailing_list'
Subject: Rename a database
Hello the list,
Is it possible to change the name of a database ?
mysql
|
| [EMAIL PROTECTED] wrote:
|
| > I searched the archives and the manual online but could not find the
| > answer,
| > I believe this has been covered in the list though. Is it possible to
| > rename a
| > database? If not, is it possible to move/copy a table from a database to a
stop mysql
cd /var/lib/mysql
mv olddbname newdbname
start mysql
[EMAIL PROTECTED] wrote:
> I searched the archives and the manual online but could not find the
> answer,
> I believe this has been covered in the list though. Is it possible to
> rename a
> database? If not, is it p
I searched the archives and the manual online but could not find the
answer,
I believe this has been covered in the list though. Is it possible to
rename a
database? If not, is it possible to move/copy a table from a database to a
new
database? Could someone point me to the details on this