how to change the name(and the data dir) of a database?

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=gcdmg-mysql-2@m.gmane.org

Re: how to change the name(and the data dir) of a database?

--001636d33fb0f2a30d047e391ab1
Content-Type: text/plain; charset=ISO-8859-1

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 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=vegivamp@tuxera.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

--001636d33fb0f2a30d047e391ab1--