MySQL dump

Taking mysql dump

# mysqldump -u user -ppassword DB_name --ignore-table=DB_name.table_name1 --ignore-table=DB_name.table_name1 > DB_dump.sql

Restoring from the dump

# mysql -uroot -proot DB_name < DB_dump.sql