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

Question

Mylee Dorsey

Computers & Technology

15 July, 14:51

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

+1

Answers (1)

Know the Answer?

Shyla Larson · Answer 1

(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.