zenichanin wrote:So I don't know if it inserted it into Mac's default MySQL database?
Of course not, this tool does not know anything about your databases und users, it is a plain generator. Redirect the output to a file, for example to /tmp/zoneinfo.sql:
- Code: Select all
./mysql_tzinfo_to_sql /usr/share/zoneinfo >/tmp/zoneinfo.sql
This creates zoneinfo.sql in folder /tmp. You may choose any folder and any name. After execution the file contains the appropriate SQL commands to insert the data into a database. But this is not yet included in your database. I dont know the purpose of that tool and i dont know where you need these tables, but you might run PhpMyAdmin, create or open the database of your choice and run an import of the zoneinfo-file created above.