MySQL DB Backup and Restore

1. DB Backup, Table Backup

mysqldump -u -p database_name > /var/backup/database_name.sql

mysqldump -u -p database_name table_name > /var/backup/table_name.sql

2. DB Restore, Table Restore

mysql -u -p database_name < /var/backup/database_name.sql
mysql -u -p database_name < /var/backup/table_name.sql