Re: Database Replication problem

Thanks for the reply. Jim - Original Message - From: Rafal Jank [EMAIL PROTECTED] To: Jim Lucas [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 1:25 AM Subject: Re: Database Replication problem Jim Lucas wrote: just wondering, when you start the database

Database Replication problem

just wondering, when you start the database replicating, the bin files start counting at .000 host-bin.001 host-bin.002 host-bin.003 ... host-bin.999 what happens when you reach .999? does it start over at .001 and over-write you initial files, or does it continue on? Thanks, Jim Lucas

Re: Query problem

Functions, and Date Calculations. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: column maximum?

' which you can reference at will, and add new columns to as future needs arise. Paul Dubois _MySQL_ at http://www.newriders.com has a good 'relational database design' tutorial chapter. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED

Re: Inserting Data on top

?? Sure! Try UPDATE. You will (as it says in O'Reilly,) 'change actual data within a table without altering the table itself.' Meaning you won't be adding or deleting any records, simply adjusting existing records. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED

Re: Basic index questions

? Again, that's the beauty, MySQL will simply use it if it's available and you SELECT the right indexed fields. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com

Re: how to make LOCATE other functions case-insensitive?

return that page in the list. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: Need to understand mysql mechanisms

. Changed one DIMM and it purrs like a kitten. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

RE: mysql question

. There doesn't appear to be any examples of this in the docs. ex: how to remove user named fred from the user table. Thanks Jim -Original Message- From: Jim Chivas [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 4:53 PM To: Mark Maunder Cc: Jim Chivas; [EMAIL PROTECTED

Re: Connection errors and server polling

monitoring' tool and you might find other uses for it. It can page or email you when 'something' does down. http://www.bb4.com Have a :) day! jb ob-filter-words: table sql database -- jim barchuk [EMAIL PROTECTED] - Before posting

Re: Can field names be longer than ONE word?

/paste. Just for fun, try quoting with `backtick.` That's mentioned related to 'special' chars and maybe space is such. Have a :) day! jb ob-filter-words: database sql -- jim barchuk [EMAIL PROTECTED] - Before posting, please

Re:difficulty compiling v4 --without-innodb

bothered to try to figure out how to do that yet. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: Newsgroups

and looking for 'Oh goody! A new group to spam!.' Usenet is essentially a wasteland because the ISPs don't care who does what. The only viable groups out there are moderated, and that's close to a full time job for a list with this kind of traffic. /RANT :) Have a :) day! jb -- jim barchuk [EMAIL

difficulty compiling v4 --without-innodb

]: Leaving directory `/usr/local/src/Apachetoolbox-1.5.41/src/mysql-4.0.0-alpha' make: *** [all-recursive-am] Error 2 There is an innobase/ib_config.h.in but no .h. Any clues? Thanks much. Have a :)day! jb ob-filter-words: database table sql -- jim barchuk [EMAIL PROTECTED

Re:difficulty compiling v4 --without-innodb

! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED

Re: Simple problem: Blank search box returns all records

that right. Someone please correct me if not. Have a :) day! jb ob-Filter-words: databast table sql -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: Problem with query

or Heisenberg's box or /dev/null or other places that don't really 'exist' in our normal human plane of reference *but* do in fact exist and can be used. Have a :) day! jb ob-filter-words: database table sql -- jim barchuk [EMAIL PROTECTED

Re: Problem with query

Hi Paul! On Sat, 27 Oct 2001, Paul DuBois wrote: At 9:38 -0400 10/27/01, jim barchuk wrote: Hi Carl! Paul DuBois writes: NULL basically means unknown value, so saying WHERE x = NULL cannot work, even if x is NULL. That means where one unknown value = another unknown value

Re: insert statement

Nimda hits -on- you, not from you. (Code Red looks for default.ida.) You're probably OK because those lines said error - file not found. Have a :) day! jb ob-filter: database sql table -- jim barchuk [EMAIL PROTECTED] - Before

Re: Weird Error Inserting

' instead of just the one. :) Or of course that can be done from the command line too but it's easier with a more 'fixed' file line number reference. Have a :) day! jb ob-word-filter: database table sql -- jim barchuk [EMAIL PROTECTED

Re: MySQL problem with Traffic and Updates

a :) day! jb ob-filter-words: table sql database -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: I am getting crazy!!!

if they have a FAQ page with the promise that if they do you'll never have to ask them another question again. LOL! Have a :) day! jb ob-filter-gunk: table database sql -- jim barchuk [EMAIL PROTECTED] - Before posting

Re: Field Naming Standards

gotta go find where it's defined.' Writing code is easy. Today. Troubleshooting an obscure error months later, or modifying things to add a new feature is -work-. :) A little up front efort -will- help further down the line. Have a :) day! -- jim barchuk [EMAIL PROTECTED

Re: MYSQL CLIENT

to talk to a remote database. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: What sites?

on it. :) Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e

Re: newbie can't connect error

a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL

Re: [OT] FAQ and Commercial Announcements

versions of MySQL and related programs. This is a low volume list all MySQL users should subscribe to. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php

Re: Multiple field separators

incompatibilities. Have a :) day! jb ob-filter-word: table -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: Select Insert

? That is copy over its attributes, etc.? http://www.mysql.com/doc/C/R/CREATE_TABLE.html Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: RedHat 7.1 refuses to open mysqld]

, which you should change anyway. http://www.mysql.com/doc/P/r/Problems_with_mysql.sock.html Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: newbie Q : importing with accents

://www.mysql.com/doc/C/h/Character_sets.html ? Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: Question of a beginner

? http://www.mysql.com/doc/G/e/Getting_unique_ID.html Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: using test database

touch the 'mysql' db unless you know -exactly- what you're doing. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: Iist number of connections/users

Hello Raj! What is the command to list all the users connected to mysql server? Type mysqladmin with no parameters for command line help and a list of options. The one you need is processlist. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED

Re: Corruption of MyISAM table when deleting/inserting ~7000 rows

the problem themselves. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: MySQL Update Logging ???

write permission. Jeremy posted simply 'No' but http://www.mysql.com/doc/O/p/Option_files.html says that ~/.my.cnf overrides previous cnf options. The server can override the user at the command line but only trying it can prove whether it works or not. Have a :) day! jb -- jim barchuk [EMAIL

Re: Unable to connect to mysql server from client

://www.mysql.com/doc/A/c/Access_denied.html Scroll about halfway down to see that -exact- error message. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php

Re: NUMERIC field contents

based on the information returned from SQLDescribeCol then it will not be expecting to see a number with 11 digits in it. This is what I think is wrong with the behavior of MySQL. -- Jim Dickenson mailto:[EMAIL PROTECTED] Computers for Marketing Corporation http://www.cfmc.com/ eFax: 1-419-791

Re: NUMERIC field contents

On 9/18/01 1:45 PM, Dana Powers at [EMAIL PROTECTED] wrote: And my question is, if you've defined your column to have (10,2) precision, why would you try to insert a higher precision number? dpk - Original Message - From: Jim Dickenson [EMAIL PROTECTED] To: Dana Powers [EMAIL

Re: Problem with MySQL 3.23.40 Install..Source Compiled

a script to retain -your- directory structure and preferences. I also use similar techniques to 'convert' from the rpm system to a 'compiled' version of an application because redhat is often several months to a year to 'forever' behind in upgrades. HTH. Have a :) day! jb -- jim barchuk [EMAIL

Re: can't change to run as ...

/safe_mysqld --log' Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e

Re: Can't delete from very fat table: ERROR 1030: Got error 22 fromtable handler

during that period to find out the the real limit is.) Have a :) day! jb -- jim barchuk [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

NUMERIC field contents

to 999.99. The fact that there is room for a sign character should not increase the number of digits allowed in the field. -- Jim Dickenson mailto:[EMAIL PROTECTED] Computers for Marketing Corporation http://www.cfmc.com/ - Before

Re: intro mysql book

waste of $40 and hours or reading I ever spent in my life. Nuff said? To be fair, I did learn how to create a database, import some data, log in to the server, and do a few simple queries. But that's it. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED

NUMERIC field contents

think the first update should get an error as I specified a maximum of 9 digits. Per your description of numeric() the value should be set to 999.99. The fact that there is room for a sign character should not increase the number of digits allowed in the field. -- Jim Dickenson mailto:[EMAIL

NUMERIC field contents

think the first update should get an error as I specified a maximum of 9 digits. Per your description of numeric() the value should be set to 999.99. The fact that there is room for a sign character should not increase the number of digits allowed in the field. -- Jim Dickenson mailto:[EMAIL

Problem with max() on select

bidder1 20.00 which gives me the higest bid number, but the information from the first bid in the database. How can I retrieve the records that reflect the highest bids for each auction??? Thanx, Jim - Before posting, please

How do I get the query results I want?

... and i can't do a 'having' clause because i have no counts. any help? --jim When I read about the evils of drinking, I gave up reading. - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: Deleting users

delete from mysql.user where mysql.user.user='somebody'; or use mysql; delete from user where user='somebody'; for a list of users, delete from user where user in ('somebody', 'anotherone', 'yetanother'); Jim Michaels - Original Message - From: Jerad Hampton [EMAIL PROTECTED] To: [EMAIL

Re: How do I get the query results I want?

,6,464,3,2,5,2 FAILED,7,468,0,2,5,2 FAILED,8,469,0,2,5,2 FAILED,21,636,6,0,0,1 Jim Michaels ([EMAIL PROTECTED]) - Original Message - From: Jim Matzdorff [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 27, 2001 11:33 AM Subject: How do I get the query results I want? lets say i have

Re: Mysql dumps FTP

(compressed), if I remember, takes a number of hours to compress and up to 3 days to send over a 100kbps WAN across the world. Oracle arch logs don't compress (maybe they are already compressed?). Jim Michaels ([EMAIL PROTECTED]) - Original Message - From: Stefan Hinz [EMAIL PROTECTED

Binlog has bad magic number [SOLVED]

For me, this problem was due to: This problem occurs when the my.cnf file on the master contains log-bin=/var/log/replication.log but just log-bin seems to work. On Mon, Apr 02, 2001 at 05:11:21PM -0400, Jim Ziegler wrote: What causes: 010402 17:08:56 Error reading packet from server

replication-magic number-fire your magician

/replication.log but just log-bin seems to work. However, how do you control the location and name of the log? (This may just be a documentation issue, but the error message is not very intuitive.) Submitter-Id: submitter ID Originator:Jim Ziegler Organization: [EMAIL PROTECTED] (Jim

unsure of performance vs. replication of data...

columns the duplicate data you can get elsewhere but would make a query potentially faster (i believe) but the tables larger? If anyone can point me elsewhere as well... --jim -- And then there was one... - Before posting

Re: Different logs for different databases?

I was wondering, is it possible to have different log files for different databases somehow? RedBack? You're just down the street... Sort of. Ya, but for how long (for either of us). ahem. difficult to do (add the necessary code to MySQL), provided that the logging code is as

selecting the newest/oldest record...

something? thanks, --jim -- And then there was one... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL

Q: Linux - ODBC - MySQL

could try the same setup. TIA - Jim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED

Re: bad magic number, fire your magician error

. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- [EMAIL PROTECTED] (Jim Ziegler) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Rollup features?

Hi, Does anyone know 1) if MySQL / Linux supports the use of Group By ROLLUP? 2) If not (as I suspect), are there plans for such an implementation? Thanks everyone, -Jim - Before posting, please check: http

Re: how to install mysql replication ?

/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- [EMAIL PROTECTED] (Jim Ziegler) - Before

Re: how to install mysql replication ?

On Tue, Jun 12, 2001 at 12:45:15PM -0700, Jeremy Zawodny wrote: On Tue, Jun 12, 2001 at 03:41:25PM -0400, Jim Ziegler wrote: On Tue, Jun 12, 2001 at 12:50:20AM -0700, Jeremy Zawodny wrote: On Tue, Jun 12, 2001 at 02:15:41PM +0700, Said Madrus wrote: Dear all, can anybody tell me how

How do I get MySQL errno from Perl DBI interface?

presume it's something like what we are doing to get the insert ID ($statementHandle-{'mysql_insertid'}). Any ideas? Jim Beigel [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: can't shutdown mysqld (nicely or not) on OS X 10.0.2

Tyler, Thanks for all the info... I'd love to help find the answer, but I don't know gdb (or even what it is, but I have heard those letters before :) So now I can start and stop the server... do any of the other issues you mention affect how mysql works for small databases? Thanks, Jim on 5

Question about a (better) query.

OR statement in table3, all values are looked at in table2, then grouped, and then the only ones returned are those that group to the same number of OR's we are looking for. I have got to think this is inefficient. Anyone have suggestions? Comments? Anything? Thanks, --jim When I read

A problem with the MySQL web site.

PROTECTED]','newufo','Jim','Pishlo','15866 Garrison Lane','Southgate','Mi','48195','US','7342848671','','','Pishlo Net','Y',now()) failed: Unknown column 'id' in 'field list' -Jim Pishlo www.sweetsystems.com Dreamers build castles in the sky. Psychopaths move into them. What I need to know is, where

myODBC on Linux newbie question

.iodbc.ini files has changed. how do I do that? For that matter, how do I start MyODBC / iODBC ? these are simple questions, but there is no place I've found that talks about MyODBC linux in detail. MySQL is running on another Linux box and is talking to Webmin just fine. TIA - Jim

Re: myODBC on Linux newbie question

We are using a shopping cart / front end called WebCatalog and it needs ODBC. I know there are other solutions, but if we can get ODBC working then there is no code change for WebCatalog - Jim why are you using ODBC if you're trying to connect from one linux box to a MySQL database housed

Error: Didn't find any fields in table 'name'

MySQL doesn't work on OpenBSD 2.8 because of a bug in OpenBSD (http://www.mysql.com/doc/O/p/OpenBSD_2.8.html) Please help! Thanks - Jim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

replication problems

does anyone that is using replication have any suggestions at all about how to get past this problem? is anyone using replication successfully? - Forwarded message from Jim Ziegler [EMAIL PROTECTED] - Envelope-to: [EMAIL PROTECTED] Delivery-date: Tue, 10 Apr 2001 16:42:26 -0400 Mailing

RE: Select

What is good clean sql syntax to accomplish the following with MySQL: SELECT * FROM tablename WHERE value is in array of values i.e. (psudocode) Assume I have a field called ID in my table, and that I have 20 Rows (with ID's 1-20) myarray = (1,3,4) I want to return all the fields where ID = 1

replication problems

rrno=65535) and in the master log: 010410 16:35:583006 Connect[EMAIL PROTECTED] on 3007 Connect[EMAIL PROTECTED] on 3007 Quit 3006 Binlog Dum What is wrong? Where do I get a better magician? -- [EMAIL PROTECTED] (J

Re: load aca from master

database,sql,query load table from master does not work for me. I get the error message ERROR 1189: Net error reading from master what can cause this? both the master and the slave are version 3.23.33-log -- [EMAIL PROTECTED] (Jim Ziegler

SOLVED: Re: load aca from master

On Mon, Apr 09, 2001 at 02:01:55PM -0400, Jim Ziegler wrote: database,sql,query load table from master does not work for me. I get the error message ERROR 1189: Net error reading from master what can cause this? both the master and the slave are version 3.23.33-log

Re: Binlog has bad magic number

' message? The log file on the master is not named FIRST. -- [EMAIL PROTECTED] (Jim Ziegler) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the li

Help with SQL

rence for a licenceNo and the subCCYYMM is 200103. That is, find only the historical records for a licenceNo where March is the only record. Any suggestions would be helpful. Thanks, Jim Jim Hamer Downtown Data Processing Inc. (416) 489-3298 home and office [EMAIL PROTECTED] Toronto, Ontario, Canada http://webhome.idirect.com/~jhamer/

RE: mysqldump hangs

FYI, I tested MySQL 3.23.36 with the same setup as below. I got identical results. -Original Message- From: Ide, Jim Sent: Saturday, March 31, 2001 4:59 PM To: '[EMAIL PROTECTED]' Subject: mysqldump hangs OpenBSD 2.8 swap partition is 256mb /tmp partition is 1gb Pentium III 667mhz

problem with LOAD TABLE command

: 1 Open tables: 6 Queries per second avg: 0.034 -- -- [EMAIL PROTECTED] (Jim Ziegler) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Binlog has bad magic number

:34 fetch_nx_table: failed on create table when i try to: mysql load table aca from master; ERROR 1189: Net error reading from master -- [EMAIL PROTECTED] (Jim Ziegler) - Before posting, please check: http://www.mysql.com

Re: Need examples of companies using mysql

I use MySQL for my personal web site, but as the Director of Information Systems (I suppose I am one of those higher ups) I can't imagine using MySQL for mission critical applications until it has transaction support (commit and rollback). Jim Gillaspy - Original Message - From: "

mysqldump hangs

% cpu, and the index is still not done being built after 30 minutes (the identical data is on a linux box, and the index takes 3 minutes to build. Any ideas? Many thanks - Jim - Before posting, please check: http

MySQL Server Crash. Where to Start?

I have a busy website that uses mysql. It crashed this morning. I don't know where to begin to fix it. I did notice in my httpd-error.log that I've been getting a bunch of errors: DBI::db=HASH(0x8101d68)-disconnect invalidates 1 active statement handle (either destroy statement handles or

Aphace and MySql

Will MySQL work with Aphace for windows? Thank you Jim Ray - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e

Re: XML support under mySQL

Actually, in a relational database, you do store metadata in the database, along with the data it describes. - Original Message - From: "Ed Carp" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, February 22, 2001 7:18 AM Subject: Re: XML support under mySQL

Optimizing Queries

I have a non-profit site that uses mysql. I need to optimize two queries so they won't put such a load on the mysql server. If I don't lighten the load, they've treatened to kick us off. What columns are best to index? SELECT messages.ID as ID, title, text, user_id, username, email

16 Index Table Limit

Is there a way to define more than 16 btrees per table? Can this index limit be increased to 32 or more? It's a static database that is massively updated once or twice a year so update performance is not the issue, rather speed of queries. Please respond to [EMAIL PROTECTED] because I am not

<    2   3   4   5   6   7