MySQL Database export & import

Database backup

database export

mysqldump -u id -p password database > database.sql

database import

mysql -u id -p password database < database.sql

before you import the database, login into mysql and create an empty schema so that you can import from the exported database.