Re: off-topic unsubscribe concern

2007-07-06 Thread B. Keith Murphy
I have been having the same problems. Have no idea what is up. - Original Message - From: "Michael Dykman" <[EMAIL PROTECTED]> To: "MySQL General" Sent: Friday, July 6, 2007 11:55:41 AM (GMT-0500) America/New_York Subject: off-topic unsubscribe concern Hi everyone. I have been o

RE: zipcode to timezone

2007-07-06 Thread John Trammell
> -Original Message- > From: Hiep Nguyen [mailto:[EMAIL PROTECTED] > Sent: Friday, July 06, 2007 12:15 PM > To: Dirk Bremer > Cc: David T. Ashley; mysql@lists.mysql.com > Subject: RE: zipcode to timezone > > now, why do they do this??? it doesn't make any sense at all to have > multiple tim

Re: NFS database

2007-07-06 Thread Douglas Araujo
Thanks for the help Michael, The data directory is really configured to /var/lib/mysql, and the database name is area2. I'm mounting the subdirectory of the database. When I mount the nfs file system I don't get any error. Thanks, Douglas 2007/7/6, Michael Dykman <[EMAIL PROTECTED]>: Let me

RE: zipcode to timezone

2007-07-06 Thread Hiep Nguyen
On Fri, 6 Jul 2007, Dirk Bremer wrote: Indiana has two time zones as I recall. The state is divided roughly in half between the two. Dirk Bremer - Senior Systems Engineer - Utility - AMS - NISC Lake St. Louis MO - USA Central Time Zone 636-755-2652 fax 636-755-2502 [EMAIL PROTECTED] www.nisc.co

RE: zipcode to timezone

2007-07-06 Thread Dirk Bremer
Indiana has two time zones as I recall. The state is divided roughly in half between the two. Dirk Bremer - Senior Systems Engineer - Utility - AMS - NISC Lake St. Louis MO - USA Central Time Zone 636-755-2652 fax 636-755-2502 [EMAIL PROTECTED] www.nisc.coop -Original Message- From: Hiep

Re: zipcode to timezone

2007-07-06 Thread David T. Ashley
On 7/6/07, John Trammell <[EMAIL PROTECTED]> wrote: > -Original Message- > From: Hiep Nguyen [mailto:[EMAIL PROTECTED] > Sent: Friday, July 06, 2007 10:51 AM > To: David T. Ashley > Cc: mysql@lists.mysql.com > Subject: Re: zipcode to timezone > > i don't think there is any state got 2 ti

RE: zipcode to timezone

2007-07-06 Thread John Trammell
> -Original Message- > From: Hiep Nguyen [mailto:[EMAIL PROTECTED] > Sent: Friday, July 06, 2007 10:51 AM > To: David T. Ashley > Cc: mysql@lists.mysql.com > Subject: Re: zipcode to timezone > > i don't think there is any state got 2 timezones, i could be wrong. Yeah, you are. http://worl

Re: Import a text file

2007-07-06 Thread Michael Dykman
Your first instinct is correct, a parsing script in the language of your choice would make short work of this. - michael On 7/6/07, Scott Swaim <[EMAIL PROTECTED]> wrote: I have a text file that is in the Panasonic DBS format. It is a log file that comes from my phone system. I have a progra

RE: off-topic unsubscribe concern

2007-07-06 Thread Jerry Schwartz
I'm getting them also, I ignore them. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com > -Original Message- > From: Michael Dy

RE: zipcode to timezone

2007-07-06 Thread Jerry Schwartz
I think Indiana has two time zones. I think there are also some states or portions thereof that don't observe daylight saving time. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.

Re: NFS database

2007-07-06 Thread Michael Dykman
Let me see if I follow this: your configured data directory is datadir = /var/lib/mysql and the database you are trying to browse is names 'area2'. Is this correct? Is the entire datadir mounted on the external host? Or have you just tried to mount the database/subdirectory? If the former, ev

Import a text file

2007-07-06 Thread Scott Swaim
I have a text file that is in the Panasonic DBS format. It is a log file that comes from my phone system. I have a program that monitors the serial port and write the input to a file. I have no control over the format of the file. I would like to on a nightly basis shut down the logging program

off-topic unsubscribe concern

2007-07-06 Thread Michael Dykman
Hi everyone. I have been on this list for a pretty long time but in the last few months I have started to receive random 'confirm unsubscribe' messages..They always seem to originate from a Roadrunner IP (I have not thoroughly tested that hypothesis). I have no accounts on or near roadrunner

Re: zipcode to timezone

2007-07-06 Thread Hiep Nguyen
On Fri, 6 Jul 2007, David T. Ashley wrote: On 7/6/07, Hiep Nguyen <[EMAIL PROTECTED]> wrote: we have warehouses all over U.S. and i just wonder what is the best way to find out their timezone base on zipcode. Should i buy a database or is there any function in mysql or php to get timezone bas

Re: zipcode to timezone

2007-07-06 Thread Baron Schwartz
Hiep Nguyen wrote: Hi there, we have warehouses all over U.S. and i just wonder what is the best way to find out their timezone base on zipcode. Should i buy a database or is there any function in mysql or php to get timezone base on a zipcode? You may be able to call a web service from you

Re: zipcode to timezone

2007-07-06 Thread David T. Ashley
On 7/6/07, Hiep Nguyen <[EMAIL PROTECTED]> wrote: we have warehouses all over U.S. and i just wonder what is the best way to find out their timezone base on zipcode. Should i buy a database or is there any function in mysql or php to get timezone base on a zipcode? I looked at the zipcode da

Re: NFS database

2007-07-06 Thread Douglas Araujo
The results: $ ls -ld /var/lib/mysql/area2/ drwxr-xr-x 2 mysql mysql 8192 Jul 6 11:48 /var/lib/mysql/area2/ $ ls -ld /var/lib/mysql/area2/* -rwxrwxrwx 1 mysql mysql 0 Set 15 2006 /var/lib/mysql/area2/449 -rw-rw 1 mysql mysql9202 Jun 29 2006 /var/lib/mysql/area2/cadAIH.frm -rw-

zipcode to timezone

2007-07-06 Thread Hiep Nguyen
Hi there, we have warehouses all over U.S. and i just wonder what is the best way to find out their timezone base on zipcode. Should i buy a database or is there any function in mysql or php to get timezone base on a zipcode? Thanks T. Hiep -- MySQL General Mailing List For list archives:

Re: NFS database

2007-07-06 Thread Michael Dykman
Again, I have no light-bulb on this but let's try a few things. if you do $ ls -ld /var/lib/mysql/area2 $ ls -ld /var/lib/mysql/area2/* on your mySQL host, what are the permissions and ownership of the files? These can get a little tricky under NFS as th on-disk file will store the owner's UID.

Re: NFS database

2007-07-06 Thread Douglas Araujo
There is no error in log file, the server just don't show me the database on the directory /var/lib/mysql/area2. If I go in this directory with the cd command and give a "ls" command, I see the files, but the mysqld don't recognizes the database files. Thanks, Douglas 2007/7/6, Ananda Kumar <[E

Re: Performance problem MySQL 4.0.20

2007-07-06 Thread spikerlion
Hello, Explain where the Statement is very fast: *** 1. row *** table: Stuecke type: ALL possible_keys: PRIMARY,St_Autor key: NULL key_len: NULL ref: NULL rows: 694 Extra: Using where; Usin

question

2007-07-06 Thread Jan De Coster
hi, i'm quite new to this list and i was pondering if there was a way to sync up LDAP users specified in one group with the mysqld users ? kr, Jan De Coster Networking Consultant Digitalbase Belgium -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

bin-log position.

2007-07-06 Thread Ananda Kumar
Hi All, We have setup master/slave replication in our production site. I took a mysqldump from slave using this command /usr/bin/mysqldump --user=andale -h prod -p abc --opt --all-databases --master-data=2 --flush-privileges --single-transaction > reports.dump When i checked reports.dump, it