mysqldump

Create the target database (and, optionally, empty it) before running the following command...

mysqldump -u root --password=password -h'127.0.0.1' sourcedatabase | mysql -u root -p password targetdatabase

Bibliography