Re: [tlug] Duplicating a MySQL database

[Batara Kesuma <bkesuma@example.com>]

On Wed, 07 Aug 2002 18:59:47 +0900
"Jonathan Q" <jq@example.com> wrote:

> 
> I have a MySQL database that I would like to make an exact duplicate of
> for testing purposes.  According to the MySQL manual, it seems that I
> could use mysqldump and mysqlimport for this purpose, but that seems
> somehow inelegant.  Does anyone know of a better way to do this that I
> haven't stumbled across yet?  

Just lock the table, and copy all the files under:
/var/lib/mysql/database_name

Or you can use mysqlhotcopy to do it for you automatically.
http://www.mysql.com/doc/en/mysqlhotcopy.html

--bk