How to Restore a MySQL database

The most common and basic way to restore, is a restore of a database.

# mysql -u username –password=password DB < DB.sql

Restoring your database to another database over the network

# mysqldump -u username –password=password DB | mysql –host=192.168.0.23 -C DB