For MyISAM that's not a problem (with some caveats if you wanna do it
online). For InnoDB you can't do that, but you can create a new database,
and rename from olddb.table to newdb.table.
On Thu, Jan 28, 2010 at 10:34 AM, Cui Shijun <rancpine@stripped> wrote:
> hi,
> Is there an easier way to change the name of a database other than
> mysqldump?
> Can I physically move the database to another directory?( I've tried
> and it works, at least it seems like it works)
> Thank you.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
