mysqldump Backup Command

What is mysqldump?

Common Commands

# whole database
mysqldump -u root -p school > school.sql

# one table only
mysqldump -u root -p school students > students.sql

# all databases
mysqldump -u root -p --all-databases > all.sql

Summary

• mysqldump exports databases/tables to .sql files.
• Use it for backups and moving data between servers.

mysqldump क्या है?

Common Commands

# पूरा database
mysqldump -u root -p school > school.sql

# सिर्फ एक table
mysqldump -u root -p school students > students.sql

# सारे databases
mysqldump -u root -p --all-databases > all.sql

सारांश

• mysqldump databases/tables को .sql files में export करता है।
• Backups और servers के बीच data move करने के लिए use करें।