_

2001-03-23 Thread Markus Siagian
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 and also some other books. In the manual, there is only a fun

SV: _

2001-03-23 Thread Jarmo Paavilainen
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 and also some other books. In the manual, > there

Re: _

2001-03-23 Thread Rolf Hopkins
You can use "limit 5". - Original Message - From: "Markus Siagian" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 23, 2001 16:25 Subject: _ > Hi, > I'm still a newbie in mysql and also sql statements. > I > was wondering if some one can help me with this > problem.

HOWTO move the Index on another partition.

2001-03-23 Thread Pascal THIVENT
Hi, I've created a database whith one table. This table has 3 columns and use an index. I would like to move the file that stands for the index on another partition. What file does store the indexes ? Does a symbolincd link be enough to move the index on another disk ? Thanks -- Pascal T

size limitation

2001-03-23 Thread Pascal THIVENT
In order to choose a DBMS, i've to check to MySQL is able to support our requirements. 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). I want to be sure that MySQ

Query: Error 2002 Can't connect to local mysql server.

2001-03-23 Thread Foresight Systems Ltd.
Dear Sir, We are trying to install and configure mysql version .23.32 on Linux Red Hat 7. Usinf the configure option ./configure --prefix=/usr/local --localstatedir=/usr/local/mysql/data --with-unix-socket-path=/usr.local/mysql/tmp/mysql.sock the make and make install. we have tried several varia

Re: Query: Error 2002 Can't connect to local mysql server.

2001-03-23 Thread Erik Ahlstrom
First try to find out where you socket is located: # lsof -p {$PID_OF_MYSQL] |grep unix mysqld 1277 root 4u unix 0xcb596580 1712 /var/lib/mysql/mysql.sock And then point to this file in mysql conf file: # more /etc/my.cnf [client] socket=/var/lib/mysql/mysql.sock [mysqld] socket=/var/lib/mysq

Grant/Revoke dialog doesn't open

2001-03-23 Thread Gustavo Gibson da Silva
Hi, I'm trying to run mysqlgui 1.7.4 (both static and semi-static versions) and I'm running into a problem when I try to open the Grant/Revoke dialog. Only the title bar appears on GNOME and only the title bar and the username textbox appears on KDE 2. It works just fine on kde 1.2. Is there

Re: Pauses with large selects

2001-03-23 Thread Sinisa Milivojevic
S Lemmon writes: > Sinisa Milivojevic wrote: > > > > Hi! > > > > With : > > > > select * from table; > > > > queries MySQL returns results immediately. > > > > Any problem that you experience might come only from poor build, some > > OS bug or some wrong settings. > > Thanks fo

View a return of Select

2001-03-23 Thread Jaime Rubio
I have to check to MySQL is able to support our requirements and I would like to view a return of n columns like only one register, thats is posible with MySQL? For example i have 2 tables , 1 table have products and this table habe 3 colums ID , name, Id_price and the other table

Re: UPDATE problems in 3.23.35 ?

2001-03-23 Thread Sinisa Milivojevic
Petter Larsson writes: > Hi, > > I recantly upgraded from 3.22.32 to 3.23.35 using an rpm from > www.mysql.com. > My platform: Redhat Linux 2.2.14 i686 > > The problem is now that UPDATE do not always succed. I get a query OK > but no > update is done unless the same query is issued

building a timer for controlled display of records

2001-03-23 Thread WCBaker
Hi! Has anyone a nice example of a timer that will run on a Win OS? It is to be a timed display in which a record is retrieved from a MySql database table and after 15 seconds the next record comes up for display. Since the application has to be responsive to user input during the "show" of r

Re: building a timer for controlled display of records

2001-03-23 Thread René Tegel
well, i think you'll have to work with frames. 1 php script shows your refreshing data, 1 script allows the user to enter data (this could be a single script called with different parameters as well). then in the refreshing script you put something like this before sending any other data: header

Re: Grant/Revoke dialog doesn't open

2001-03-23 Thread Sinisa Milivojevic
Gustavo Gibson da Silva writes: > Hi, > > I'm trying to run mysqlgui 1.7.4 (both static and semi-static versions) and > I'm running into a problem when I try to open the Grant/Revoke dialog. Only > the title bar appears on GNOME and only the title bar and the username > textbox appears o

RE: View a return of Select

2001-03-23 Thread Cal Evans
Not without some procedural code in a different language or creating temp tables. (Both are bad ideas.) Using straight SQL, the best you can get it 3 records, each with all the info from table 1 and a different row from table 2. HTH, Cal http://www.calevans.com -Original Message- From:

mysql gui core dump on Solaris 2.8

2001-03-23 Thread deCarmo, Linden
I was able to build the mysql gui on Solaris 2.8, but it core dumps every time on the following line in connection.cc if (mysql_real_connect(&mysql,host,user,passwd,db, port,socket_name,client_flag)) called from either: 1232 con->real_connect("",options->hostname.c_str(),options->usernam

MySQL vs PostreSQL ??

2001-03-23 Thread tmb
How does PostreSQL compair to MySQL ? I'm sure each has it's own advantages & disadvantages. What are some of the major ones? Which would be more capible in a large web base database where the database was very large and the hit rate very high? Thanks - tmb __

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

2001-03-23 Thread Michael Widenius
Hi! > "BAUMEISTER" == BAUMEISTER Alexandre <[EMAIL PROTECTED]> writes: 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 --witho

MySQL Failing in Runlevel 5 on SuSE Linux 7.1 Pro

2001-03-23 Thread Darren Watson
Hi I've recently installed MySQL onto suse linux 7.1 pro using the YaST2 installation program. When my system restarts a mesage saying that mysql has failed in runlevel 5 appears, however the database does appear to be running as I can connect to it via the mysql client and view databases etc

Re: mysql gui core dump on Solaris 2.8

2001-03-23 Thread Sinisa Milivojevic
deCarmo, Linden writes: > I was able to build the mysql gui on Solaris 2.8, but it core dumps every > time on the following line in connection.cc > > if (mysql_real_connect(&mysql,host,user,passwd,db, > port,socket_name,client_flag)) > > called from either: > > 1232 > con->real

Re: View a return of Select

2001-03-23 Thread Bob Hall
> I have to check to MySQL is able to support our requirements >and I would >like to view a return of n columns like only one register, thats is posible >with MySQL? > For example i have 2 tables , 1 table have products and this >table habe 3 >colums ID , name, Id_price and the other

Re: MySQL question

2001-03-23 Thread Gerald Clark
We pay for support here. In the last two years, I have only needed tor resort to it once, because the mailing list is very effective. When I needed to resort to my support contract, it was a real problem that the list would not have been able to solve. The problem was resolved within 24 hours.

Re: MYSQL using PERL

2001-03-23 Thread Gerald Clark
Rajeev Ramanujan wrote: > > Hai, > I am using Red Hat Linux 7. From where can I get example programmes of >connectiong to MYSQL using PERL under Linux. > > Thankyou > Rajeev Ramanujan Look at any of the perl based packages or utilities listed in the contributed section at mysql.com. O

Re: MYSQL using PERL

2001-03-23 Thread
How about mysql.com, http://cpan.org/modules/by-module/DBI/ MySQL.com has numerous links to help documents and code samples. -- === "If you put three drops of poison into a 100 percent pure Java, you get - Windows. If yo

Re: MYSQL using PERL

2001-03-23 Thread
Buy the MySQL book from New Riders. You won't be disappointed. -- === "If you put three drops of poison into a 100 percent pure Java, you get - Windows. If you put a few drops of Java into Windows, you still have Windows."

Re: Connection related SIG 11 crash in 3.23

2001-03-23 Thread Gerald Clark
Voytek Lapinski wrote: > > Ok... I've posted briefly regarding this, but heres a complete bug report. > Yeah I know its kinda long, but I thought it better to include more rather > than less. > > We are seeing a problem which results in mysqld dying with a SIGSEGV. The > problem has been confirm

Re: What this mean?

2001-03-23 Thread Gerald Clark
WANG_KING£¨Íõ¸Ö£© wrote: > > When I use C API ,mysql_query. > I got an error : > Commands out of sync; You can't run this command now > what this mean and what should I do? > > - It probably means you have not finished reading

Need for help

2001-03-23 Thread Bellahcene Farid
I 'have installed Mysql 3.22.13 and Mysql client under Linux by RPM. But when i do "mysqldmin -u root password " there is a message telling about *.sock under /tmp missing or not present. What can i do to create it ?

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

2001-03-23 Thread Johan Andersson
Is it true that you can't compile on Solaris with -static ?? If so, why is that so?? Regards, Johan Andersson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: HOWTO move the Index on another partition.

2001-03-23 Thread Gerald Clark
Apparently you have not even looked at the manual. Depending on table type, the index will end in .MYI or .IDX. Symbolic links are discussed in the manual. Pascal THIVENT wrote: > > Hi, > > I've created a database whith one table. > This table has 3 columns and use an index. > > I would like t

Re: Query: Error 2002 Can't connect to local mysql server.

2001-03-23 Thread Gerald Clark
Did you follow the rest of the instructions? Did you create the mysql user? Did you run mysql_install_db --user=mysql ? Did you start the server ? "Foresight Systems Ltd." wrote: > > Dear Sir, > > We are trying to install and configure mysql version .23.32 on Linux Red > Hat 7. > Usinf the con

Re: What this mean?

2001-03-23 Thread roger westin
Hi there, > When I use C API ,mysql_query. > I got an error : > Commands out of sync; You can't run this command now > what this mean and what should I do? You are probobly sending a query to the DB thats generates a raply, like select for example. What you need to do is to cath the reply with

mysqlbug

2001-03-23 Thread SirAbdul
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 - when i type this shell command i've got an error. but the unzip works with this

License Information !!!

2001-03-23 Thread Ing. Gabriel Ayala
Hi, I would like to know what is the aspects legals about the application of mysql software, because I have an proyect that use mysql to format the information in Unix.Also I have been think about the sales my aplication, could you say me if I can make it or how I can ask more information. Th

MySql & Amiga

2001-03-23 Thread SixK
Hello, First of all, i'm proud to announce the first Port of MySql to AmigaOs... you know this old gaming computer based on 68000 motorola chip... you don't know it ?? never mind .. I had several probleme when compiling. First of all, configure could not find PS file for Pid, I simply disabled t

My script that uses mysql.

2001-03-23 Thread Johan Vikerskog (ECS)
I am not sure if i should post it here but please do help my if you can. The script is as follows: "); } while($row = mysql_fetch_array($result)); } else {print "Sorry, no records were found!";} ?> I basical

Bug in mysql_info()?

2001-03-23 Thread Robert MacDonald
MySQL (version 3.23.33 on Linux 2.2.5-15) is returning an empty string from mysql_info() following an UPDATE query. The docs say: char *mysql_info(MYSQL *mysql) Description Retrieves a string providing information about the most recently executed query, but only for the statements listed bel

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 __ _ _

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 --

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: 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

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

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: 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

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: 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

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

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

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

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

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: 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

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 ---

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

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

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 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

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 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

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: _

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

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

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

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

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 __ ___ ___ __ / |/

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: 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

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: 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: 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

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: 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

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

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

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

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

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

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

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

*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

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

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

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

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

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: 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: 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: 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 > > -

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

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

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

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

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

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

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: 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: 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 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: 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: 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

  1   2   >