How do I alias a database in MySQL?

tags:

mysql

views:

288

answers:

+4 Q:

How do I alias a database in MySQL?

I'm looking for a way to alias a database in MySQL. The reason is to be able to rename a live, production database without bringing the system down. I figure I can alias the database to the new name, change and deploy the code connecting to it at my leisure, and eventually remove the old alias.

If there's a better way to accomplish this please let me know.

+3 A:

Symbolic links.

Bill Karwin 2009-08-19 22:51:42

i'd never thought of that! You (well, not *you*, Bill), forget that databases are just files.

nickf 2009-08-19 23:34:54

Thanks! I'd considered that but didn't know if it was safe.

Schwern 2009-08-20 00:09:10

INNODB won't work with filesystem symlinks.

2009-09-18 19:30:13

I haven't tried it to confirm, but it might work if you use InnoDB with the file-per-table option, instead of a shared tablespace.

Bill Karwin 2010-10-05 15:45:02