Question Which of the following is a method to record an event in a MySQL log fi

Question

Question

Which of the following is a method to record an event in a MySQL log file?

a

mysql dump

b

rebooting the host

c

statement-based logging

d

editing my.ini

Question

Which command performs a logical backup of the classicmodelcars database?

a

mysqldump -u root -p > classicmodelcars.sql

b

mysqldump -u root -p < classicmodelcars.sql

c

mysqldump -u root -p >& classicmodelcars.sql

d

mysqldump -u root -p | classicmodelcars.sql

a

mysql dump

b

rebooting the host

c

statement-based logging

d

editing my.ini

Explanation / Answer

Question 1 : Answer : ------------------>>>>>>>>>>>

You can Record a event in any mysql log file by editing the my.ini file

you just need to add a line into the my.ini file as

log = your_file_name.log

and you are done

Question 2 : Answer : ------------------------>>>>>>>>>>>>

answer is a) mysqldump -u root -p > classicmodelcars.sql

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.