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 ? And if it i
This method will cause problems if you have entries in
you mysql.db table for that database.
Just make sure you correct your permissions.
On Fri, 16 Nov 2001 11:46:31 -0500, Danny Rathjens
<[EMAIL PROTECTED]> wrote:
| stop mysql
| cd /var/lib/mysql
| mv olddbname newdbname
| start mysql
|
| [
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 possible to move/