Re: Can't connect err

2001-03-23 Thread Fred van Engen
Hi Chris, On Fri, Mar 23, 2001 at 06:21:48PM -0800, Chris Becker wrote: > > I installed MySQL on my RH6.2 intel box to the default directory specified > by the install /usr/local/mysql. After following the installation > instructions, I was able to perform the Post-Install test ok, the server >

Re: Stable version ??

2001-03-23 Thread Fred van Engen
Hi, On Fri, Mar 23, 2001 at 11:19:59PM -0500, Jocelyn Bernier wrote: > At 22:32 2001-03-23, G r e g L a w r i e wrote: > >Hmmm, I am not sure whether there are issues with this particular version of > >MySQL or not, but I would start looking at NT and the various bits and > >pieces that it inst

autocommit == innobase_flush_log_at_trx_commit ?

2001-03-23 Thread 유승훈
Hi, I have a newbie question. Is "autocommit == innobase_flush_log_at_trx_commit" ? Thanks. Ryu

Re: Bad optimization with two conditions?

2001-03-23 Thread Fred van Engen
Hi, On Fri, Mar 23, 2001 at 07:46:48PM +0100, Federico Giannici wrote: > We have a table where we register the data of all the modem connections > of the users of a small ISP. > > The table contains 2 million records and has the following structure: > ... What indexes does the table have? Loo

autocommit == innobase_flush_log_at_trx_commit ?

2001-03-23 Thread 유승훈
Hi, I have a newbie question. Is "autocommit == innobase_flush_log_at_trx_commit" ? Thanks. Ryu

RE: Stable version ??

