Shell ~ Work with mysql backups

backup

# Making a new backup
mysqldump database_name > database_name.sql
mysqldump --databases database_one database_two > two_databases.sql
mysqldump --all-databases > all_databases.sql

# Restoring from a backup
mysql database_name < database_name.sql
mysql --one-database database_name < all_databases.sql

# Working with tables
mysqldump database_name table_name > table_name.sql
mysql database_name < table_name.sql