mysql backup and restore

1. backup database tables (user as root)
shell> mysqldump -p123456 database_name table_name > table_name_dump.sql

2. restore the backup files (user as root)
shell> mysql -p123456 database_name < table_name_dump.sql