Backup and recovery in MySQL     1 Up

MySQL is packed with many of utilities which simplifies the back-up and recovey.
BACK-UP:
The Utility used for Back-up any of database in mysql is ---'mysqldump'.We can make back-up even for single table
The following command is used for back-up:
> mysqldump -u [username] -p -h [hostname] [database-name (or) database-name.table-name] > [backup-file].sql

eg: > mysqldump -u root -p -h localhost db1.ta1 > db1.sql

RECOVERY:

The following command is used for Recovery:
> mysql -u [username] -p -h [hostname] [database-name (or) database-name.table-name] < [backup-file].sql

eg: > mysql -u root -p -h localhost db1.ta1 < db1.sql

Pictures and Videos
Online Calculators