RE: Mysql.Sock problem

Is mysql running (ps -axu) if not: /path/to/safe_mysqld --user=mysql & This is explained in the docs -Oorspronkelijk bericht- Van: Jason Steig [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 31 december 2002 9:08 Aan: [EMAIL PROTECTED] Onderwerp: Mysql.Sock problem I' am relatively

RE: Sanity on restore

Patrick Nelson wrote: - Moving a server (RH6.2 w/ 3.23.43) to a temporary system (RH7.3 w/ 3.23.49-3) and I have a mysql dump file created using: mysqldump -A my-move.sql Just installed the server rpm on the temp system and any attempt to connect gives error because of a pas

Embedded MySQL Server

Hi, Since libmysqld does not use sockets or TCP/IP, what's the mechanism it uses when the client and server communicate with each other? I mean how embedded MySQL Server works as a server. Thanks for reply in advance. Regards. -- ___ Get your free e

Mysql.Sock problem

I' am relatively new to MySQL and I 'am having a problem with starting the ./mysql program I always get the mysql.sock error. I know this mysql.sock file is used when the local machine is the mysql server. Likewise I can't start mysql.server or mysqld. I' am trying to start it as root. I know

server shutdown ? lost password ? (didn't set one)

apparently I can connect to mySQL, as a under privilege user, but can't created a new database, after two days, of getting this far, Now what? So, I did the [MacG4a:~] rnagle% mysql -u root ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) [MacG4a:~] rnagle% Which is suppo

Re: replication

On Mon, Dec 30, 2002 at 10:16:07PM -0600, Dan Nelson wrote: > Bah. sql, query, queries, smallint > > In the last episode (Dec 30), Rick Faircloth said: > > Aaaa, that's how the auto_increment id problem is solved. > > > > I wonder why they can't do something like Access with its > > Replicati

Re: replace ... select (why showing duplicates?)

At 10:02 -0800 12/30/02, Qunfeng Dong wrote: Hi, When I do "replace table2 select (cols) table1 where clause" to update some records in the table2, sometimes I got the something like following indicating Duplicates records being detected. --- Query

Re: replication

Bah. sql, query, queries, smallint In the last episode (Dec 30), Rick Faircloth said: > Aaaa, that's how the auto_increment id problem is solved. > > I wonder why they can't do something like Access with its > ReplicationID or whatever it's called... Access just used a random 32-bit integer,

Pattern Match on 3.23

I would like to use pattern matching as a substitute to fulltext search on MySQL 3.23. Is this a good alternative? Are there any limits, like not being able to perform a pattern match on a 'text' field, etc., that I need to be aware of? Thanks.

mySQL Performance Assistance

Hello, I have noticed that my server running mysql-3.23.45 on Solaris 8/400MHz sparc/1GB ram system appears to be only using up swap space and not free memory. During light usage this doesn't seem to be a problem but under heavy usage this causes my cpu to hit 90 - 100% at times. Even with n

Re: indexing a blob

Hi. On Mon 2002-12-30 at 16:53:08 -0500, [EMAIL PROTECTED] wrote: [...] > hashsum tinyblob not null , # hash of the card: have we seen this one? > index (hashsum) # for quick lookups > > Whenever I try this with the index, I get > > ERROR 1170 at line 49: BLOB column 'h

Re: indexing a blob

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all -- ...and then David T-G said... % ... % hashsum tinyblob not null , # hash of the card: have we seen this one? % index (hashsum) # for quick lookups ... % ERROR 1170 at line 49: BLOB column 'hash' used in key specif

Re: altering data structure

Hi again. On Sun 2002-12-29 at 15:21:33 -0500, [EMAIL PROTECTED] wrote: > ...and then Benjamin Pflugmann said... [...] > % Of course, that's only possible if you can live with being > % MySQL-specific. > > Hmmm... so it's a mysql thing and not a SQL thing. Well, I'd like to > avoid that, even t

Re: replication

On Mon, Dec 30, 2002 at 05:45:07PM -0500, Rick Faircloth wrote: > Aaaa, that's how the auto_increment id problem is solved. > > I wonder why they can't do something like Access with its ReplicationID > or whatever it's called... They can (and probably will) but it's all a matter of developmen

Re: ensuring an instructor, client, or room isn't double-booked

Hi David. On Sun 2002-12-29 at 16:21:56 -0500, [EMAIL PROTECTED] wrote: > ...and then Benjamin Pflugmann said... [...] > No; everything is one hour. Two hours is two bookings. Ah. Good. That makes the case easier and is exactly the case my last answer was about. [...] > % know beforehand when

RE: Binary Data and BLOB Problem

Hi Kevin; You may want to look at the online article I wrote at http://www.dynamergy.com/mike/articles/blobaccessvb.html which covers use of the stream object in detail. While written for VB, it should be easy enough to convert to ASP. Mike Hillyer -Original Message- From: Kevin Wix

Sanity on restore

Moving a server (RH6.2 w/ 3.23.43) to a temporary system (RH7.3 w/ 3.23.49-3) and I have a mysql dump file created using: mysqldump -A my-move.sql Just installed the server rpm on the temp system and any attempt to connect gives error because of a password, guessing that's because I've got a bl

Re: indexing a blob

On 30 Dec 2002, at 16:53, David T-G wrote: > I don't know where the key length needs to be specified; I tried > > hashsum tinyblob(255) not null > > but that puked at the create stage :-) The prefix length goes with the index definition, not the column definition. See http://www.mysql.com/d

RE: indexing a blob

http://www.mysql.com/doc/en/CREATE_INDEX.html you key needs a length, not your field. index (hashsum(length)) # for quick lookups -Original Message- From: David T-G [mailto:[EMAIL PROTECTED]] Sent: Monday, December 30, 2002 1:53 PM To: mysql users Subject: indexing a blob -

Re: indexing a blob

On Mon, Dec 30, 2002 at 04:53:08PM -0500, David T-G wrote: > > Hi, all -- > > Having learned a bit about indexes, I have tried to practice a bit. So > far things work for my char(20) fields, but I have a problem with a > tinyblob. To wit: > > create table ccards > ( > # ID number >

Re: Replication priority / speed

In the last episode (Dec 30), Matt Sturtz said: > Hello, Jeremy, et al-- Thanks for the reply before... Further questions: > >> Is it possible to set either set the priority ('nice') of the > >> Slave thread down so it doesn't do that? > > > > The slave thread only? No, not really. You could ni

Privileges in MySQL 4.0.7 (upgrade)

Dear list, just upgraded from MySQL 4.0.3 to 4.0.7 on my Win2K box at home. Leaving DATADIR as it was, the 4.0.7 installation did not touch the privilege tables in the mysql database, so I did not have the new privileges and features available. As there doesn't seem to be a mysql_fix_privilege_ta

Upgrade to MySQL 4.0.x

Hi people, I have a few questions about whether or not i should upgrade to MySQL 4.0.7-Gamma on my Windows XP system. I am now running MySQL 3.23.54a on my Laptop. Its used for developing/testing, and the applications needs to be transported to the final server after completion. Most of the tim

duplicate entry on key 1

Help! I have a problem with a database which gives a "duplicate entry on key 1" error message when I try to re-add a record that I have just deleted. I have a feeling it has to do with my index.. my key column is shown like this in the create statement: Create table 'mydb' ( 'MyKeyField' v

Re: front ends?

On Monday, December 30, 2002, at 03:42 PM, Richard Nagle wrote: what would be the easy to use, gui front end for mySQL 3.23.53 (for Mac OS X ) I use phpmyadmin on Mac OS X (and OS X Server), with absolutely no problems. -- Chris Garaffa <[EMAIL PROTECTED]> http://m

RE: replication

Aaaa, that's how the auto_increment id problem is solved. I wonder why they can't do something like Access with its ReplicationID or whatever it's called... Rick -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Monday, December 30, 2002 4:52 PM To: Rick Faircl

Re: Replication priority / speed

>>> Or, alternatly, is there a way to limit the slave thread to only "X" >>> bin-log transactions per second? >> >> There is not. > > Any plan to add this feature? I would think it'd be useful... Wouldn't it be better to *solve* your problem instead of going around it? > MyTOP says our key effic

Re: replication

On Mon, Dec 30, 2002 at 12:15:49PM -0500, Rick Faircloth wrote: > Hi, Jeremy. > > What if one is the master and one is a slave, but both are used in > production environments? That's safe. It avoids the problem. > Is it possible for a slave to be used as a live production database > or is it si

indexing a blob

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all -- Having learned a bit about indexes, I have tried to practice a bit. So far things work for my char(20) fields, but I have a problem with a tinyblob. To wit: create table ccards ( # ID number id smallint not null default 0 aut

replication problems

We have two users, lets call them test and test2. When we log in as test from our front end web servers, we can execute queries and they replicate. When we log in as test from our back end db servers (say to run a cleanup script by hand), the queries replicate. When we log in as test2 from our

Re: Replication priority / speed

On Mon, Dec 30, 2002 at 03:48:30PM -0600, Dan Nelson wrote: > In the last episode (Dec 30), Matt Sturtz said: > > Hello, Jeremy, et al-- Thanks for the reply before... Further questions: > > >> Is it possible to set either set the priority ('nice') of the > > >> Slave thread down so it doesn't do

Re: style question: "drop database" in an install script

Arthur, et al -- ...and then Arthur Fuller said... % % I don't know about anyone else, but for this sort of thing I love the % program called DeZign, which is a data-modeling tool. You can "draw" your % tables and their columns and set up relations and so on. DeZign will then % write your code fo

Re: Replication priority / speed

On Mon, Dec 30, 2002 at 01:21:49PM -0700, Matt Sturtz wrote: > Hello, Jeremy, et al-- Thanks for the reply before... Further questions: > > > >> Is it possible to set either set the priority ('nice') of the Slave > >> thread down so it doesn't do that? > > > > The slave thread only? No, not re

Re: replication

On Mon, Dec 30, 2002 at 02:55:19PM -0500, Arthur Fuller wrote: > > Is there in *nix an implementation of GUIDs? If the MS math is too > be believed, GUIDs are guaranteed unique for the next century. No > matter how many monkeys are at the typewriters. Supposing a) that > there is a *nix GUID implem

Re: An Idea

Peter, > So (taking a deep breath !) I would be prepared to lay the foundations for a > faq / knowledge base aimed specifically at this type of questions and to > manage it. Thanks, I appreciate that. I've been waiting a moment before answering, waiting for others to take a deep breath and say "y

Re: MySQL 4.0.7 is released

In article <[EMAIL PROTECTED]>, Andreas <[EMAIL PROTECTED]> wrote: >Hsiao Ketung Contr 61 CS/SCBN wrote: > >> Who would have the need to use src version of installation. >> I imagine that src version give user more options for customizing MySql. > >sure ... but do you feel anythig lacking ? I kno

front ends?

what would be the easy to use, gui front end for mySQL 3.23.53 (for Mac OS X ) Thanks Again, Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

manual for 3.23.53 pdf?

looking for a pdf manual for mysql 3.23.53 anyone? Thanks- Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread,

mysqlgui, win32, delete keypress on table row in results window hangs.

Using: Win32 static binary of MySQLGUI 1.7.5-2 on win98SE Mysql 4.04-beta serving on win2000 run MySQLgui select * from test; displays table correctly in mysql results window -click-select a row in the MySQL results display -press the delete key (intent is to delete that row) -hang,

COUNT() two tables

Hello, I have been unable to get a better result than the multiplication of 2 tables where I want the addition. I explain : 3 tables, one for genre, one for html and one for shockwave html and shockwave have foreign key genreID I want to count how many html and shockwave entries have the same genr

Re: Replication priority / speed

Hello, Jeremy, et al-- Thanks for the reply before... Further questions: >> Is it possible to set either set the priority ('nice') of the Slave >> thread down so it doesn't do that? > > The slave thread only? No, not really. You could nice MySQL when you > start it up. But I'm not sure how m

RE: Trying to find a .zip binary install for Windows 2000 for 4.0.7 gamma

At 11:41 30/12/2002 -0600, Cal Evans wrote: Is there a problem with your mail server or do you keep re-sending this message? If the latter, please stop. Those that have read the message do not have an answer. Continuing to spam this overloaded list with the same request will simply make those who

duplicate entry on key 1

Help! I have a newbie question. I have a problem with a database which gives a "duplicate entry on key 1" error message when I do a select on a record that I have just deleted. my key column is shown like this in the create statement: Create table 'mydb' ( 'MyKeyField' varchar(30) def

Re: replication

Is there in *nix an implementation of GUIDs? If the MS math is too be believed, GUIDs are guaranteed unique for the next century. No matter how many monkeys are at the typewriters. Supposing a) that there is a *nix GUID implementation, what's the right column type to use within MyISAM and InnoDB? A

Re: query requiring two results from one table?

select g.gameid, g.homeid, h.name, g.awayid, a.name, g.datetime from Games g, Teams h, Teams a where g.datetime > @min_dt and g.datetime < @max_dt and h.teamid = g.homeid and a.teamid = g.awayid On Mon, 30 Dec 2002 11:29:45 -0600, <[EMAIL PROTECTED]> wrote: Hello, This is my first post to th

Embedded MySQL

Hi, Since libmysqld don't use sockets or TCP/IP, what's the mechanism it uses when client and server communicate with each other? Thanks for reply in advance. Regards. -- ___ Get your free email from http://mymail.mailasia.com Powered by Outblaze -

replace ... select (why showing duplicates?)

Hi, When I do "replace table2 select (cols) table1 where clause" to update some records in the table2, sometimes I got the something like following indicating Duplicates records being detected. --- Query OK, 122259 rows affected (1 min 18.28 sec)

Re: NPTL and MySQL

On Sun, Dec 29, 2002 at 01:52:34PM +0100, Richard Pijnenburg wrote: > It seems that no one has answered yet. > Does any one know some thing about it? I've not seen much information about NPTL and MySQL. There are brief discussions now and then but nothing substantial--mostly speculation or "someo

RE: Trying to find a .zip binary install for Windows 2000 for 4.0.7 gamma

Is there a problem with your mail server or do you keep re-sending this message? If the latter, please stop. Those that have read the message do not have an answer. Continuing to spam this overloaded list with the same request will simply make those who may know the answer less likely to help you.

RE: query requiring two results from one table?

Thanks Matthew. that works perfectly. I totally forgot you can just select the table twice. thanks for the quick response. gf "Matthew Smith" <[EMAIL PROTECTED]> 12/30/2002 11:34 AM Please respond to msmith To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> cc: Subje

RE: query requiring two results from one table?

Your structure is flawed for this kind of query. Games should be: Games --- gameID === teamID (FK to teams) dateTime (datetime) homeAwayFlag char(1) // either H or A --- This way you could use something like select g.gameid, g.teamID, g.homeAwayFlag, g.dateTime,

RE: query requiring two results from one table?

Hi, Your query will need to look like: select G.datetime, A.name, B.name from Games as G, Teams as A, Teams as B where A.teamid = G.homeid and B.teamid = G.awayid and G.datetime < ? and G.datetime > ? order by G.datetime would be a good place to start Regards M -O

Re: nested transactions?

Thad, - Original Message - From: "Thad Humphries" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, December 30, 2002 4:09 PM Subject: nested transactions? > Any word when/if MySQL might support nested transactions? I have a large > Oracle ESQL application (36K lines)

query requiring two results from one table?

Hello, This is my first post to the list, so if I am asking in the wrong place, I apologize. I've got some trouble putting together a query with the following tables Games: Teams: gameid teamid homeid name awayid datetime i want to get all games within a certain time

Binary Data and BLOB Problem

Having trouble with my first MySQL database. I want to upload and install image files to a database for online sample photo gallery for our customers. The system I've created so far sometimes works, sometimes doesn't. It seems to depend on the size of the file being uploaded, but tests have be

MySQL 3.23 compile error on HPUX IPF

Hi, I am trying to compile MySQL 3.23 on HPUX 11.23 IPF. I am using gcc 3.0. gcc 2.95 is not available on HPUX 11.23. CC=gcc \ CXX=g++ \ CFLAGS="-D_HPUX_SOURCE -D__hpux__ -D_REENTRANT" \ CXXFLAGS="-D_HPUX_SOURCE -D__hpux__ -D_REENTRANT" \ CPPFLAGS="-D_HPUX_SOURCE -D__hpux__ -D_REENTRANT" \ LDFL

RE: replication

Hi, Jeremy. What if one is the master and one is a slave, but both are used in production environments? Is it possible for a slave to be used as a live production database or is it simply for backup? If they can both be used as live production databases, how can they be synced with replication?

RE: Update syntax

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#UPD ATE Last line in 6.4.5 =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Jim Racster [mailto:[EMAIL PROTECTED]] Sent: Monday, December 30, 2002 10:06 AM To: '[EMAIL PROTE

Trying to find a .zip binary install for Windows 2000 for 4.0.7 gamma

I couldn't locate a .zip binary version for Windows 2000 installation. All I saw was the source installation: Cygwin 1.3.9 Source Download (tar.bz2) located at http://www.mysql.com/downloads/mysql-max-4.0.html Did I miss it somewhere? I would like to get a .zip file that contains the standard s

query requiring two results from one table?

Hello, This is my first post to the list, so if I am asking in the wrong place, I apologize. I've got some trouble putting together a query with the following tables Games: Teams: gameid teamid homeid name awayid datetime i want to get all games within a certain time

Re: seagate crystal reports with mysql

Yes you can. There are a few changes you have to make to the registry to get it to work. Let me know off list if you need any more help. We use mysql as our databse and Crystal Reports as our reporting engine. Scott Pippin [EMAIL PROTECTED] >>> geeta varu <[EMAIL PROTECTED]> 12/28/02 03:16AM

Trying to locate a .zip binary installation for Windows 2000 for 4.0.7 gamma

I couldn't locate a .zip binary version for Windows 2000 installation. All I saw was the source installation: Cygwin 1.3.9 Source Download (tar.bz2) located at http://www.mysql.com/downloads/mysql-max-4.0.html Did I miss it somewhere? I would like to get a .zip file that contains the standard s

Converting signed and unsigned integers

All, I have a table which includes IP addresses converted from dotted quads to signed integers using PHP's ip2long() function. To greatly simplify some of my code, I want to convert these signed integers to IP addresses on my MySQL server. The problem I'm up against is that PHP's ip2long uses

Update syntax

Hi All, With a database that contains tables PetInv and Purchases: mysql> update PetInv -> set PetInv.Qty = PetInv.Qty + Purchases.Qty -> where PetInv.ItemNo = Purchases.ItemNo; ERROR 1109: Unknown table 'Purchases' in where clause As you can see I'm trying to add purchase quantitie

Trying to locate a zip binary Windows installation for 4.0.7 Gamma

I couldn't locate a .zip binary version for Windows 2000 installation. All I saw was the source installation: Cygwin 1.3.9 Source Download (tar.bz2) located at http://www.mysql.com/downloads/mysql-max-4.0.html Did I miss it somewhere? I would like to get a .zip file that contains the standard

Re: replication

On Mon, Dec 30, 2002 at 08:37:13AM +0100, Maxime LEMAIRE wrote: > Hi, > > I would like to know how mySQL manage the identity (auto increment > counter) in a replication environment when 2 servers are both master > on the same database. In that situation, you really need to generate your own prima

Is it a bug?

Hi, I have installed mysql max 4.0.4 beta on a Suse (ver. 8.0) linux server and I have created a database with this schema: CREATE TABLE ecoras ( rsnum tinyint(4) NOT NULL, rsori tinyint(1) NOT NULL, rscod int(11) NOT NULL, rsid int(11) NOT NULL auto_increment, rsdat date NOT NULL defa

Trying to locate a binary install .zip file for 4.0.7 for Windows 2000 installation

I couldn't locate a .zip binary version for Windows 2000 installation. All I saw was the source installation: Cygwin 1.3.9 Source Download (tar.bz2) located at http://www.mysql.com/downloads/mysql-max-4.0.html Did I miss it somewhere? I would like to get a .zip file that contains the standard

RE: style question: "drop database" in an install script

I don't know about anyone else, but for this sort of thing I love the program called DeZign, which is a data-modeling tool. You can "draw" your tables and their columns and set up relations and so on. DeZign will then write your code for you. Personally, I like to keep all my "drop" statements in

Re: Optimizing

Hi What else is running on the machine ? What processes are using the computers resources ? Use top to find out. What are the memory parameters used in my.cnf ? The answers to these questions will provide some helpfull answers to your problem. Simon On Monday 30 Dec 2002 11:16 am, BPF Webmas

Optimizing

I migrated my site from a low end PC mutualized hosting to a brand new P3 1GHz 512M server I now manage myself. Unfortunately I found MySQL slower now, the time for a PHP page is now about 6 seconds and was about .6 before!!! I haven't done any optimization and the DB is the same, so the size (ab

Re[2]: temporary and merge tables

Hi, sorry, didn't look at the changelog... ;) thanks! corin Monday, December 30, 2002, 9:29:12 AM, you wrote: PD> At 9:01 +0100 12/30/02, Webmaster (Corin Langosch) wrote: >>Hi, >> >>when trying to create a temporary table of type merge, mysql >>2.23.53 fails with an error like this: >>Can't fin

Re: Fulltext search: Is there a way to disable the stop words?

Hi! On Dec 28, John Porter Simons wrote: > > Any system variables I could set, or any parameters I could add to MATCH > ... AGAINST query syntax, or any plans to disable stopwords for boolean > fulltext searches in future builds? The answer to the last question is "yes, definitely", to others

Re: mysqld_safe

At 16:18 +0800 12/30/02, ecteo wrote: when I try to start MySQL 4.0.7 in Red Hat Linux 8 by issuing mysqld_safe then a line of msg appear starting mysqld deamon with database from /var/lib/mysql then the screen stay unchange, and it does not come back to shell -> [abc]# Does it normal

Re: temporary and merge tables

At 9:01 +0100 12/30/02, Webmaster (Corin Langosch) wrote: Hi, when trying to create a temporary table of type merge, mysql 2.23.53 fails with an error like this: Can't find file: '#sql24b_776_0.MRG' (errno: 2) when not using the temporary keyword, everything works fine. so i assume this is a mis

mysqld_safe

when I try to start MySQL 4.0.7 in Red Hat Linux 8 by issuing mysqld_safe then a line of msg appear starting mysqld deamon with database from /var/lib/mysql then the screen stay unchange, and it does not come back to shell -> [abc]# Does it normal or problem? TIA. --

temporary and merge tables

Hi, when trying to create a temporary table of type merge, mysql 2.23.53 fails with an error like this: Can't find file: '#sql24b_776_0.MRG' (errno: 2) when not using the temporary keyword, everything works fine. so i assume this is a missing feature (not documented that this is forbidden/not sup