Generate the backup of a single database

mysqldump -u root -p sakila > C:\MySQLBackup\sakila_20200424.sql

Generate the backup of multiple databases or all the databases

mysqldump -u root -p --databases sakila employees > C:\MySQLBackup\sakila_employees_20200424.sql

Generate the backup of database structure

mysqldump -u root -p --no-data sakila > C:\MySQLBackup\sakila_objects_definition_20200424.sql

Generate the backup of a specific table

mysqldump -u root -p sakila actor payment > C:\MySQLBackup\actor_payment_table_20200424.sql

• Author
• Recent Posts

Follow me

Rajesh Kumar

DevOps - DevSecOps - SRE Coach at Rent Bikes and Cars Now using MOTOSHARE

Join my following certification courses...
- DevOps Certified Professionals (DCP)
- Site Reliability Engineering Certified Professionals (SRECP)
- Master in DevOps Engineering (MDE)
- DevSecOps Certified Professionals (DSOCP)
URL - https://www.devopsschool.com/certification/

My Linkedin - https://www.linkedin.com/in/rajeshkumarin

Follow me

Latest posts by Rajesh Kumar (see all)

• Atlassian Jira Demo - January 4, 2025
• Revolutionizing Business Management with Microsoft Business Central - January 4, 2025
• Key Benefits of Converting HTML to PDF File Format - January 2, 2025