How to Create a File Dump from a MySQL Database

Create the Dump File:

mysqldump --user=<user> --password=<password> <database> --result-file=<file.sql>

Load the Dump File:

myql --user=<user> --password=<password>
use <database>
source <file.sql>

Create a Dump With Only CREATE Commands:

To create a dump in MySQL without the DROP commands or any other extra command, use this syntax:

mysqldump -u user -p --skip-opt database > dump.sql

External References:

http://www.howtoforge.com/back_up_mysql_dbs_without_interruptions (This is a script I have been using myself, also note down that site IF you are not familiar with it and care about linux).