Question

Which command backs up the single database called 'websites' to the file 'websites_backup.sql'?

(a) mysql --backup websites -u root -p > websites_backup.sql

(b) mysql --backup --single-database websites -u root -p > websites_backup.sql

(c) mysql --backup websites -u root -p --out-file websites_backup.sql

(d) mysqldump websites -u root -p > websites_backup.sql

(e) mysqldump --single-database websites -u root -p > websites_backup.sql

Answer 1

Answer:

(d) mysqldump websites -u root -p > websites_backup.sql

Explanation:

To create a backup mysqldump is used.It is a data backup program.This program was originally written by Igor Romanenko. It creates a backup of file name websites_backup.sql.

So among the given options in the question option d is the correct option which backs up the single database websites in the file website_backup.sql.