mysqldump usage - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is mysqldump used for?

mysqldump is a tool to create a backup of MySQL databases by exporting their structure and data into a file.

beginner

How do you dump a single database named shop using mysqldump?

Use the command: mysqldump -u username -p shop > shop_backup.sql. This exports the shop database to a file.

beginner

What does the -u and -p option mean in mysqldump?

-u specifies the MySQL username. -p tells the tool to prompt for the password.

intermediate

How can you dump all databases at once using mysqldump?

Use mysqldump -u username -p --all-databases > all_backup.sql to export every database on the server.

beginner

What is the purpose of redirecting output with > in mysqldump commands?

The > symbol sends the dump output to a file instead of showing it on the screen, saving the backup for later use.

Which command backs up a single database named library?

A mysqldump -u user -p --tables library > backup.sql

B mysqldump -u user -p library > library_backup.sql

C mysqldump -u user -p --databases library books > backup.sql

D mysqldump -u user -p --all-databases > library_backup.sql

Option B correctly dumps the single database library to a file.

What does the --all-databases option do?

A Backs up all databases on the server

B Backs up only the current database

C Backs up only tables with data

D Backs up only the database structure

--all-databases exports every database on the MySQL server.

Why do you use -p with mysqldump?

A To prompt for the password

B To specify the port number

C To print the dump on screen

D To pause the dump process

-p makes mysqldump ask for the password securely.

What does the symbol > do in mysqldump commands?

A Runs the command in the background

B Appends output to an existing file

C Redirects output to a file

D Deletes the output file

> sends the output to a file instead of the screen.

Which of these commands is correct to dump multiple specific databases?

A mysqldump -u user -p --tables db1 db2 > multi_backup.sql

B mysqldump -u user -p --all-databases db1 db2 > multi_backup.sql

C mysqldump -u user -p db1 db2 > multi_backup.sql

D mysqldump -u user -p --databases db1 db2 > multi_backup.sql

Option D uses --databases to dump multiple named databases.

Explain how to use mysqldump to back up a single database and save it to a file.

Think about the command structure and how to save output.

Describe the difference between dumping a single database and dumping all databases with mysqldump.

Consider the options and what they export.