1Z0-873 · Question #67
Which of the following best describe what the mysql_tzinfo_to_sql script is needed for and how to use it?
The correct answer is A. The script is used to convert Unix-type timezone files into SQL statements that can be loaded. C. shell> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql. On operating systems that have their own time zone files, it is best to use them for loading the MySQL time zone tables, to ensure that the system and MySQL time zones are based on the same information. Many Unix systems have these files, often located under…
Question
Which of the following best describe what the mysql_tzinfo_to_sql script is needed for and how to use it?
Options
- AThe script is used to convert Unix-type timezone files into SQL statements that can be loaded.
- BThe script is used to insert timezone files into MySQL.
- Cshell> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
- Dshell> /usr/share/zoneinfo mysql_tzinfo_to_sql | mysql -u root mysql
How the community answered
(43 responses)- A79% (34)
- B14% (6)
- D7% (3)
Explanation
On operating systems that have their own time zone files, it is best to use them for loading the MySQL time zone tables, to ensure that the system and MySQL time zones are based on the same information. Many Unix systems have these files, often located under /usr/share/zoneinfo. For such systems, use the mysql_tzinfo_to_sql program to convert the file contents into SQL statements that can be loaded into MySQL by the mysql program. If the files are located at /usr/share/zoneinfo, the command looks like this: shell> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
Topics
Community Discussion
No community discussion yet for this question.