Generate the backup of a single database

mysqldump -u root -p sakila > C:\MySQLBackup\sakila_20200424.sqlCode language: CSS (css)

Generate the backup of multiple databases or all the databases

mysqldump -u root -p --databases sakila employees > C:\MySQLBackup\sakila_employees_20200424.sqlCode language: CSS (css)

Generate the backup of database structure

mysqldump -u root -p --no-data sakila > C:\MySQLBackup\sakila_objects_definition_20200424.sqlCode language: CSS (css)

Generate the backup of a specific table

mysqldump -u root -p sakila actor payment > C:\MySQLBackup\actor_payment_table_20200424.sqlCode language: CSS (css)

Rajesh Kumar

I’m Rajesh Kumar, a DevOps, SRE, DevSecOps, Cloud, and Platform Engineering expert passionate about sharing practical knowledge, real-world experiences, and industry best practices. I have worked at Cotocus and regularly write about technology, travel, investing, health, product reviews, and digital marketing through my various platforms.

I publish technical articles at DevOps School, travel stories at Holiday Landmark, stock market insights at Stocks Mantra, health and fitness guidance at My Medic Plus, product reviews at TrueReviewNow, and SEO and digital marketing strategies at Wizbrand.