OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: how to change the name(and the data dir) of a database?

From: Johan De Meersman (vegivamptuxera.be)
Date: Thu Jan 28 2010 - 07:00:37 CST

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 <rancpinegmail.com> 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=vegivamptuxera.be
>
>

--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel