RE: Renaming a database

[Gordon Bruce]

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          | | mysql              | | test               | +--------------------+ 5 rows in set (0.22 sec)     mysql> show databases; +--------------------+ | Database           | +--------------------+ | information_schema | | lois               | | mailprint          | | 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 database? The help online is pretty ambigous.   -- Power to people, Linux is here.