Dump / restore different server, different database

Hi.

I've been trying to figure out what's the best (quick, compact etc.) way to dump database (tables, indexes, data) and import it to a different database which has the same table structure but different name, size, users etc?

I managed to do it this way:

1. Do a catalog extract to a file.
2. Do a CSV dump of all the tables (pain in the ass if there is hundreds of tables...DATAEXTRACT * FROM MYTABLE1 OUTFILE...)
3. Create new database
4. Rename database in catalog dump file if needed (new database name)
5. Do a catalogload to import table structure and indexes.
6. Do data load on all the CSV data files (again, pain in the as if there's many tables).


I bet there's an easier way?