In order to use SELECT INTO OUTFILE backups, the output file

The correct answer is A. must be created afresh; can be viewed by the world; and will reside on the server. Use of INTO OUTFILE changes the operation of the SELECT statement in several ways: Any file created by INTO OUTFILE or INTO DUMPFILE is writable by all users on the server host. The reason for this is that the MySQL server cannot create a file that is owned by anyone other than…

MySQL Backup and Recovery

Question

Options

Amust be created afresh; can be viewed by the world; and will reside on the server
Bneed not be created afresh; can be viewed by the world; and will reside on the server
Cmust be created afresh; can not be viewed by the world; and will reside on the client or the server
Dneed not be created afresh; can not be viewed by the world; and will reside on the server

How the community answered

(18 responses)

A
83% (15)
C
11% (2)
D
6% (1)

Explanation

Use of INTO OUTFILE changes the operation of the SELECT statement in several ways: Any file created by INTO OUTFILE or INTO DUMPFILE is writable by all users on the server host. The reason for this is that the MySQL server cannot create a file that is owned by anyone other than the user under whose account it is running. (You should never run mysqld as root for this and other reasons.) The file thus must be world-writable so that you can manipulate its contents.

Topics

#SELECT INTO OUTFILE#file permissions#server-side file#logical backup

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice