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 <rancp...@gmail.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=vegiv...@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
