Re: Rename/Create Database from Existing Database

2003-06-14 Thread Victoria Reznichenko 
Wong Zach-CHZ013 [EMAIL PROTECTED] wrote:
 1- Is there a command to rename an existing database ?

Nope.

 2- If not, how does one create a new database from an existing database ?
 could you show me the steps?

If your database doesn't have InnoDB table you can take down MySQL server, rename 
database directory and start the server.

You can also make dump of the database and then rectore tables to another database.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Rename/Create Database from Existing Database

2003-06-13 Thread Wong Zach-CHZ013 
Hi
1- Is there a command to rename an existing database ?
2- If not, how does one create a new database from an existing database ?
could you show me the steps?

Any help is appreciated.
Thanks

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Rename/Create Database from Existing Database

2003-06-13 Thread V. M. Brasseur 
Wong Zach-CHZ013 wrote:
 
 Hi
 1- Is there a command to rename an existing database ?
 2- If not, how does one create a new database from an existing database ?
 could you show me the steps?
 
 Any help is appreciated.
 Thanks

Have you tried the mysqlhotcopy util?

http://www.mysql.com/doc/en/mysqlhotcopy.html

--V

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]