RE: undefined function: mysql_connect()

2002-04-26 Thread Brian P Austin
Are you using MySQL 4.x sumthing? I thought that function was taken out and replaced with mysql_real_connect()? I may be wrong. -Original Message- From: Julie Meloni [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 10:35 AM To: Tewfic Kidess Cc: [EMAIL PROTECTED] Subject: Re:

MySQL 3.23.49 Installation - password problems

2002-04-02 Thread Lee P Reilly
Hi, I just installed MySQL 3.23.49 on NT and executed the following commands: UPDATE USER SET password=password(test1) WHERE host=localhost; UPDATE USER SET password=password(test1) WHERE host=%; Now, after doing 'mysqladmin reload', I cannot connect... mysql -p Enter password

PHP/MySQL application - how to schedule server processes?

2002-03-12 Thread Lee P Reilly
is complete, the user will have access to the a results folder in the system containing a list of their submitted analysis (either pending or complete). Can anyone offer any advice/suggestions on how this can be accomplished? Thank you very much for your time. - Best regards, Lee Reilly -- Lee P. Reilly

passing Mysql handler to the exec'ed child

2002-03-11 Thread Murali P
Hi , My aim is to avoid mysql connects to the DB my application does not run as a daemon . But the parent of this program runs as a daemon , so can someone tell me how I would make use of the same Mysql handler in the execed child also assuming I connect to the Mysql Server in the parent ?

Re: using LOAD DATA INFILE with dbexport from informix

2002-03-08 Thread Brian P. Millett
On Fri, 2002-03-08 at 14:19, [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and

Re: mysql on redhat instalation problem

2002-02-26 Thread Brian P. Austin
Hello, You probably need to check the permissions for the directory that mysql is trying to create the databases in. Make sure mysql has write permissions in the directory. then run mysql_install_db again and you should be ready to go. - Original Message - From: jake williamson 28

insert select in ONE statement?

2002-02-20 Thread Lee P Reilly
Hi, I wonder if anyone can offer me some advice with this one: I have a table called 'iq_data' holding just a primary key and a field called 'iq_data'. +++--+-+-++ | Field | Type | Null | Key | Default | Extra |

RPMS for Development Branch

2002-02-18 Thread Brian P. Austin
. such requests should be sent to [EMAIL PROTECTED] I did this in hopes of making things easier for people (and myself) who want to try the new stuff out without downloading and compiling themselves. Have fun. Brian P. Austin query, mysql, server

RE: RPMS for Development Branch

2002-02-18 Thread Brian P. Austin
http://www.linuxmonsters.com sorry about that -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 3:41 PM To: 'Brian P. Austin' Cc: mysql Subject: RE: RPMS for Development Branch and the URL is??? it's not www.codemonsters.net; I just

question on mysql benchmarking

2002-02-13 Thread P Zhao
Hi, When I run perl run-all-tests --server=mysql --cmp=mysql,pg,solid --user=test --password=test --log in the sql-bench direcotory. I encountered following error messages: Can't locate DBI.pm in @INC (@INC contains: /usr/lib/perl5/5.6.0/ia64-linux /usr/lib/perl5/5.6.0

RE: Request for help in testing new replication code in 4.0.2

2002-02-13 Thread Brian P. Austin
I have finished a script that takes the bit keeper sources and makes MySQL-4.0.2 RPMS for Redhat 6.x and apparently 7.X as well. I can put these up on our site for download if you want. They might get others trying the code out. I use the spec file included with the source code. I'll put it up

RE: Using password: _No_

2002-02-13 Thread Brian P. Austin
what command are you issuing. is it mysql? If so, what arguments are you sending it? It should look like this mysql -u user -p prompt: password -Original Message- From: Cliff [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 9:18 PM To: [EMAIL PROTECTED] Subject: Using

SELECT DISTINCT BINARY crashes mysql on null values

2002-01-29 Thread mysql-s-p-a-m
Description: Executing a SELECT DISTINCT statement in conjunction with the BINARY cast operator will crash MySQL server when the column being cast contains one or more null values. How-To-Repeat: Executing the following code from a mysql prompt will cause the MySQL server to

Compile failure with dev branch

2002-01-22 Thread Brian P. Austin
When using the BUILD/compile-pentium and BUILD/compile-pentium-pgcc I get the following errors.. /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int

prob on NT

2002-01-21 Thread e c h o p l u s A T w o r k
Hi, I've a problem in order to install Mysql server 3.23.47 on NT 4 box when I try to run the file setup.exe, I get an error msg like this: *I can't run a 16 bit program the file setup.exe is damage. Try to reinstall* (!?!?!?) I've never seen this error ... anyone can help me in order

Re: prob on NT

2002-01-21 Thread e c h o p l u s A T w o r k
Hi Victoria, echoplusAT *I can't run a 16 bit program the file setup.exe is damage. Try to echoplusAT reinstall* (!?!?!?) echoplusAT I've never seen this error ... anyone can help me in order to solve this echoplusAT prob? May be you have a corrupted installation package. Try to

Altering InnoDB tables

2002-01-14 Thread Robert P Ricci
constraints in its table creation commands. Is there any way to retrieve these? -- /--- | Robert P Ricci [EMAIL PROTECTED] || [EMAIL PROTECTED] | Research Associate, University of Utah Flux Group | www.cs.utah.edu/flux || www.emulab.net

Re: Altering InnoDB tables

2002-01-14 Thread Robert P Ricci
, that's causing you trouble. Luckily, in my case, our database is sufficiently small (on the order of tens of thousands of rows spread out across ~50 tables) that this isn't really an issue. -- /--- | Robert P Ricci [EMAIL PROTECTED

maximum heap table size allowed

2001-12-28 Thread Banach, Timothy P
Hello, Can anyone tell me if the maximum table sizes given in Section 1.2.4 of the documentation apply equally to HEAP tables in v. 4.0? Or, rather, if memory and address space were unlimited, how large could a heap table possibly be in v. 4.0? TIA Tim Banach State Street

maximum heap table size

2001-12-27 Thread Banach, Timothy P
Hello, Can anyone tell me if the maximum table sizes given in Section 1.2.4 of the documentation also apply to HEAP tables in v. 4.0? Or, rather, if memory and address space were unlimited, how large could a heap table possibly be in v. 4.0? TIA Tim Banach State Street Corporation Westwood,

RE: SELECT HELP

2001-12-18 Thread P
I believe you could use CONCAT(firstname, ' ', lastname) LIKE '%$searchname%' if you leave the space out of the middle it probably won't work, and you might want to trim firstname lastname to make sure no leading or trailing spaces exist. Hope this helps, P -Original Message- From

mySQL in-memory configuration

2001-12-03 Thread Banach, Timothy P
Hello, Can mySQL be configured to run entirely in-memory? That is, can one configure it so that all the tables, data, etc. remain resident in memory and are never written to disk? TIA, Tim Banach - Before posting, please

Changing the socket location?

2001-12-01 Thread Stephen P Toothman
I was wondering is there anyway to change the socket location from /tmp/mysql.sock to something else, other than recompiling :-)? If there is not I would like to highly recommend it as an option. TIA stevet _ Do You Yahoo!? Get your

Re: MySQL, Red Hat Linux and php

2001-11-30 Thread Brian P. Austin
If you are using the MySQL RPMS for RedHat, They install in the /usr directory. (Redhat dows things differently) So it would be ./configure --with-mysql=/usr for PHP compilation. as far as upgrading... I have used RedHat for a long time, and have found that in their newest distos, it is

Re: MySQL, Red Hat Linux and php

2001-11-29 Thread Brian P. Austin
The RPMS that are available from the MySQL WebSite are OK to use on 6.2. I personnaly prefer to use the source or .src RPMS. But the RPMS work fine on my 6.2 box. [EMAIL PROTECTED] wrote: Hello, Which version of MySQL ( RPM packages ) is good for work with php 4.0.6 and Linux Red Hat 6.2 ?

Could mysql count the datatraffic of DB's posted queries?

2001-11-27 Thread p-markovic
Hi all, I'm looking for a posibility to count the datatraffic of a database at my mysqldb-server. The clients should got only select-rights on thier databases. And I need to count the resultset datatraffic of their select-queries. I'm using mysql version 3.23.39. I was looking for some

Fw: Could mysql count the datatraffic of DB's posted queries?

2001-11-27 Thread p-markovic
SHOW STATUS will give you an indication on how much traffic is moved between your server and the clients (look for bytes sent and bytes received) - but only the totals for the server are displayed. I very much doubt you can get the data by client or connection. I'm curious as to *why*

Problem invoking mysqld on Win 98

2001-11-24 Thread P Gadey
Hi, I am new to MySQL. I installed it on Win 98 and trying to invoke the mysqld. First it gave me a strange error that innodb_data_file_path is not found. I copied the following from manual (I dont really want to create such 2GB files though !).

Re: mysql.sock deletes itself on Solaris

2001-11-02 Thread Brian P. Austin
mysql, query, server there is probably a cron job or sumptin that is deleting your sock file. Try putting it in a different place. [EMAIL PROTECTED] wrote: Description: /tmp/mysql.sock is there and then apparently randomly its removed without warning.. mysql still accepts TCP connections

Re: mysql.sock ???

2001-10-29 Thread Brian P. Austin
on Freebsd system but when i launch mysql i said me can't connect to localhost /tmp/mysql.sock not found. How can i repair this error? First, you can refrain from posting the same question twice. Second, you can RTFM before posting - specifically, http://www.mysql.com/doc/P/r

replication implementation.

2001-09-27 Thread Kamesh P S
Hi anybody, am a newbie to mysql and i want to install master/slave mysql server for replication. can anybody please desc from the scratch (user rights) of configuring 2 mysql servers in master/slave fashion for replicatiom. thanx in advance. bye kamesh

Question about mysql server Installation

2001-09-25 Thread p lakshman
Dear Anyone I am one of the Linux user. I use the freebsd operating system. I have one main problem. After installation completed , I put the command mysql in #prompt. But some error message will shows, I don't know how to solve it. The Error message is

user creation in mysql

2001-09-22 Thread Kamesh P S
me too facing the problem in creating users and granting permission please help me Hi, We are facing problem with mysql on linux. We are unable to give the password for admin user. Can you please give all the list for installation and user creation as well as for uninstalling? Thanks,

Re: FULLTEXT search with hyphens in data

2001-09-04 Thread Vadim P.
Just a thought - if your serial numbers have fixed format, then programmatically remove the hyphen and store the number without it. Add it back when displaying data on the screen. That way FULLTEXT will work on the whole number without splitting it into two parts. Vadim. Marty McCoy wrote:

Re: Looks like any user can read the mysql db!

2001-08-15 Thread Vadim P.
Jose-- Are you running mysqld as 'root'? Run it as 'mysql' and change the group membership of the data directory and its contents to 'mysql'. Vadim. Jose de Leon wrote: Here are the perms on the mysql db files /var/lib/mysql/mysql Also, I was logged into mysql with a plain user 'jose'

Embedding MySQL in an application

2001-08-09 Thread Shawn P. Garbett
I have been told it is possible to embed MySQL in an application such that the user never knows a database is running underneath the app. Where can I find more information about doing this? -- Shawn P. Garbett [EMAIL PROTECTED] See http://www.garbett.org/public-key for my PGP key

Fwd: Re: Embedding MySQL in an application

2001-08-09 Thread Shawn P. Garbett
as part of the next release. Problem is I have to demonstrate it NOW, or I may end up stuck with MSDE since it exists NOW. MySQL is my preferred option and I'd love to stick with it across all platforms the product will be ported to. -- Shawn P. Garbett [EMAIL PROTECTED] See http

Fwd: Re: Fwd: Re: Embedding MySQL in an application

2001-08-09 Thread Shawn P. Garbett
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Freakin' Spam filter!!! - -- Forwarded Message -- Subject: Re: Fwd: Re: Embedding MySQL in an application Date: 9 Aug 2001 14:07:44 - From: [EMAIL PROTECTED] To: Shawn P. Garbett [EMAIL PROTECTED] Your message cannot

Re: Embedding MySQL in an application

2001-08-09 Thread Brian P. Austin
Austin On Thu, 9 Aug 2001, Alex Page wrote: From: Shawn P. Garbett [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 3:07 PM Subject: Fwd: Re: Embedding MySQL in an application The real point is, that a user can take the product out of shrink rap, install it, run the program and never

mysql+gemini compile errors

2001-08-07 Thread Brian P. Millett
Hello, SunOS shaka 5.8 Generic_108529-08 i86pc i386 i86pc gcc version 2.95.3 20010315 (release) I'm trying to compile mysql+gemini-3.23.39 on a x86 Solaris 8 box. I get the following error which has me completly confussed: ctstset: Compile tstset.cc -- tstset.[c|s] -- tstset.o Assembler:

Re: RE : WELCOME to mysql@lists.mysql.com

2001-08-05 Thread Brian P. Austin
On Sun, 5 Aug 2001, SOHM Philippe wrote: Hi, I'd like to add a function MD5() to mysql with CREATE FUNCTION Someone can help me ? I know nothing in C Philippe That might be a problem if you wnat to compile in your own function. You might want to try a UDF instead. I don't use them

mes0501

2001-07-23 Thread Francisco A. P. Costa
-- Virus Warning Message (on tjintranet) Found virus TROJ_SIRCAM.A in file mes0501.xls.pif The file mes0501.xls.pif is moved to /var/tmp/virCOE0PgUxY. - Hi! How are you? I send you this file in order to have your advice

T_chamado06f

2001-07-23 Thread Francisco A. P. Costa
-- Virus Warning Message (on tjintranet) Found virus TROJ_SIRCAM.A in file T_chamado06f.xls.lnk The file T_chamado06f.xls.lnk can not be moved because /var/tmp/virSIA0zg7eo: No space left on device. - Hi! How are you?

01062001

2001-07-23 Thread Francisco A. P. Costa
-- Virus Warning Message (on tjintranet) Found virus TROJ_SIRCAM.A in file 01062001.xls.bat The file 01062001.xls.bat is moved to /var/tmp/virPKB0HQl_p. - Hi! How are you? I send you this file in order to have your

unix1

2001-07-23 Thread Francisco A. P. Costa
-- Virus Warning Message (on tjintranet) Found virus TROJ_SIRCAM.A in file unix1.zip.com The file unix1.zip.com is moved to /var/tmp/virANB0.nrHt. - Hi! How are you? I send you this file in order to have your advice

hi new to mysql

2001-07-12 Thread Kamesh P S
helo anybody there to help me for my project my project is on PERL and Mysql in Linux please say me the procedure to study those stuffs. thanx in advance __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail

mysqld as a library in 4.0

2001-07-06 Thread Brian P Austin
Has anyone seen any documentation for using mysqld as a library. I am building an embedded device on a machZ chipset, and I would really like to be able to use mysql for some internal querying of our data collection. I can get it to run (barely) as is, but need more room and memory for other

remote DB

2001-06-04 Thread p w
Hello, Can anyone tell me if the MySQL database has a defualt user ID and password? I am trying to access a remote DB with my application, but am experiencing difficulties. This may be because I need correct user access details. Are there such details, and if so, what are they please?

Dates not compared properly, part II

2001-06-01 Thread Christopher P. Lindsey
-- Forwarded message: From [EMAIL PROTECTED] Tue May 1 14:37:53 2001 Date: Tue, 1 May 2001 14:37:53 -0500 From: Christopher P. Lindsey [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Dates not compared properly? Message-ID: [EMAIL PROTECTED] Mime-Version: 1.0 Content-Type: text/plain; charset=us

Re: AIX segmentation fault with PHP, Apache and MySQL

2001-05-17 Thread Matthew P. Marino
: 1.3.19 actually, Matt :) I'm running .19 on both my Linux machine and the G4. And as far as I can remember, PHP4.0.4pl1 worked ok on 1.3.14, I was doing that for a while. Z On Thursday, May 17, 2001, at 08:59 AM, Matthew P. Marino wrote: Apache is up to 1.3.17 at least. I would update

Re: WHERE OR Syntax

2001-05-16 Thread Vadim P.
Put parentheses around the ..OR.. part (between WHERE and AND) - AND precedes OR so Also, use 'IN' instead of a series of 'OR' - this will make the query a lot faster. e.g. listings.Area IN ('19','24','25',...) Vadim. JD Daniels wrote: I have this query built from a web form. The form

Re: problem stopping mysqld

2001-05-15 Thread Matthew P. Marino
Well, if you really just want it stopped, the usual unix rule is to ps -ax | grep mysql, read the PIDs then kill -11 [PID] kill the safe_mysqld script first or it will restart the mysql daemon. EISSEN Charlie wrote: Hello, i'm running mysqld on darwin (mac os x client)...Start is good, but

Re: Help with MATCH AGAINST

2001-05-11 Thread Vadim P.
$SQL = SELECT * FROM cvtemplate WHERE employment_type = '$employment_type' AND location = '$location' AND related_discipline = '$related_discipline', MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST ('$keywords') AS score FROM cvtemplate HAVING score!=0 ORDER BY

Re: How long should sql-bench/run-all-tests take?

2001-05-10 Thread Vadim P.
Patrick-- yes, it might take hours, nothing wrong with your setup. Vadim. Patrick Goetz wrote: I recently installed MySQL 2.23.37 from the unstable Debian package on a dual-processor PII 350 w/ 128MB SDRAM running linux 2.4.2 For fun (since I've never tried running any of the

Re: Solaris Installation problems

2001-05-03 Thread Matthew P. Marino
I think I remember getting around it by installing binutils from the GNU site. That's generaly the problem with solaris. Open source is GNU centric, Solaris prior to 2.8 is definately NOT. EXT-Chung, Kenneth wrote: Thanks. I got the gtar from the download page. Now I have unpacked it

Re: max FULLTEXT index size?

2001-05-03 Thread Vadim P.
Sergei, I also have the same problem, but in my case the table size exceeds 2Gb, average record size being around 50Kb. I'm running 3.23.37 (i686) on a dual PIII 866/ 1Gb RAM / 36Mb SCSI RAID5 w/ RedHat 7.1 (kernel 2.4). As I type this message, MySQL is still [fulltext-] indexing one of the

Re: Database size

2001-05-03 Thread Vadim P.
Erik, You mentioned 40Gig files on Intel platform - what OS/DBMS did you use then? How about the performance? Thanks, Vadim. Terry Katz wrote: Erik, If your running Linux on an Intel machine (which I assume it is), then you've hit Linux's limit for IA32 and 2.2.x kernels .. If you want

Dates not compared properly?

2001-05-01 Thread Christopher P. Lindsey
Howdy all... I've run into a strange date problem as of midnight, May 1, 2001 on my i686 Linux machine running mySQL 3.23.37. For some reason, queries can no longer compare dates properly: mysql select count(*) from hit where date NOW()-1135560; +--+ | count(*) |

Re: MySQL compile error

2001-04-24 Thread Matthew P. Marino
You might want to try downloading binutils from the GNU web site. It has a modified version of the linker libraries (ld). I still wasn't able to get past the yacc compile even with 512MB RAM. Let me know how you make out. I ended up using the binary distribution. James Bonham wrote: Help me

2 errrors while executing make

2001-04-23 Thread Steven P. Kerscher
I have installed mysql 3.23.36 for the first time ever I did the test (ok) I ran the bench mark and could not load DBI I installed DBI 1.14 And Data Showtable 3.3 Then tried to install (Msql-Mysql-modules-1.2215) Perl Makefile.pl worked fine I run make and this is what it ends with: make[1]:

2 errrors while executing make

2001-04-23 Thread Steven P. Kerscher
I have installed mysql 3.23.36 for the first time ever I did the test (ok) I ran the bench mark and could not load DBI I installed DBI 1.14 And Data Showtable 3.3 Then tried to install (Msql-Mysql-modules-1.2215) Perl Makefile.pl worked fine I run make and this is what it ends with: make[1]:

Re: getting started...the hardest part

2001-04-18 Thread Matthew P. Marino
You've got a long way to go. "tar" is short for tape archive. It is an ancient unix utility that takes directory and file data and builds it into a contiguous data base file. This is for portability and manageability. You should have to get past "gzip" before you get to "tar". gzip is a gnu

Re: Someone give me suggestion please?

2001-04-10 Thread Matthew P. Marino
If your using "R"edhat, use "R"pm. Otherwise, use the tarball. David Loszewski wrote: is it recommended to install mysql by rpm or tar? dave - Before posting, please check: http://www.mysql.com/manual.php (the

Connection_from_Java

2001-03-31 Thread F P
Dear MySQL Team first of all, excuse my English. I’m from Argentina, I’m a java developer and use MySQL database. I connect to MySQL to Type4 Driver JDBC fron Java. I have one machine with Mysql server in port 3306 and another machine with an application in Java. I want to know how to start a

Re: Connection related SIG 11 crash in 3.23

2001-03-23 Thread vinod p
hey, i've been observing a similar kind of a problem with mysql 3.23.32 on a Linux 2.4.2 kernel. The backtrace that i'm getting is different, but even that fails a sanity check. When i resolved the incomplete backtrace, it showed me thread creation functions and something of that sort. The

Re: Mysql restarts at 100% CPU

2001-03-20 Thread vinod p
queries at that time. Tx. Vinod --- "Gerald L. Clark" [EMAIL PROTECTED] wrote: You have mysqld set for 2000 connections. How many threads do you have Linux configured for, and how many are open when Mysqld crashs? vinod p wrote: hi, thanks for the interest. The

Re: am I alone? (scale)

2001-03-18 Thread vinod p
hey.. thanks for the info... This is the my.cnf file that i'm using - [mysqld] skip-locking set-variable= key_buffer=640M set-variable= max_allowed_packet=10M set-variable= table_cache=640 set-variable= sort_buffer=6M set-variable= record_buffer=6M set-variable=

Mysql restarts at 100% CPU

2001-03-18 Thread vinod p
hi, my mysql server restarts automatically when the machine touches 100% CPU usage. any ideas why? tx. vinod. Do You Yahoo!? Get your free @yahoo.co.in address at http://mail.yahoo.co.in

Re: Mysql restarts at 100% CPU

2001-03-18 Thread vinod p
-variable= back_log=2900 set-variable= connect_timeout=15 set-variable= wait_timeout=57600 set-variable= interactive_timeout=57600 Tx. Vinod. --- "Jeremy D. Zawodny" [EMAIL PROTECTED] wrote: On Mon, Mar 19, 2001 at 12:34:30AM +0000, vinod p wrote: my mysql serve

Heavy Load

2001-03-17 Thread vinod p
hey, i'm running serveral mysql servers on powerful machines - dual processor, 2 GB memory, etc... Most of the databases store temporary data only. I need the maximum performance from these servers and have a lot of connections to the database. My problem is this - whenever the number of

a newbie question for myodbc

2001-03-11 Thread Hikmet P
Hi, I need mysql (under linux) tool's -q (--quick "don't cache result, print it row by row") in myodbc. How can I configure the myodbc?? I have been using MyODBC 2.50.36 and I'm connecting to MySQL Server at Linux (Red Hat 7.0 2.2.16-22) under MS Win98. Thanks. h.

Re: Re: Re: Re: Re: Antwort: Re: Antwort: Re: any ASP/ADO/MySQL programmers out there? (LONG answer)

2001-02-28 Thread Entryon Corp., Chief Technical Officer - P. Hasenfratz
Hey, I can't stop laughing anymore ( that has no ironical meaning!!! ) :) :) Good humor in this list, don't stop please :) Philipp - Original Message - From: "Jason Landry" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; "John Dean" [EMAIL PROTECTED] Cc: "Bob Hall" [EMAIL PROTECTED]; [EMAIL

replication error message question

2001-02-26 Thread John P . Looney
I have two mysql servers, setup to replicate each other. However, every so often, one or both starts logging; 010226 9:40:27 Slave thread: error connecting to master:Can't connect to MySQL server on '0' (11)(107), retry in 0 sec 010226 9:40:27 Slave thread: error connecting to

Compile fails on ha_berkeley.cc

2001-02-23 Thread Matthew P. Marino
Theres a long list of error messages following but the first is; ha_berekeley.cc:105: syntax error before ')' ..deleted for brevety... ha_berkeley.cc:297: warning! unreachable code at beginning of switch statement Just wondering if this looks familiar to anyone. We are using FreeBSD4, gcc

running safe_mysqld errors with 010222 17:25:00 mysqld ended

2001-02-22 Thread Matthew P. Marino
exact command is "./safe_mysqld --user=mysql ". The error "010222 17:25:00 mysqld ended" happens immediately. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: running safe_mysqld errors with 010222 17:25:00 mysqld ended

2001-02-22 Thread Matthew P. Marino
nd copying "mysqld" into it a viable option? Don't know what else to do. Peter Skipworth wrote: check your error log in ~mysql/var On Thu, 22 Feb 2001, Matthew P. Marino wrote: exact command is "./safe_mysqld --user=mysql ". The error "010222 17:25:00

So, what do you do with a tarball anyways.

2001-02-21 Thread Matthew P. Marino
So, what do you do with a "tarball" anyways. Since compiling the source is hopless( "sql_yacc.cc"), I'm looking for a binary. - Before posting, please check: http://www.mysql.com/manual.php (the manual)

So, just how long should it take the make install to run?

2001-02-20 Thread Matthew P. Marino
Don't laugh, Intel PI 166MHZ, 32MB RAM,10GB HD FreeBSD4 MySQL3.23.33 from .tar.gz distribution - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Linking MySQL with other programs

2001-02-19 Thread Neera P. Sood
Hello, I'm trying to compile and link MySql with a CORBA (ORBacus) client and I get the following error message: Undefined first referenced symbol in file __muldi3 /opt/mysql-3.23.32-sol8/lib/mysql/libmysqlclient.so

Microsoft clustering

2001-02-19 Thread P. L.
Hi, I would like to find out if the Win2000 version of mysql and myodbc support Win2000 clustering. Thanks, Sam __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/

user variables length

2001-02-15 Thread Entryon Corp., Chief Technical Officer - P. Hasenfratz
How many Bytes can I save in a user variable? Because I have the following strategy: I want to save all PrimaryKeys in a user variable SELECT @a:=' '; SELECT @a := CONCAT(@a, ', ', TPrimKey) FROM table WHERE condition; so it is very important to know how many bytes can be stored. regards

Unsatisfied symbols-mysql_init

2001-02-14 Thread Ragupathi P
hi, i recently downloaded mysql-3.23.32-hp-hpux10.20-hppa1.1.tar.gz , and tried writing a very simple code to start with . i just made a call to mysql_init() and mysql_connect() in the sample code . i used aCC ( version : aCC: HP ANSI C++ B3910B A.01.21) on a HPUX 10.2 machine

SV: Exporting data from MySQL to Oracle

2001-02-14 Thread P?l Wester
You could use mysqldump which makes CREATE/INSERT statements for mysql, and then you can change the mysql-spesific things like auto_icrement into making an sequence, etc. Oracle is SQL92 compliant and it would work i think. try it :o) mvh: P?l Wester, programmerer never.no as, stortingsgt 30

can I use aCC..

2001-02-14 Thread Ragupathi P
hi, basically i am reframing my earlier question. i'm using aCC ( ansic C++ compiler from HP ) on HPUX10.2 to compile and link my small C code with libraries available from mysql-3.23.32-hp-hpux10.20-hppa1.1 . i get the following: /usr/ccs/bin/ld: Unsatisfied symbols:

RE: Port 3306

2001-02-05 Thread johnny p.
your system... johnny p. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 2:46 PM To: Gus Constan Cc: [EMAIL PROTECTED] Subject: Re: Port 3306 What OS? If Linux or *BSD, they have firewall software (ipchains on linux, don't

Can't start as user 'mysql'

2001-01-26 Thread John P. Donaldson
I'm running Slackware Linux (2.0.36) and just set up a binary version of MySQL 3.23.32. I followed the directions exactly and all looks to be fine. However, when I try and start MySQL by using typing bin/safe_mysqld --user=mysql I get the following error: www:/usr/local/mysql# Starting

RE: Apache - MySQL - PHP (Auto-start Apache)

2001-01-25 Thread johnny p.
Yes, but does it get cleanly stopped when you shutdown? put the start command in /etc/rc.d/rc.local, fine, but I think there needs to be a kill link added to /etc/rc.d/rc.3 dir. I like the link from apachectl to /etc/rc.d/init.d/ idea: ln -s /usr/local/apache/bin/apachectl

<    1   2   3