mysql backup and restoring databases

mysql dump
from database to file:

$cmd:mysqldump -u username -p databasename > filename.sql

it will ask for password

from file to database:

$cmd:mysql - u username -p databasename < filename.sql



More detailed backup:

Tacking full backup of all the tables and data also:

$cmd:mysqldump -u username -p databasename > filename.sql

Taking the backup of table structures only:

$cmd:mysqldump -u username -p --no-data databasename > filename.sql

Taking the backup data only:

$cmd:mysqldump -u username -p --no-create-info databasename > filename.sql

But the restoring is same for any of these backup methods