Cloning a database

[cwfie]

Dear Members,

I have a database which I want to clone under another name just for testing purposes.

For example: all .sql data from testuser_testdb needs to be transfered to testuser_testdb2

I tried mysqldump, but it seems to do nothing. I think (after searching the web) that it is because my database is too large (650 MB).

Does anyone know another solution than mysqldump? I didn't find anything so far.

I appreciate your help.

Best regards,
Steven

 

[smtalk]

Create a user and do:

cp -Rp /var/lib/mysql/testuser_testdb /var/lib/mysql/testuser_testdb2

 

[rohit]

also could be that the all the DB's for MySql are under

/var/lib/mysql/DB_NAMEs(s)

 

[cwfie]

Thank you very much guys. Didn't know it could be done this easily.

Actually it was /home/mysql (debian)