Re: How to rename database name

2006-12-08 Thread Dominik Klein 
1.  'mysqldump' the current database, drop it and create a new database. 
Move the dumped data into the new database.


This should work with any engine.

2.  Stop mysqld.  Rename the database folder in the datadirectory. Start 
the server and grant access permissions


This does imho only work for myisam databases. It does definetly not 
work for innodb databases. I do not work with other engines so I dont 
know about them.


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

Re: How to rename database name

2006-12-08 Thread Visolve DB Team 

Hi

Simply go with either of these:

1.  'mysqldump' the current database, drop it and create a new database. 
Move the dumped data into the new database.

or
2.  Stop mysqld.  Rename the database folder in the datadirectory. Start the 
server and grant access permissions



Thanks
ViSolve DB Team.
- Original Message - 
From: "jagdish gunjal" <[EMAIL PROTECTED]>

To: 
Sent: Friday, December 08, 2006 10:25 AM
Subject: How to rename database name



Hi all,

 Does any know command to rename the database name in Mysql db.




-
Find out what India is talking about on  - Yahoo! Answers India
Send FREE SMS to your friend's mobile from Yahoo! Messenger Version 8. Get 
it NOW 



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

How to rename database name

2006-12-07 Thread jagdish gunjal 
Hi all,
   
  Does any know command to rename the database name in Mysql db.
   
   


-
 Find out what India is talking about on  - Yahoo! Answers India 
 Send FREE SMS to your friend's mobile from Yahoo! Messenger Version 8. Get it 
NOW