Database dump and restore command

mysql_dump

backup:
       mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

restore:
       mysql -u root -p[root_password] [database_name] < dumpfilename.sql



Fastest way to restore:

go to mysql i.e., mysql -u root -p password

select the database i.e., use my_database;

then source it,

source /home/revlap/Projects/revlogic_cms/db/revlogic_cms_development_20130501.sql