How to rename a database...?
| User, date | Message |
|---|---|
|
Written by westmatrix
5 years ago Category: General 82 posts since Wed, 11 Apr 07 |
I can rename databases in PHPMyAdmin, Navicat and other MySQL apps, but not in HeidiSQL, I have searched but can't find how to rename a database using Heidi. Is it a command line that I run in the Query window? wrote: RENAME {DATABASE | SCHEMA} db_name TO new_db_name; Is this the only way? Cheers |
|
Written by ansgar
5 years ago 3958 posts since Fri, 07 Apr 06 |
If the server supports it, you have a menu item available when rightclicking in the DB tree: "Alter database". There you can rename and change characterset and collation: Renaming is supported since MySQL 5.1.7 . |
|
Written by westmatrix
5 years ago 82 posts since Wed, 11 Apr 07 |
I have version 5.0.45 Will have to upgrade as mine is grayed out for renaming the phyisical database. Cool thanks. Cheers |
|
Please login to leave a reply, or register at first. |