mysqldump on slave.

Hi All, I am planning to take mysqldump on slave running innodb engine. I going to use the below command /usr/bin/mysqldump --user=root --password= --flush-logs --all-databases --master-data=2 --single-transaction alldbdump.sql Before doing the mysqldump, should i stop the slave or the

Re: DELETE query help please?

This should work DELETE Item FROM Item,ItemTag WHERE Item.ProductID =ItemTag.ItemID AND ItemTag.TagID = '168' Mark Kelly wrote: Hi I want to delete from the 'Item' table all the items identified by the folowing query: SELECT Item.ProductID FROM Item, ItemTag WHERE

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

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

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;

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

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

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

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

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

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

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

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

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

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,

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.

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,

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

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

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

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

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]

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

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

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 mysql@lists.mysql.com Sent: Friday, July 6, 2007 11:55:41 AM (GMT-0500) America/New_York Subject: off-topic unsubscribe concern Hi everyone.