From: Johan De Meersman Date: January 28 2010 1:00pm Subject: Re: how to change the name(and the data dir) of a database? List-Archive: http://lists.mysql.com/mysql/220429 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=001636d33fb0f2a30d047e391ab1 --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@stripped > > -- 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--