Rename mysql database

pk21 · 06-09-2004, 08:16 AM

Hi all!

I've got a mysql database that has to be renamed. So right now it is called 'example' and i want to rename it to 'examp'.
How can i rename the database???

Mega Man X · 06-09-2004, 08:42 AM

I think you could rename it directly from the source. In Mandrake, the databases we create with mysql are stored at /var/lib/mysql, so you database should be at "/var/lib/mysql/example", simply move it :

Code:

mv /var/lib/mysql/example /var/lib/mysql/examp

Regards!

pk21 · 06-09-2004, 09:38 AM

and afther i've renamed it that way i can just change the users and db table to set everything oke?

Mega Man X · 06-09-2004, 10:31 AM

hmmmm, I guess so. though, if you are going to add/remove tables, then it's better to do the sql way. Rename the database as I described above, then run mysql:

Code:

mysql> use examp

to change into your database. The rest is pure sql as usual. I'd also recommend Webmin to administrate your database

pk21 · 06-11-2004, 06:54 AM

I have a couple of databases, but how do i lock that specific database? Or dont i need to lock it?
(the database is about 5Mb)