distal-attribute
distal-attribute
distal-attribute
distal-attribute

How to rename a database...?

User, date Message
Written by westmatrix
7 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
7 years ago
5012 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
7 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.