Generate the backup of a single database
mysqldump -u root -p sakila > C:\MySQLBackup\sakila_20200424.sql
Code 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.sql
Code language: CSS (css)
Generate the backup of database structure
mysqldump -u root -p --no-data sakila > C:\MySQLBackup\sakila_objects_definition_20200424.sql
Code language: CSS (css)
Generate the backup of a specific table
mysqldump -u root -p sakila actor payment > C:\MySQLBackup\actor_payment_table_20200424.sql
Code language: CSS (css)
I’m a DevOps/SRE/DevSecOps/Cloud Expert passionate about sharing knowledge and experiences. I have worked at Cotocus. I share tech blog at DevOps School, travel stories at Holiday Landmark, stock market tips at Stocks Mantra, health and fitness guidance at My Medic Plus, product reviews at TrueReviewNow , and SEO strategies at Wizbrand.
Do you want to learn Quantum Computing?
Please find my social handles as below;
Rajesh Kumar Personal Website
Rajesh Kumar at YOUTUBE
Rajesh Kumar at INSTAGRAM
Rajesh Kumar at X
Rajesh Kumar at FACEBOOK
Rajesh Kumar at LINKEDIN
Rajesh Kumar at WIZBRAND