How to create a copy of the database in MySQL in command line?

You can create a copy of mysql database using mysqldump command line.

mysqldump -h mysqlhost -u username -p mydatabasename > dbdump.sql