List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:January 28 2010 1:00pm
Subject:Re: how to change the name(and the data dir) of a database?
View as plain text  
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

Thread
how to change the name(and the data dir) of a database?Cui Shijun28 Jan
  • Re: how to change the name(and the data dir) of a database?Johan De Meersman28 Jan