Re: off-topic unsubscribe concern
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 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, so I doubt I am inadvertantly kicking these off, which was my first theory. Is anyone else suffering from this or is it just me? -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- B. Keith Murphy Database Administrator iContact 2635 Meridian Parkway, 2nd Floor Durham, North Carolina 27713 (o) 919-433-0786 (c) 850-637-3877
RE: zipcode to timezone
> -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 timezones in a state, at least to me. men, they have too much > time in their hand and this is they came up, two timezones in a state. Me neither. I was interested to learn that there are noticeable energy savings associated with the Daylight Savings time change. Who'd a thunk it? JT INFORMATION IN THIS MESSAGE, INCLUDING ANY ATTACHMENTS, IS INTENDED FOR THE PERSONAL AND CONFIDENTIAL USE OF THE INTENDED RECIPIENT(S) NAMED ABOVE. If you are not an intended recipient of this message, or an agent responsible for delivering it to an intended recipient, you are hereby notified that you have received this message in error, and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you received this message in error, please notify the sender immediately, delete the message, and return any hard copy print-outs. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: NFS database
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 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, everything looks just fine from here; you might check permissions/ownership on '/var/lib/mysql' too.. if it looks like the output you showed me above, then it really should work. If the latter, I could see some interesting interactions which might cause an issue... Perhaps the relevant output from $ mount -a would shed some light. On 7/6/07, Douglas Araujo <[EMAIL PROTECTED]> wrote: > 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-rw 1 mysql mysql 1057792 Jul 3 2006 /var/lib/mysql/area2/cadAIH.MYI > -rw-rw 1 mysql mysql8714 Mai 22 2006 /var/lib/mysql/area2/cadCid.frm > -rw-rw 1 mysql mysql 0 Mai 22 2006 /var/lib/mysql/area2/cadCid.MYD > -rw-rw 1 mysql mysql 0 Mai 29 2006 /var/lib/mysql/area2/cadCid.MYI > -rw-rw 1 mysql mysql8930 Mai 22 2006 > /var/lib/mysql/area2/cadHospital.frm > -rw-rw 1 mysql mysql 0 Mai 22 2006 > /var/lib/mysql/area2/cadHospital.MYD > -rw-rw 1 mysql mysql 0 Mai 29 2006 > /var/lib/mysql/area2/cadHospital.MYI > -rw-rw 1 mysql mysql8800 Mai 22 2006 > /var/lib/mysql/area2/cadMunicipio.frm > -rw-rw 1 mysql mysql 0 Mai 22 2006 > /var/lib/mysql/area2/cadMunicipio.MYD > -rw-rw 1 mysql mysql 0 Mai 29 2006 > /var/lib/mysql/area2/cadMunicipio.MYI > -rw-rw 1 mysql mysql8782 Mai 22 2006 > /var/lib/mysql/area2/tabArquivo.frm > -rw-rw 1 mysql mysql 0 Mai 22 2006 > /var/lib/mysql/area2/tabArquivo.MYD > -rw-rw 1 mysql mysql1024 Mai 22 2006 > /var/lib/mysql/area2/tabArquivo.MYI > -rw-rw 1 mysql mysql8970 Mai 22 2006 /var/lib/mysql/area2/tabCampo.frm > -rw-rw 1 mysql mysql 0 Mai 22 2006 /var/lib/mysql/area2/tabCampo.MYD > -rw-rw 1 mysql mysql1024 Mai 22 2006 /var/lib/mysql/area2/tabCampo.MYI > -rw-rw 1 mysql mysql8690 Mai 22 2006 /var/lib/mysql/area2/tabLog.frm > -rw-rw 1 mysql mysql 0 Mai 22 2006 /var/lib/mysql/area2/tabLog.MYD > -rw-rw 1 mysql mysql1024 Mai 22 2006 /var/lib/mysql/area2/tabLog.MYI > -rw-rw 1 mysql mysql8794 Mai 22 2006 /var/lib/mysql/area2/tabMenu.frm > -rw-rw 1 mysql mysql 0 Mai 22 2006 /var/lib/mysql/area2/tabMenu.MYD > -rw-rw 1 mysql mysql1024 Mai 22 2006 /var/lib/mysql/area2/tabMenu.MYI > -rw-rw 1 mysql mysql8638 Mai 22 2006 /var/lib/mysql/area2/tabSenha.frm > -rw-rw 1 mysql mysql8652 Mai 22 2006 > /var/lib/mysql/area2/tabSenhaModulo.frm > -rw-rw 1 mysql mysql 200 Jul 24 2006 > /var/lib/mysql/area2/tabSenhaModulo.MYD > -rw-rw 1 mysql mysql 0 Ago 3 2006 > /var/lib/mysql/area2/tabSenhaModulo.MYI > -rw-rw 1 mysql mysql 216 Jul 24 2006 /var/lib/mysql/area2/tabSenha.MYD > -rw-rw 1 mysql mysql 0 Ago 3 2006 /var/lib/mysql/area2/tabSenha.MYI > -rw-rw 1 mysql mysql8656 Mai 22 2006 > /var/lib/mysql/area2/tabUsuario.frm > -rw-rw 1 mysql mysql 0 Mai 22 2006 > /var/lib/mysql/area2/tabUsuario.MYD > -rw-rw 1 mysql mysql1024 Mai 22 2006 > /var/lib/mysql/area2/tabUsuario.MYI > > These was the results, I will look up for the informations of the user > mysql on the storage. > > Thanks for the help, > > Douglas > > > 2007/7/6, Michael Dykman <[EMAIL PROTECTED]>: > > 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. That UID may have different meaning on > > the file host as opposed to the SQL host if the users and groups are > > not synchronized between those hosts. > > > > - michael > > > > On 7/6/07, Douglas Araujo <[EMAIL PROTECTED]> wrote: > > > 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, > > > > > > D
RE: zipcode to timezone
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.coop -Original Message- From: Hiep Nguyen [mailto:[EMAIL PROTECTED] Sent: Friday, July 06, 2007 10:51 To: David T. Ashley Cc: mysql@lists.mysql.com Subject: Re: zipcode to timezone 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 base on a zipcode? I looked at the zipcode databases ... not as expensive as I would have thought. It might be worth it just to spend the $100 or so. However, ... My understanding is that U.S. zipcodes have their first two digits based on state, i.e. "48" is Michigan. Since most of the time zone boundaries seem to fall on state boundaries, a simple mapping from the first two digits to the time zone might get you most of the way there. http://images.google.com/imgres?imgurl=http://worldatlas.com/webimage/co untrys/namerica/usstates/timezone.gif&imgrefurl=http://worldatlas.com/we bimage/countrys/namerica/usstates/timezone.htm&h=307&w=427&sz=23&tbnid=p XERv6TKqAu7DM:&tbnh=91&tbnw=126&prev=/images%3Fq%3Du.s.%2Btime%2Bzone%2B map%26um%3D1&start=2&sa=X&oi=images&ct=image&cd=2 However, for those states that are split, I don't know an easy way ... but there shouldn't be very many of those. Dave. i don't think there is any state got 2 timezones, i could be wrong. but if that the case, state -> timezone is working for me. now, how do i look up for timezone if i got state? i don't mind buying the database, but i just don't want to replace the database if something change down the road. thanks T. Hiep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] now, why do they do this??? it doesn't make any sense at all to have multiple timezones in a state, at least to me. men, they have too much time in their hand and this is they came up, two timezones in a state. thank you all, T. Hiep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: zipcode to timezone
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 Nguyen [mailto:[EMAIL PROTECTED] Sent: Friday, July 06, 2007 10:51 To: David T. Ashley Cc: mysql@lists.mysql.com Subject: Re: zipcode to timezone 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 base on a zipcode? > > > I looked at the zipcode databases ... not as expensive as I would have > thought. It might be worth it just to spend the $100 or so. > > However, ... > > My understanding is that U.S. zipcodes have their first two digits based on > state, i.e. "48" is Michigan. > > Since most of the time zone boundaries seem to fall on state boundaries, a > simple mapping from the first two digits to the time zone might get you most > of the way there. > > http://images.google.com/imgres?imgurl=http://worldatlas.com/webimage/co untrys/namerica/usstates/timezone.gif&imgrefurl=http://worldatlas.com/we bimage/countrys/namerica/usstates/timezone.htm&h=307&w=427&sz=23&tbnid=p XERv6TKqAu7DM:&tbnh=91&tbnw=126&prev=/images%3Fq%3Du.s.%2Btime%2Bzone%2B map%26um%3D1&start=2&sa=X&oi=images&ct=image&cd=2 > > However, for those states that are split, I don't know an easy way ... but > there shouldn't be very many of those. > > Dave. > i don't think there is any state got 2 timezones, i could be wrong. but if that the case, state -> timezone is working for me. now, how do i look up for timezone if i got state? i don't mind buying the database, but i just don't want to replace the database if something change down the road. thanks T. Hiep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: zipcode to timezone
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 timezones, i could be wrong. Yeah, you are. http://worldatlas.com/webimage/countrys/namerica/usstates/timezone.htm One other thought comes to mind. Is there a guarantee that a timezone can't split a zipcode? In other words, is the mapping from zipcode->timezone guaranteed to exist in all cases? I remember a friend in Tennessee who would take her children to school (10 miles away) and the school was in a different timezone than her home, so it got very confusing what time the kids had to be up and to bed and all that. In rural areas where the zipcodes can be rather large, I'm just wondering if there is any guarantee that a zipcode can't span two timzones.
RE: zipcode to timezone
> -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://worldatlas.com/webimage/countrys/namerica/usstates/timezone.htm INFORMATION IN THIS MESSAGE, INCLUDING ANY ATTACHMENTS, IS INTENDED FOR THE PERSONAL AND CONFIDENTIAL USE OF THE INTENDED RECIPIENT(S) NAMED ABOVE. If you are not an intended recipient of this message, or an agent responsible for delivering it to an intended recipient, you are hereby notified that you have received this message in error, and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you received this message in error, please notify the sender immediately, delete the message, and return any hard copy print-outs. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Import a text file
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 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 and then upload this file to Mysql. What I don't know how to do is to have the file split into the correct fields. Here is a sample of the file MO 07/03 13:58:00 00:00:34 103 1817295978204 MO 07/03 13:58:00 00:00:24 103 8175177982 05 MO 07/03 13:59:00 00:00:23 103 8175177982 04 MO 07/03 13:53:00 00:07:25 105 18004445445000 06 MI 07/03 14:00:00 00:01:55 100 8177740741 01 It is a fixed format so I could probably just write a script that parses the program Or write a script that adds a comma to the correct location. Does anyone have any suggestions or already have something that does this? Thanks in Advanced Scott Swaim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: off-topic unsubscribe concern
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 Dykman [mailto:[EMAIL PROTECTED] > Sent: Friday, July 06, 2007 11:56 AM > To: MySQL General > Subject: off-topic unsubscribe concern > > 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, so I doubt I am inadvertantly kicking these off, > which was my first theory. > > Is anyone else suffering from this or is it just me? > > -- > - michael dykman > - [EMAIL PROTECTED] > > - All models are wrong. Some models are useful. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: zipcode to timezone
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.com www.giiexpress.com www.etudes-marche.com > -Original Message- > From: Hiep Nguyen [mailto:[EMAIL PROTECTED] > Sent: Friday, July 06, 2007 11:51 AM > To: David T. Ashley > Cc: mysql@lists.mysql.com > Subject: Re: zipcode to timezone > > 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 base on > a zipcode? > > > > > > I looked at the zipcode databases ... not as expensive as I > would have > > thought. It might be worth it just to spend the $100 or so. > > > > However, ... > > > > My understanding is that U.S. zipcodes have their first two > digits based on > > state, i.e. "48" is Michigan. > > > > Since most of the time zone boundaries seem to fall on > state boundaries, a > > simple mapping from the first two digits to the time zone > might get you most > > of the way there. > > > > > http://images.google.com/imgres?imgurl=http://worldatlas.com/w ebimage/countrys/namerica/usstates/timezone.gif&imgrefurl=http://worldatlas. com/webimage/countrys/namerica/usstat> es/timezone.htm&h=307&w=427&sz=23&tbnid=pXERv6TKqAu7DM:&tbnh=9 > 1&tbnw=126&prev=/images%3Fq%3Du.s.%2Btime%2Bzone%2Bmap%26um%3D > 1&start=2&sa=X&oi=images&ct=image&cd=2 > > > > However, for those states that are split, I don't know an > easy way ... but > > there shouldn't be very many of those. > > > > Dave. > > > > i don't think there is any state got 2 timezones, i could be > wrong. but > if that the case, state -> timezone is working for me. now, > how do i look > up for timezone if i got state? i don't mind buying the > database, but i > just don't want to replace the database if something change > down the road. > > thanks > T. Hiep > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: NFS database
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, everything looks just fine from here; you might check permissions/ownership on '/var/lib/mysql' too.. if it looks like the output you showed me above, then it really should work. If the latter, I could see some interesting interactions which might cause an issue... Perhaps the relevant output from $ mount -a would shed some light. On 7/6/07, Douglas Araujo <[EMAIL PROTECTED]> wrote: 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-rw 1 mysql mysql 1057792 Jul 3 2006 /var/lib/mysql/area2/cadAIH.MYI -rw-rw 1 mysql mysql8714 Mai 22 2006 /var/lib/mysql/area2/cadCid.frm -rw-rw 1 mysql mysql 0 Mai 22 2006 /var/lib/mysql/area2/cadCid.MYD -rw-rw 1 mysql mysql 0 Mai 29 2006 /var/lib/mysql/area2/cadCid.MYI -rw-rw 1 mysql mysql8930 Mai 22 2006 /var/lib/mysql/area2/cadHospital.frm -rw-rw 1 mysql mysql 0 Mai 22 2006 /var/lib/mysql/area2/cadHospital.MYD -rw-rw 1 mysql mysql 0 Mai 29 2006 /var/lib/mysql/area2/cadHospital.MYI -rw-rw 1 mysql mysql8800 Mai 22 2006 /var/lib/mysql/area2/cadMunicipio.frm -rw-rw 1 mysql mysql 0 Mai 22 2006 /var/lib/mysql/area2/cadMunicipio.MYD -rw-rw 1 mysql mysql 0 Mai 29 2006 /var/lib/mysql/area2/cadMunicipio.MYI -rw-rw 1 mysql mysql8782 Mai 22 2006 /var/lib/mysql/area2/tabArquivo.frm -rw-rw 1 mysql mysql 0 Mai 22 2006 /var/lib/mysql/area2/tabArquivo.MYD -rw-rw 1 mysql mysql1024 Mai 22 2006 /var/lib/mysql/area2/tabArquivo.MYI -rw-rw 1 mysql mysql8970 Mai 22 2006 /var/lib/mysql/area2/tabCampo.frm -rw-rw 1 mysql mysql 0 Mai 22 2006 /var/lib/mysql/area2/tabCampo.MYD -rw-rw 1 mysql mysql1024 Mai 22 2006 /var/lib/mysql/area2/tabCampo.MYI -rw-rw 1 mysql mysql8690 Mai 22 2006 /var/lib/mysql/area2/tabLog.frm -rw-rw 1 mysql mysql 0 Mai 22 2006 /var/lib/mysql/area2/tabLog.MYD -rw-rw 1 mysql mysql1024 Mai 22 2006 /var/lib/mysql/area2/tabLog.MYI -rw-rw 1 mysql mysql8794 Mai 22 2006 /var/lib/mysql/area2/tabMenu.frm -rw-rw 1 mysql mysql 0 Mai 22 2006 /var/lib/mysql/area2/tabMenu.MYD -rw-rw 1 mysql mysql1024 Mai 22 2006 /var/lib/mysql/area2/tabMenu.MYI -rw-rw 1 mysql mysql8638 Mai 22 2006 /var/lib/mysql/area2/tabSenha.frm -rw-rw 1 mysql mysql8652 Mai 22 2006 /var/lib/mysql/area2/tabSenhaModulo.frm -rw-rw 1 mysql mysql 200 Jul 24 2006 /var/lib/mysql/area2/tabSenhaModulo.MYD -rw-rw 1 mysql mysql 0 Ago 3 2006 /var/lib/mysql/area2/tabSenhaModulo.MYI -rw-rw 1 mysql mysql 216 Jul 24 2006 /var/lib/mysql/area2/tabSenha.MYD -rw-rw 1 mysql mysql 0 Ago 3 2006 /var/lib/mysql/area2/tabSenha.MYI -rw-rw 1 mysql mysql8656 Mai 22 2006 /var/lib/mysql/area2/tabUsuario.frm -rw-rw 1 mysql mysql 0 Mai 22 2006 /var/lib/mysql/area2/tabUsuario.MYD -rw-rw 1 mysql mysql1024 Mai 22 2006 /var/lib/mysql/area2/tabUsuario.MYI These was the results, I will look up for the informations of the user mysql on the storage. Thanks for the help, Douglas 2007/7/6, Michael Dykman <[EMAIL PROTECTED]>: > 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. That UID may have different meaning on > the file host as opposed to the SQL host if the users and groups are > not synchronized between those hosts. > > - michael > > On 7/6/07, Douglas Araujo <[EMAIL PROTECTED]> wrote: > > 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 <[EMAIL PROTECTED]>: > > > What i the error you seeing the error log file. > > > Please let us know > > > > > > > > > > > > On 7/5/07, Douglas Araujo <[EMAIL PROTECTED]> wrote: > > > > > > > > Hi everybody, > > > > > > > > I have a MySQL 4.1 running on a Red Hat Linux Enterprise 4 that the > > > > databases directory is the default point, /var/lib/mysql. > > > > > > > > I have a NFS mount point in /var/lib/mysql/area2, that
Import a text file
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 and then upload this file to Mysql. What I don't know how to do is to have the file split into the correct fields. Here is a sample of the file MO 07/03 13:58:00 00:00:34 103 1817295978204 MO 07/03 13:58:00 00:00:24 103 8175177982 05 MO 07/03 13:59:00 00:00:23 103 8175177982 04 MO 07/03 13:53:00 00:07:25 105 18004445445000 06 MI 07/03 14:00:00 00:01:55 100 8177740741 01 It is a fixed format so I could probably just write a script that parses the program Or write a script that adds a comma to the correct location. Does anyone have any suggestions or already have something that does this? Thanks in Advanced Scott Swaim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
off-topic unsubscribe concern
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, so I doubt I am inadvertantly kicking these off, which was my first theory. Is anyone else suffering from this or is it just me? -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: zipcode to timezone
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 base on a zipcode? I looked at the zipcode databases ... not as expensive as I would have thought. It might be worth it just to spend the $100 or so. However, ... My understanding is that U.S. zipcodes have their first two digits based on state, i.e. "48" is Michigan. Since most of the time zone boundaries seem to fall on state boundaries, a simple mapping from the first two digits to the time zone might get you most of the way there. http://images.google.com/imgres?imgurl=http://worldatlas.com/webimage/countrys/namerica/usstates/timezone.gif&imgrefurl=http://worldatlas.com/webimage/countrys/namerica/usstates/timezone.htm&h=307&w=427&sz=23&tbnid=pXERv6TKqAu7DM:&tbnh=91&tbnw=126&prev=/images%3Fq%3Du.s.%2Btime%2Bzone%2Bmap%26um%3D1&start=2&sa=X&oi=images&ct=image&cd=2 However, for those states that are split, I don't know an easy way ... but there shouldn't be very many of those. Dave. i don't think there is any state got 2 timezones, i could be wrong. but if that the case, state -> timezone is working for me. now, how do i look up for timezone if i got state? i don't mind buying the database, but i just don't want to replace the database if something change down the road. thanks T. Hiep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: zipcode to timezone
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 your PHP code to find this out. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: zipcode to timezone
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 databases ... not as expensive as I would have thought. It might be worth it just to spend the $100 or so. However, ... My understanding is that U.S. zipcodes have their first two digits based on state, i.e. "48" is Michigan. Since most of the time zone boundaries seem to fall on state boundaries, a simple mapping from the first two digits to the time zone might get you most of the way there. http://images.google.com/imgres?imgurl=http://worldatlas.com/webimage/countrys/namerica/usstates/timezone.gif&imgrefurl=http://worldatlas.com/webimage/countrys/namerica/usstates/timezone.htm&h=307&w=427&sz=23&tbnid=pXERv6TKqAu7DM:&tbnh=91&tbnw=126&prev=/images%3Fq%3Du.s.%2Btime%2Bzone%2Bmap%26um%3D1&start=2&sa=X&oi=images&ct=image&cd=2 However, for those states that are split, I don't know an easy way ... but there shouldn't be very many of those. Dave.
Re: NFS database
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-rw 1 mysql mysql 1057792 Jul 3 2006 /var/lib/mysql/area2/cadAIH.MYI -rw-rw 1 mysql mysql8714 Mai 22 2006 /var/lib/mysql/area2/cadCid.frm -rw-rw 1 mysql mysql 0 Mai 22 2006 /var/lib/mysql/area2/cadCid.MYD -rw-rw 1 mysql mysql 0 Mai 29 2006 /var/lib/mysql/area2/cadCid.MYI -rw-rw 1 mysql mysql8930 Mai 22 2006 /var/lib/mysql/area2/cadHospital.frm -rw-rw 1 mysql mysql 0 Mai 22 2006 /var/lib/mysql/area2/cadHospital.MYD -rw-rw 1 mysql mysql 0 Mai 29 2006 /var/lib/mysql/area2/cadHospital.MYI -rw-rw 1 mysql mysql8800 Mai 22 2006 /var/lib/mysql/area2/cadMunicipio.frm -rw-rw 1 mysql mysql 0 Mai 22 2006 /var/lib/mysql/area2/cadMunicipio.MYD -rw-rw 1 mysql mysql 0 Mai 29 2006 /var/lib/mysql/area2/cadMunicipio.MYI -rw-rw 1 mysql mysql8782 Mai 22 2006 /var/lib/mysql/area2/tabArquivo.frm -rw-rw 1 mysql mysql 0 Mai 22 2006 /var/lib/mysql/area2/tabArquivo.MYD -rw-rw 1 mysql mysql1024 Mai 22 2006 /var/lib/mysql/area2/tabArquivo.MYI -rw-rw 1 mysql mysql8970 Mai 22 2006 /var/lib/mysql/area2/tabCampo.frm -rw-rw 1 mysql mysql 0 Mai 22 2006 /var/lib/mysql/area2/tabCampo.MYD -rw-rw 1 mysql mysql1024 Mai 22 2006 /var/lib/mysql/area2/tabCampo.MYI -rw-rw 1 mysql mysql8690 Mai 22 2006 /var/lib/mysql/area2/tabLog.frm -rw-rw 1 mysql mysql 0 Mai 22 2006 /var/lib/mysql/area2/tabLog.MYD -rw-rw 1 mysql mysql1024 Mai 22 2006 /var/lib/mysql/area2/tabLog.MYI -rw-rw 1 mysql mysql8794 Mai 22 2006 /var/lib/mysql/area2/tabMenu.frm -rw-rw 1 mysql mysql 0 Mai 22 2006 /var/lib/mysql/area2/tabMenu.MYD -rw-rw 1 mysql mysql1024 Mai 22 2006 /var/lib/mysql/area2/tabMenu.MYI -rw-rw 1 mysql mysql8638 Mai 22 2006 /var/lib/mysql/area2/tabSenha.frm -rw-rw 1 mysql mysql8652 Mai 22 2006 /var/lib/mysql/area2/tabSenhaModulo.frm -rw-rw 1 mysql mysql 200 Jul 24 2006 /var/lib/mysql/area2/tabSenhaModulo.MYD -rw-rw 1 mysql mysql 0 Ago 3 2006 /var/lib/mysql/area2/tabSenhaModulo.MYI -rw-rw 1 mysql mysql 216 Jul 24 2006 /var/lib/mysql/area2/tabSenha.MYD -rw-rw 1 mysql mysql 0 Ago 3 2006 /var/lib/mysql/area2/tabSenha.MYI -rw-rw 1 mysql mysql8656 Mai 22 2006 /var/lib/mysql/area2/tabUsuario.frm -rw-rw 1 mysql mysql 0 Mai 22 2006 /var/lib/mysql/area2/tabUsuario.MYD -rw-rw 1 mysql mysql1024 Mai 22 2006 /var/lib/mysql/area2/tabUsuario.MYI These was the results, I will look up for the informations of the user mysql on the storage. Thanks for the help, Douglas 2007/7/6, Michael Dykman <[EMAIL PROTECTED]>: 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. That UID may have different meaning on the file host as opposed to the SQL host if the users and groups are not synchronized between those hosts. - michael On 7/6/07, Douglas Araujo <[EMAIL PROTECTED]> wrote: > 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 <[EMAIL PROTECTED]>: > > What i the error you seeing the error log file. > > Please let us know > > > > > > > > On 7/5/07, Douglas Araujo <[EMAIL PROTECTED]> wrote: > > > > > > Hi everybody, > > > > > > I have a MySQL 4.1 running on a Red Hat Linux Enterprise 4 that the > > > databases directory is the default point, /var/lib/mysql. > > > > > > I have a NFS mount point in /var/lib/mysql/area2, that mounts the > > > directory of a storage, when I mount the NFS, the MySQL server don't > > > show the database. > > > > > > Anyone can help me? > > > > > > Thanks, > > > > > > Douglas > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
zipcode to timezone
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: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: NFS database
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. That UID may have different meaning on the file host as opposed to the SQL host if the users and groups are not synchronized between those hosts. - michael On 7/6/07, Douglas Araujo <[EMAIL PROTECTED]> wrote: 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 <[EMAIL PROTECTED]>: > What i the error you seeing the error log file. > Please let us know > > > > On 7/5/07, Douglas Araujo <[EMAIL PROTECTED]> wrote: > > > > Hi everybody, > > > > I have a MySQL 4.1 running on a Red Hat Linux Enterprise 4 that the > > databases directory is the default point, /var/lib/mysql. > > > > I have a NFS mount point in /var/lib/mysql/area2, that mounts the > > directory of a storage, when I mount the NFS, the MySQL server don't > > show the database. > > > > Anyone can help me? > > > > Thanks, > > > > Douglas > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: NFS database
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 <[EMAIL PROTECTED]>: What i the error you seeing the error log file. Please let us know On 7/5/07, Douglas Araujo <[EMAIL PROTECTED]> wrote: > > Hi everybody, > > I have a MySQL 4.1 running on a Red Hat Linux Enterprise 4 that the > databases directory is the default point, /var/lib/mysql. > > I have a NFS mount point in /var/lib/mysql/area2, that mounts the > directory of a storage, when I mount the NFS, the MySQL server don't > show the database. > > Anyone can help me? > > Thanks, > > Douglas > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Performance problem MySQL 4.0.20
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; Using temporary; Using filesort *** 2. row *** table: StueckBilder type: ref possible_keys: StB_StueckID key: StB_StueckID key_len: 5 ref: Stuecke.St_ID rows: 3 Extra: Using where *** 3. row *** table: St_Aufg_Pers_V type: index possible_keys: St_Aufg_Pers_V_StueckID key: St_Aufg_Pers_V_StueckID key_len: 15 ref: NULL rows: 863 Extra: Using where; Using index; Distinct 3 rows in set (0.00 sec) explain from the slow machine: *** 1. row *** table: Stuecke type: ALL possible_keys: PRIMARY,St_Autor key: NULL key_len: NULL ref: NULL rows: 694 Extra: Using where; Using temporary; Using filesort *** 2. row *** table: StueckBilder type: ref possible_keys: StB_StueckID key: StB_StueckID key_len: 5 ref: Stuecke.St_ID rows: 3 Extra: Using where *** 3. row *** table: St_Aufg_Pers_V type: index possible_keys: St_Aufg_Pers_V_StueckID key: St_Aufg_Pers_V_StueckID key_len: 15 ref: NULL rows: 863 Extra: Using where; Using index; Distinct 3 rows in set (0.00 sec) In my opinion there are no differences. How does the cpu power influence the speed of a query? Regards, Spiker -- Ist Ihr Browser Vista-kompatibel? Jetzt die neuesten Browser-Versionen downloaden: http://www.gmx.net/de/go/browser -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
question
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:http://lists.mysql.com/[EMAIL PROTECTED]
bin-log position.
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 showing as -- CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.03', MASTER_LOG_POS=311; But before i started the mysqldump, I did the below on slave db. show slave status\G Master_Log_File: mysql-bin.29 Read_Master_Log_Pos: 106683511 Relay_Log_File: relay-log.039071 Relay_Log_Pos: 106683648 Relay_Master_Log_File: mysql-bin.29 Slave_IO_Running: Yes Slave_SQL_Running: Yes As see in the mysqldump is saying to start recovery from bin-log file "' mysql-bin.03'" and position="MASTER_LOG_POS=311", but the current master bin-log and postion as seen from above is different. So, if restore the dump to a new machine and apply bin-logs at regulare interval, from which bin-log should i start and from which position. Please help, regards anandkl
