Mysqldump

• To take backup of whole mysql

[root@akwal ~]# mysqldump -A -R -u root -p > db_dump_name.sql

• To take backup of  one database

[root@akwal ~]# mysqldump -u root -p db_name > db_name.sql

• To take backup of  one table of a database

[root@akwal ~]# mysqldump -u root -p db_name table_name > abcd.sql

• To take backup of  multiple tables of a database

[root@akwal ~]# mysqldump -u root -p db_name table1  table2 > abcd.sql

• To take compress backup of one database mysql 

[root@akwal ~]# mysqldump -u root -p abcd | gzip -9 > abcd.sql.gz

• To Extract

if your data is in .gz form, then extract via this command
[root@akwal ~]# gunzip abcd.sql.gz

• To create a database

[root@akwal ~]# mysql -u root -p ↵

mysql> create database abcd;   (abcd is the database name)

• To Extract

if your data is in .gz form, then extract via this command
[root@akwal ~]# gzip -d abcd_2013-02-11_00h00m.Monday.sql.gz 

• To restore

[root@akwal asdf]# mysql -u root -p -D abcd < abcd_2013-02-11_00h00m.Monday.sql

• To Select the DATABASE

mysql> use abcd;

• To check Process

mysql> show processlist;