On Thu, Mar 6, 2008 at 10:20 AM, Andre Hübner <[EMAIL PROTECTED]> wrote:
> Hi List,
>
> user wants to do:
>
> SELECT COUNT(*) FROM mysql.time_zone_name;
>
> problem ist that this table in mysql is empty. I dont know how to fill with
> data. I tried on testmachine with mysql_install_db but it leaves empty.
> Where to get sql-data to fill these tables in mysql-db?
You'll have to have MySQL root access, or an account with access
to write to the database `mysql` for this, but this should help you.
1.) Type mysql_tzinfo_to_sql /usr/share/lib/zoneinfo |
/usr/local/mysql/bin/mysql -p -u root mysql
2.) A bunch of errors may appear, but you can ignore them.
3.) Run "SELECT COUNT(*) FROM mysql.time_zone_name;" again. You
should have more than 500 rows now.
--
</Dan>
Daniel P. Brown
Senior Unix Geek
<? while(1) { $me = $mind--; sleep(86400); } ?>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