2001-03-23 Thread Jocelyn Bernier
At 22:32 2001-03-23, G r e g L a w r i e wrote: >Hmmm, I am not sure whether there are issues with this particular version of >MySQL or not, but I would start looking at NT and the various bits and >pieces that it installs for memory leaks rather than MySQL. > >I have an NT server (same versions

RE: Stable version ??

2001-03-23 Thread G r e g L a w r i e
Hmmm, I am not sure whether there are issues with this particular version of MySQL or not, but I would start looking at NT and the various bits and pieces that it installs for memory leaks rather than MySQL. I have an NT server (same versions as yours) that I am not running MySQL on and it does t

Re: MySQL socket

2001-03-23 Thread Tym Rehm
You need to upgrade from the Standard RH7 rpms. They don't work. Download from www.mysql.com or www.redhat.com. - Original Message - From: "Diego Romoli" <[EMAIL PROTECTED]> Date: Friday, March 23, 2001 8:36 pm Subject: MySQL socket > Hi, I've just installed Apache, MySQL and PHP on R

RE: Mysql vs ....

2001-03-23 Thread Markus Gieppner
Hi Ciprian, Now you got a fairly large array of opinions, but I suggest to place the same question in one of the 300 MSSQL newsgroups. You'll see For my part, I believe that the excessive costs for everything starting with MS or Oracle, and the platform dependency of MSSQL are really excelle

Can't connect err

2001-03-23 Thread Chris Becker
Hi All, I installed MySQL on my RH6.2 intel box to the default directory specified by the install /usr/local/mysql. After following the installation instructions, I was able to perform the Post-Install test ok, the server started, I queried the test dbase, etc. 2 days post install I booted up

Uninstall

2001-03-23 Thread Chris Becker
I'm going to try an Un-Install, then Re-Install Mysql. How do I Un-Install?? Thanks, Chris B - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Re: HELP!!!

2001-03-23 Thread Daniel Adams
Yeah, I tried running myisamchk on it but it said it couldn't open the file. I'm going to try to restore the database from backup and update logs. >> Original Message << On 3/23/01, 7:04:51 PM, "Thalis A. Kalfigopoulos" <[EMAIL PROTECTED]> wrote regarding Re: H

MySQL socket

2001-03-23 Thread Diego Romoli
Hi, I've just installed Apache, MySQL and PHP on RedHat 7.0 and I can't connect to MySQL through PHP. I get an error saying that it can't connect to MySQL using socket /var/lib/mysql/mysql.sock. When I connect to the MySQL server through the mysql client program, I can see that that is the sock

Stable version ??

2001-03-23 Thread Jocelyn Bernier
Hi everybody, I am currently running MySQL 3.23.33 on a Windows NT 4 SP6. I need to restart it every day because the memory use rise during the day and never goes down. It looks like a memory link to me. Is version 3.23.35 still have this problem ??? __ Jocelyn Bernier

Re: Special Characters in INSERT Statement

2001-03-23 Thread Paul DuBois
At 5:30 PM -0500 3/23/01, Lee Jenkins wrote: >I apologize because I know I've seen this somewhere on the list before >(should have saved it). I'm trying to insert some data into CHAR fields >that have trailing Ascii 0 characters, but get a syntax error. > >The data would like this: > >23302220202

Re: create table error

2001-03-23 Thread Thalis A. Kalfigopoulos
On Fri, 23 Mar 2001, Daniel Adams wrote: > Can someone please tell me what the problem is below. All I am trying to > do is pipe a backup created with mysqldump into mysql and it gives me > this error: > > ERROR 1071 at line 1291: Specified key was too long. Max key length is > 500 It is exc

Uninstall

2001-03-23 Thread Chris Becker
I'm going to try an Un-Install, then Re-Install Mysql. How do I Un-Install?? Thanks, Chris B - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list ar

Re: Mysql vs ....

2001-03-23 Thread Tõnu Samuel
"Ciprian A." wrote: > I would need some reasons for choosing MySQL instead of Microsoft SQL. > (beside the fact that MySQL is free). (not for me but for my boss). > It may sound silly but trust me I really need these reasons. So please help > me with this. The biggest reason to avoid Microsoft p

Re: Q: How to recreate lost .MYI files

2001-03-23 Thread Carsten Gehling
From: "Peter Skipworth" <[EMAIL PROTECTED]> Sent: Friday, March 23, 2001 11:43 PM > Try copying your .MYD and .frm files to a directory and running 'restore > table [tablename] from '/this/directory' Thank you very much :-) - Carsten

Can't connect err

2001-03-23 Thread Chris Becker
Hi All, I installed MySQL on my RH6.2 intel box to the default directory specified by the install /usr/local/mysql. After following the installation instructions, I was able to perform the Post-Install test ok, the server started, I queried the test dbase, etc. 2 days post install I booted up t

Re: HELP!!!

2001-03-23 Thread Thalis A. Kalfigopoulos
Guessing: the error you are getting means: 126 = Index file is crashed / Wrong file format Would be nice to run a myisamchk on the table (check manual), and of course check that message.MYD exists under the corresponding database's directory. regards, thalis On Fri, 23 Mar 2001, Dan

RE: MySQL vs Microsoft SQL

2001-03-23 Thread Oson, Chris M.
For what it's worth, here's my $0.02... --> Is there something that you can do with MS SQL and you can not do with MySQL? MSSQL - has support for triggers, stored procedures, views, XML, and transactions. I would mention subqueries, but subqueries are on the way with mySQL. MySQL -

Re: HELP!!!

2001-03-23 Thread Jeremy D . Zawodny
On Fri, Mar 23, 2001 at 09:16:48PM +, Daniel Adams wrote: > Can anyone tell me how to fix this error: > > ERROR 1016: Can't open file: 'message.MYD'. (errno: 126) Fix the file permissions so that mysql can read the file. -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Fina

Re: MySQL vs Microsoft SQL

2001-03-23 Thread Jeremy D . Zawodny
On Fri, Mar 23, 2001 at 04:17:51PM -0500, Ciprian I. Acatrinei wrote: > > Is there something that you can do with MS SQL and you can not do > with MySQL? Yes. Probably lots of things. But if those don't matter to you, it's really not an issue. Said another way, if MySQL will meet your needs, wh

Re: MySQL vs Microsoft SQL

2001-03-23 Thread Colin Faber
A whole TODO list of things. One should really evaluate the pros and cons of both databases to make an educated decision on which system would better suit ones needs. "Ciprian I. Acatrinei" wrote: > > Is there something that you can do with MS SQL and you can not do with MySQL? > > At 04:01 PM

Can't get mysql to start

2001-03-23 Thread POT34
Hi there I'm sure that the solution to my problem will be easy but can you help. The following is a copy of my dos window having tried all of the ways to get mysqld to start running in the background. What am I doing wrong. I am using windows ME. Could this be the problem? Bad command or file n

Re: Mysql vs ....

2001-03-23 Thread roger westin
Start with the speed checkout: http://www.mysql.com/information/benchmarks.html there you'l find som arguments... /roger > *This message was transferred with a trial version of CommuniGate(tm) Pro* > > Hi, > I would need some reasons for choosing MySQL instead of Microsoft SQL. > (beside t

Re: Q: How to recreate lost .MYI files

2001-03-23 Thread Peter Skipworth
Try copying your .MYD and .frm files to a directory and running 'restore table [tablename] from '/this/directory' regards, P On Fri, 23 Mar 2001, Carsten Gehling wrote: > I have to MYISAM tables where I... ahem... have lost the corresponding .MYI > files. When I try to repair the tables, myis

RE:RTFM (was: *sigh* Re: Is it a bug? )

2001-03-23 Thread Cal Evans
Peter, I would love to see this list split into 2 lists. MySQL-Newbies and MySQL-non-newbies. Non-newbies would be either an invitation-only list or you have to pass a test to get in. (The test would contain questions that are all in the manual, we don't care if you know, we care if you will bot

Special Characters in INSERT Statement

2001-03-23 Thread Lee Jenkins
I apologize because I know I've seen this somewhere on the list before (should have saved it). I'm trying to insert some data into CHAR fields that have trailing Ascii 0 characters, but get a syntax error. The data would like this: 23302220202X Where "X" represents the

create table error

2001-03-23 Thread Daniel Adams
Can someone please tell me what the problem is below. All I am trying to do is pipe a backup created with mysqldump into mysql and it gives me this error: ERROR 1071 at line 1291: Specified key was too long. Max key length is 500 Here is the query where the error is: CREATE TABLE list ( l

RE: MySQL vs Microsoft SQL

2001-03-23 Thread Cal Evans
When was the last time you got to ask a question directly to one of the developers of MS SQL? When was the last time you found a bug in MS SQL and one of the developers told you it would be fixed tonight and to go grab the source tomorrow and recompile? When was the last time you could buy OFFIC

RE: mysql gui core dump on Solaris 2.8

2001-03-23 Thread deCarmo, Linden
> Hi! > > It is from the bug in MySQL++. > > I am sending you a patch in direct mail. > > > Regards, > > Sinisa Thanks for the patch. It solved the core dump, but now mysql_real_connect() is failing rather than core dumping. connection.cc then throws an exception, but the exception catchin

Re: MySQL vs Microsoft SQL

2001-03-23 Thread Robert Alexander
Hi Ciprian, Well, I guess you just need to ask yourself a few questions: Is this an important project? Is scaleability important? Is good security important? Is stability important? If you answered 'yes' to any of these, and any of them are mission-critical, then Microsoft products in gener

Suggestions

2001-03-23 Thread Ed Hayes
I'm trying to pull information from a table as follows: Table: PHONE PhoneClass Number Fax 123-123-1234 Main123-123-1234 Fax 123-123-1234 Main123-123-1234 etc. Main is mapped as phone Fax is mapped as fax I'm outputting this inf

Re: MySQL vs Microsoft SQL

2001-03-23 Thread René Tegel
platform independency, reasonable portability, performance(!), optimal load/performance ratio, loads of access methods including odbc and web based scripts like php,asp, active development, integration with apache authentication, very very good & personal online help (this mailing list :), low net

HELP!!!

2001-03-23 Thread Daniel Adams
Can anyone tell me how to fix this error: ERROR 1016: Can't open file: 'message.MYD'. (errno: 126) Please help!!! - Dan Adams - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://l

Re: speed of list

2001-03-23 Thread Jeremy D . Zawodny
On Wed, Mar 21, 2001 at 10:01:23PM +0100, René Tegel wrote: > the email list seems to be very slow now and them... wouldn't it be > an option to make a web-based list ? In addition to the e-mail version, or instead of it? -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance

Re: MySQL vs Microsoft SQL

2001-03-23 Thread Ciprian I. Acatrinei
Is there something that you can do with MS SQL and you can not do with MySQL? At 04:01 PM 3/23/2001, Jeremy D . Zawodny wrote: >*This message was transferred with a trial version of CommuniGate(tm) Pro* >On Fri, Mar 23, 2001 at 01:09:47PM -0500, Ciprian I. Acatrinei wrote: > > *This message w

Re: MySQL vs Microsoft SQL

2001-03-23 Thread Jeremy D . Zawodny
On Fri, Mar 23, 2001 at 01:09:47PM -0500, Ciprian I. Acatrinei wrote: > *This message was transferred with a trial version of CommuniGate(tm) Pro* > Hi, > > I would need some reasons for choosing MySQL instead of Microsoft > SQL. (beside the fact that MySQL is free). (not for me but for my > bos

Re: Let me see

2001-03-23 Thread Jeremy D . Zawodny
On Fri, Mar 23, 2001 at 11:05:09AM -0800, Mike Roberts wrote: > > My name is Mike Roberts, I have been working with php and MySQL > since the end of December. I think I am doing pretty good. But what > I really want is for you people out there to send me to a website > that you have built. I'm in

Re: MySQL, PHP, Apache: /usr/libexec/ld.so: httpd: libmysqlclient.so.6.0: No such file or directory

2001-03-23 Thread Ciprian A.
*This message was transferred with a trial version of CommuniGate(tm) Pro* I can't get through posting a message on the mysql mailing list! any idea why??? At 12:45 PM 3/23/2001, Shell Hung wrote: >*This message was transferred with a trial version of CommuniGate(tm) Pro* >Colonel Panic wrote

Re: mysql.sock

2001-03-23 Thread Gerald Clark
Malek Fawaz wrote: > > Hello, > > when I install the MySQL RPM package (the newest on you site) as root, I am > able to connect to the server through mysql.sock... but when I logout as > root and login again, the mysql.sock seems to be gone, and therefor I can > not connect to the server. Do you

Re: Is it a bug?

2001-03-23 Thread Gerald Clark
Malek Fawaz wrote: > > Hello, > > when I install the MySQL RPM package (the newest on you site) as root, I am > able to connect to the server through mysql.sock... but when I reboot the > system the mysql.sock seems to be gone, and therefor I can not connect to > the server. Do you have reports

Problems choosing....

2001-03-23 Thread Ciprian A.
*This message was transferred with a trial version of CommuniGate(tm) Pro* Hi, I would need some reasons for choosing MySQL instead of Microsoft SQL. (beside the fact that MySQL is free). (not for me but for my boss). It may sound silly but trust me I really need these reasons. So please help me

Mysql vs ....

2001-03-23 Thread Ciprian A.
*This message was transferred with a trial version of CommuniGate(tm) Pro* Hi, I would need some reasons for choosing MySQL instead of Microsoft SQL. (beside the fact that MySQL is free). (not for me but for my boss). It may sound silly but trust me I really need these reasons. So please help m

Need help with restoring DB with binary log?

2001-03-23 Thread Shane Gentry
I am trying to restore my database using the binary log. I have restored the last full backup and want to rerun the updates from that point. I have tried running this command (mysqlbinlog log-file | mysql -h server_name), which is shown in the manual but it doesn't seem to work. Any suggestions

Q: How to recreate lost .MYI files

2001-03-23 Thread Carsten Gehling
I have to MYISAM tables where I... ahem... have lost the corresponding .MYI files. When I try to repair the tables, myisamchk reports this error: myisamchk: error: 'questions.XXX' doesn't have a correct index definition. You need to recreate it before you can do a repair How do I recreate these

mysql_auth HELP!

2001-03-23 Thread Linsen Limsico
I am trying to use mysql_auth for my basic authentication. Everything works great, but I need to also use the typical .htpasswd file with it. But unfortunately, it only works with one or the other, but not both. Does anyone know how to get the .htaccess file to check the database if the passwor

Re: Wanted: Script to store files i DB

2001-03-23 Thread Peter Skipworth
All you need is a single SQL function - have a look in the docs. On Fri, 23 Mar 2001, roger westin wrote: > Hi, > Anyone got a small script to store a file in a BLOB. > Nothing fancy, just so that I dont need to think that much today. > > /roger > > -

Re: Problem on Msql-Mysql-modules installation

2001-03-23 Thread
You make know mention of what C compiler and what version of perl you have on your computer. Also, what version of make. [EMAIL PROTECTED] wrote: > > > I am installing Msql-Mysql-modules-1.2215 on Solaris 2.7. After running make, > error returns, > dbdimp.c:116: `SQL_TIMESTAMP' undeclared her

Re: mysqlbug

2001-03-23 Thread Gerald Clark
SirAbdul wrote: > > Hello! > i've some troubels between the installation of mysql-3.23.35 on my suse > linux 7.0 system. > in the fiel 'INSTALL-BINARY' stands i should unzip the archive with the > command > > gzip < mysql-3.23.35.tar.gz | tar xvf - > Sounds like you have the source tarball. >

Re: size limitation

2001-03-23 Thread Jeremy D . Zawodny
On Fri, Mar 23, 2001 at 11:33:42AM +0100, Pascal THIVENT wrote: > > I've got to manage one database. > This database is made of one table. > This table will grow very quickly (we evaluate that we'll have to make > arround 1.000.000.000 inserts per day). What sort of hardware are you planning to

RE: Large search engine

2001-03-23 Thread Sander Pilon
If you want to make a LARGE (millions of documents, gigabytes of data) searchengine, you'd better know something about searchengine algorithms :) I'll give you one hint - A database is not a searchengine. A database is not meant to be a searchengine. And, until some decent text-processing/searchi

Use of the Mysql CAPI

2001-03-23 Thread Lucio Braga
Hi, i have a table with a field varchar(15). I use the Mysql CAPI to get the value this field. The problem is:  What's the function's type to return this value? What's the variable's type that will receive the data?   In attach is a file with a piece of my code. Tanks for attention and p

Replication troubles

2001-03-23 Thread Bryan Coon
I have two machines which I am trying to set up replication on. I followed the howto as describe in the manual, and everything seemed to be okay (i.e. no errors), but it simply doesn't work. Heres what I did on the master: 1. Copied /usr/share/my-large.cnf to /etc/my.cnf 2. my.cnf already had lo

Bad optimization with two conditions?

2001-03-23 Thread Federico Giannici
We have a table where we register the data of all the modem connections of the users of a small ISP. The table contains 2 million records and has the following structure: +-+--+--+-+-+---+ | Field | Type | Null | Key | Default | E

*sigh* Re: Is it a bug?

2001-03-23 Thread Peter Skipworth
This may well be a point which has been raised in the past, but has there ever been any talk of splitting this list into a "mysql-for-dummies" and a "mysql-for-people-who-read-the-manual" list ? I'm getting close to unsubscribing due to the enormously large noise ratio - to be frank, questions suc

MySQL vs Microsoft SQL

2001-03-23 Thread Ciprian A.
*This message was transferred with a trial version of CommuniGate(tm) Pro* Hi, I would need some reasons for choosing MySQL instead of Microsoft SQL. (beside the fact that MySQL is free). (not for me but for my boss). It may sound silly but trust me I really need these reasons. So please help

Re[28]: Warning: Got signal 14 from thread X

2001-03-23 Thread BAUMEISTER Alexandre
Sinisa, SM> No, nothing, No need to test further. SM> Try those Solaris patches, re-install gcc and build from the fresh SM> tarball without debug and with all the options like the last time. I re-compiled everything. gcc-2.95.3 , Mysql-3.23.35 from fresh tarball , GNU Make ... I config

Simple question: I can't find the latest binary for mysql 3.23.x for Solaris "Intel" version. Can someone tell me if they even have a Intel version of 3.23???

2001-03-23 Thread Esteban Cazarez
Simple question: I can't find the latest binary for mysql 3.23.x for Solaris "Intel" version. Can someone tell me if they even have a Intel version of 3.23??? Technology Consultant 310-426-5619 (h) / 888-431-7571 (p) http://www.access1.net/esteban1

creating a new column whose values mirror the row order

2001-03-23 Thread WCBaker
Hi! Futher to a question I had asked, I think that my final problem in this application still has to do with presentation of some records in MySql. Rene and Marcus fruitfully suggested using the html refresh option in frames as a mechanism for presenting records every so many seconds, and at the

Let me see

2001-03-23 Thread Mike Roberts
Hello My name is Mike Roberts, I have been working with php and MySQL since the end of December. I think I am doing pretty good. But what I really want is for you people out there to send me to a website that you have built. I'm interested in see all the different things people have created using

MySQL vs Microsoft SQL

2001-03-23 Thread Ciprian I. Acatrinei
*This message was transferred with a trial version of CommuniGate(tm) Pro* Hi, I would need some reasons for choosing MySQL instead of Microsoft SQL. (beside the fact that MySQL is free). (not for me but for my boss). It may sound silly but trust me I really need these reasons. So please help

Re: MySQL, PHP, Apache: /usr/libexec/ld.so: httpd: libmysqlclient.so.6.0: No such file or directory

2001-03-23 Thread Anil Madhavapeddy
Thalis A. Kalfigopoulos <[EMAIL PROTECTED]> wrote: > > Since you updated both mysql and php you presumably > should recompile apache as well. A quick&dirty solution > though could be to just create a link: libmysqlclient.so.6.0-> > libmysqlclient.so.10.0 and see what happens from there :-) Nop

Re: MySQL, PHP, Apache: /usr/libexec/ld.so: httpd: libmysqlclient.so.6.0: No such file or directory

2001-03-23 Thread Colonel Panic
- Original Message - > I'm running into the same exact problem. Apache will not start until > Mysql has been started (even if mysql is stopped prior to starting httpd), > and gives that same message. If you start mysql first it should run fine. In my case I hit the same error if msqld

MySQL Backup

2001-03-23 Thread KPortsmout
Hi, I`m having trouble backing up MySQL on my Cobalt RAQ4r server, I have tried all the methods I can find in the manual but all it ever seems to do is print out some instructions which leads me to beleive I`m doing something wrong, can anyone help? I basically want to backup all of my databa

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, PHP, Apache: /usr/libexec/ld.so: httpd: libmysqlclient.so.6.0: No such file or directory

2001-03-23 Thread Shell Hung
Colonel Panic wrote: > > Hi > > I've installed MySQL (mysql-3.23.33-pth) and PHP (php4-4.0.3pl1-mysql) from OpenBSD >ports... > > ... but this has broken apache. Restarts/configtests now trigger:- > /usr/libexec/ld.so: httpd: libmysqlclient.so.6.0: No such file or directory > > I've added > s

Re: MySQL, PHP, Apache: /usr/libexec/ld.so: httpd: libmysqlclient.so.6.0:No such file or directory

2001-03-23 Thread Thalis A. Kalfigopoulos
Since you updated both mysql and php you presumably should recompile apache as well. A quick&dirty solution though could be to just create a link: libmysqlclient.so.6.0->libmysqlclient.so.10.0 and see what happens from there :-) regards, thalis On Fri, 23 Mar 2001, Colonel P

Re: Connection related SIG 11 crash in 3.23

2001-03-23 Thread Joseph Bueno
Gerald Clark wrote: > > Voytek Lapinski wrote: > > [...] > I have been following the SIG 11 threads that have appeared lately. > It seems to me all reporters have been running SMP kernels. > > What happens if you bring the machine up single CPU? > I am still getting occasional signal 11 crash

Installation of, Win32 static binary of MySQLGUI 1.7.4-2

2001-03-23 Thread xerxes
Dear Sir, I am looking for documentation for installation of Win32 static binary of MySQLGUI 1.7.4-2. Thank you PM --- Pat McNeal

Re: MySQL vs PostreSQL ??

2001-03-23 Thread Tõnu Samuel
tmb wrote: > > How does PostreSQL compair to MySQL ? > > I'm sure each has it's own advantages & disadvantages. > > What are some of the major ones? Both are very good databases with free type licenses. There are advantages. dot. -- MySQL Development Team __ ___ ___ __ / |/

Problems

2001-03-23 Thread Mirian Silva
I am trying to install mysql-3.23.32-bsdi4.2 . My system is bsdi/os 4.0. When i try to run the script/mysql_install_db i received the error "can't load library libz.so". Then, i tried to use ./configure --disabled-shared, but i still have the same problem. Please could you let me know what i am

Wantaed: Sorry forgot...

2001-03-23 Thread roger westin
Hi again, Ehh the script in my prev mesg, language: C Forgot that. Files that will be stored is: gifs jpegs html pages etc. /roger

Wanted: Script to store files i DB

2001-03-23 Thread roger westin
Hi, Anyone got a small script to store a file in a BLOB. Nothing fancy, just so that I dont need to think that much today. /roger

Re: _

2001-03-23 Thread Thalis A. Kalfigopoulos
On Fri, 23 Mar 2001, Markus Siagian wrote: > Hi, > I'm still a newbie in mysql and also sql statements. > I > was wondering if some one can help me with this > problem. > > I'm trying to select 5 of the highest values from a > table. But i can't seem to find any help from the > manual a

please tell me what "Init" in processlist means

2001-03-23 Thread Christian Hammers
Hello I tried upgrading from MySQL-3.21.33 to 3.23.35 on an old linux host. It worked but the new mysql version was *horrible* slow. E.g. under exactly same situations I came to ca. 300 inserts/second with the old and 20 with the new version making it absolutely unusable :-( The only recognisab

Re: My script that uses mysql.

2001-03-23 Thread Thalis A. Kalfigopoulos
On Fri, 23 Mar 2001, Johan Vikerskog (ECS) wrote: > I am not sure if i should post it here but please do help my if you can. > The script is as follows: > > > > > > > mysql_connect (localhost, username, password

Problem on Msql-Mysql-modules installation

2001-03-23 Thread stsai
I am installing Msql-Mysql-modules-1.2215 on Solaris 2.7. After running make, error returns, dbdimp.c:116: `SQL_TIMESTAMP' undeclared here (not in a function) dbdimp.c:116: initializer element is not constant dbdimp.c:116: (near initialization for `SQL_GET_TYPE_INFO_values[7].data_type') dbdimp.

RE: My script that uses mysql.

2001-03-23 Thread Jon Haworth
> I am not sure if i should post it here but please do help my if you can. Probably one of the PHP lists would be a better place ;-) Check out http://www.php.net/support.php for a full run-down. > The script is as follows: > I basically have two questions. > If i want to make a "mailto" funct

Re[28]: Warning: Got signal 14 from thread X

2001-03-23 Thread BAUMEISTER Alexandre
Sinisa, SM> No, nothing, No need to test further. SM> Try those Solaris patches, re-install gcc and build from the fresh SM> tarball without debug and with all the options like the last time. Fresh tarball. Latest Solaris 2.8 patch applied ! But : 010323 17:38:04 mysqld started Innoba

RE: My script that uses mysql.

2001-03-23 Thread Cal Evans
1: print ''$row["email_player"].''; 2: $row is the name of the array you have defined to hold the current row form the resultset your created with the SELECT statement. each time you do $row = mysql_fetch_array($result) it takes the next row from $result and stored it in the array named $row. Ca

mysql.sock

2001-03-23 Thread Malek Fawaz
Hello, when I install the MySQL RPM package (the newest on you site) as root, I am able to connect to the server through mysql.sock... but when I logout as root and login again, the mysql.sock seems to be gone, and therefor I can not connect to the server. Do you have reports on that? This happen

i think i screwed up (cont'd)

2001-03-23 Thread Thalis A. Kalfigopoulos
Also with regard to the lost 32 recs, the error log mentioned: 010323 5:41:50 read_const: Got error 127 when reading table ./eval/reviewer Where perror gives: 127 = Record-file is crashed And Mysql version: 3.23.30-gamma-log regards, thalis ---

Re: MySQL, PHP, Apache: /usr/libexec/ld.so: httpd: libmysqlclient.so.6.0:No such file or directory

2001-03-23 Thread mshaw
I'm running into the same exact problem. Apache will not start until Mysql has been started (even if mysql is stopped prior to starting httpd), and gives that same message. If you start mysql first it should run fine. Being relatively new to this type of thing I'm making some blind stabs, but m

Is it a bug?

2001-03-23 Thread Malek Fawaz
Hello, when I install the MySQL RPM package (the newest on you site) as root, I am able to connect to the server through mysql.sock... but when I reboot the system the mysql.sock seems to be gone, and therefor I can not connect to the server. Do you have reports on that? This happens with SuSE li

RE: Compiling MySQL on Solaris with -static: Impossible? Why??

2001-03-23 Thread Pascal THIVENT
Sinisa Milivojevic explained me that : "Unfortunately you can not build static programs on Solaris, as Sun has not provided static versions for many of it's libraries." Regards, -- Pascal Thivent > -Message d'origine- > De: Johan Andersson [mailto:[EMAIL PROTECTED]] > Date: vendredi 2

HELP? RE: can't find shr.o???

2001-03-23 Thread Summanen,Jack
Well make sure you have gcc 2.95.2 and a recent version of make (the manual suggests a version). Also, when I said "Lib paths" I meant look at the -I options for your configs. But rereading your info, it looks like a problem with the actual object file (or lack of one). I hate to say this but yo

i think i screwed up

2001-03-23 Thread Thalis A. Kalfigopoulos
Hello, I did something dumb: ran myisamchk while mysqld was up and running and, being on a linux system, I run the deamon with --skip-locking. This is what I guess made one of my tables appear to be empty. According to the manual if you run myisamchk while someone else is doing an updat

RE: License Information !!!

2001-03-23 Thread Cal Evans
http://www.mysql.com/support/arrangements/policy.html Cal http://www.calevans.com -Original Message- From: Ing. Gabriel Ayala [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 9:00 AM To: [EMAIL PROTECTED] Subject: License Information !!! Hi, I would like to know what is the asp

Re: MySQL vs PostreSQL ??

2001-03-23 Thread Vivek Khera
> "t" == topmailbox writes: t> How does PostreSQL compair to MySQL ? Did you read what it has to say about this in the manual? t> I'm sure each has it's own advantages & disadvantages. Yes. t> What are some of the major ones? Depends on what your needs are. One person's advantage is a

Need your suggestions or comments.

2001-03-23 Thread James R. Butzen
Hi All, Our MySQL database server is in a Linux box. But my users in our LAN are using windows. I am planning to write a client program for my window users that will interact with my database server in Lunix for daily database tasks. Our daily database tasks include search for a record, crea

Re: can't find shr.o???

2001-03-23 Thread Tim Tyler
Jack, Yes, I made sure that I ran the command from the mysql home directory and not within scripts. I am not sure what to check with lib paths. I think it doesn't have a problem finding zlib.a in /usr/local/lib. I think it simply can't load it because it can't find the shr.o that is associated

MySQL, PHP, Apache: /usr/libexec/ld.so: httpd: libmysqlclient.so.6.0: No such file or directory

2001-03-23 Thread Colonel Panic
Hi I've installed MySQL (mysql-3.23.33-pth) and PHP (php4-4.0.3pl1-mysql) from OpenBSD ports... ... but this has broken apache. Restarts/configtests now trigger:- /usr/libexec/ld.so: httpd: libmysqlclient.so.6.0: No such file or directory I've added shlib_dirs="/usr/local/lib/mysql" to rc.conf

Re: Need for help

2001-03-23 Thread Thalis A. Kalfigopoulos
You are first suppose to start the daemon through safe_mysqld which is under the mysql bin/ directory, or through mysql.server which is under mysql's share/ directory (info about both on the webpage) Running one of these will actually get your deamon running (and create the desired /tmp/mysql.s

Re: Need for help

2001-03-23 Thread Gerald Clark
Which Version of MySQL? Where would you find one that old? Whate platform? What Linux Distribution? What Linux version? Which RPM? Client? Server? Both? What were their names? Posts like this don't encurage helpful responses. More information is needed. Is the server running? It creates the so

Duplicate Registers

2001-03-23 Thread Jorge Fernández
Hey all! I have a duplicate registers problem using native components for Delphi (Zeos library, but with ODBC also it fails). do you have some solutions? Regards, Jorge - Before posting, please check: http://www.mysql.com/

Re[13]: Warning: Got signal 14 from thread X

2001-03-23 Thread BAUMEISTER Alexandre
Bonjour Michael, BAUMEISTER>> Sinisa, BAUMEISTER>> This time I compiled with : BAUMEISTER>> CFLAGS=-DSOLARIS CXXFLAGS="-DSOLARIS -felide-constructors -fno-exceptions -fno-rtti" ./configure BAUMEISTER>> --prefix=/usr/local/mysql --without-bench --enable-thread-safe-client --with-innobase --

Re: Compiling MySQL on Solaris with -static: Impossible? Why??

2001-03-23 Thread Sinisa Milivojevic
Johan Andersson writes: > Is it true that you can't compile on Solaris with -static ?? > > If so, why is that so?? > > > > > Regards, > Johan Andersson > Because Sun has not provided static versions of their system libraries. Regards, Sinisa __ _ _

  1   2   >