Question

I am developing the Japanese web site with java(jsp) and mysql. I know that mysql supports the Japanese language. But I think that mysql doesn’t support some character of Japanese language. This is the part of the data that becomes the issue. Whenever I commit the above command,

RE: Having trouble to use array in SELECT statement.

Yes Rolf is correct I think this is actually a perl Q... because I assume that is perl you are using so you should declare the array as: @array = qw(bla bla bla bla lba); Secondly using the array in the select will not give the desired results because it will print out something like select bla bl

make

Hi, I want to compile a mysql3.23.33 to support transaction. I passed the first step :./configure. But when I exec "make" to make file,it shows the follow message: <(mysql323@pdsvr3):/usr/mysql323/mysqlsrc/mysql-3.23.33>make No suffix list. cd include; link_sources sh: lin

Error: Out of virtual memory

Hello, Sorry for the previous posting, please disregard. I just installed mysql 3.22.30 on Digital Unix system 4.0D; it works fine but when I exit out of "mysql>" I get the error "xmalloc: out of virtual memory " . Is this an error to be concerned about? The following

Erorr: Out of virtual memory

> -Original Message- > From: RUMADI HARTAWAN [SMTP:[EMAIL PROTECTED]] > Sent: Monday, February 26, 2001 11:12 PM > To: [EMAIL PROTECTED] > Subject: Configure error > > Hi Gurus, > > I've tried to configure mysql source distribution, but I've got following > error message. > My

ask mysql.jdbc ?

is mysql.jdbc-1.2 the latest? which version of JDBC API included in mysql.jdbc-1.2 ? does mysql.jdbc-1.2 driver support with XA Datasource? I want to know to configure it in J2EE. thanks in advances - Before posting, please ch

Configure error

Hi Gurus, I've tried to configure mysql source distribution, but I've got following error message. My machine is Sun Ultra-2 running SPARC Solaris 2.6. What should I do to fix this problem? Thank you very much in advance. Yours sincerely, [EMAIL PROTECTED] --

compile

Hi, How to use gcc when compileing mysql3.23.33?I am using SCO openserver. And what to set to the $MAKE varibles when exec configure. - Before posting, please check: http://www.mysql.com/manual.php (the manual) ht

Re: array awry

This is a PHP question and should really be asked on the PHP list. But a suggestion. Tried using field names instead of number? ie. $myrow["catid"]; I'd have to read up the PHP manual to find out for sure but I'm sure you can do that just as well as I can. - Original Message - From: "

How to get MAX of each group after GROUP BY ?

How do I do a single query to group a table by one column & then get the row of say the highest of each group ? Data is like so : Album, City, Plays, Date Britney, NYC, 103, 1-10 Britney, SF, 101, 1-10 Eminem, NYC, 100, 1-11 Eminem, SF, 102, 1-11 So I want to GROUP BY Album, then get

Re: Newbie DATESTAMP problem

Hi Ken, Welcome to the list. You'll get great help here, best support I've ever come across but you do need to do your own research first. Try reading the relevant sections of the manual again but a little more thoroughly this time. To get you started, you're mixing C code with SQL code. You

Re: Too many Aborted Connects

Your problem is that you shouldn't be using mysql_pconnect().That comment is for persistent connections, which you really don't want. What is likely happening is the php thread ends, aborting what MySQL thought would be a persistent connection. Try changing it to mysql_connect() here's some

Re: load large data files?

How do I do a single query to group a table by one column & then get the row of say the highest of each group ? Data is like so : Album, City, Plays, Date Britney, NYC, 103, 1-10 Britney, SF, 101, 1-10 Eminem, NYC, 100, 1-11 Eminem, SF, 102, 1-11 So I want to GROUP BY Album, then get the

Re: load large data files?

I'm presuming that hard drive space isn't a problem. What is it you're trying to import that's so large? regular data? graphics? music? Can you store the files on your hard drive instead and just store the link in the database? Are the fields, of the table you are importing too, of an appropria

Re: Having trouble to use array in SELECT statement.

A suggestion. I don't know what language you're using but try printing $quary to the screen before it is passed to mysql. If @inc_re is an array, as you say, then in a lot of other languages, you're next line would be an illegal statement. Even the first statement looks incorrect but I don't kn

configure

Hi, I want to compile mysql to make it support transaction bur when I exec . /configure, I got an error: "checking whether make sets ${MAKE}... ./configure: syntax error at line 1: '(' unexpected" who can help me?Thanks a lot! --

Compile Mysql

Hi, When I downloaded the source distribution of Mysql3.23.33. And I want to compile it. But in the first step I got an error: " checking whether make sets ${MAKE}... ./configure: syntax error at line 1: '(' unexpected" who can tell me why? -

array awry

This associative array embedded within a function and declared as a global at the start of the function, is meant to be a multidimensional array, but with every loop of the while ($myrow = mysql_fetch_row($result)) statement, it's previous values are replaced by the new ones. Any ideas on how

Re: problems with insert

I don't the language your using but it looks like you may have left out a comma. I find it difficult to know what is going on with your code without knowing the content of your variables. Could you provide us with the contents of strbuf, before it is passed to mysql!? - Original Message ---

Too many Aborted Connects

Hi, We are getting too many Aborted_connects using mySQL version 3.22.32 on SunOS 5.8. Users connect to our site via an Apache/1.3.12 server to a PHP Verion 4.0.4pl1 website which connects to the mySQL database (which is on the same machine) via the PHP mysql_pconnect() command. Aborted_co

Re: XML support under mySQL

Don't forget, Microsoft and Oracle are behind it so it _MUST_ be the greatest thing to come along since sliced bread. You folks need to keep in mind that with the microsoft system the XML layer IS NOT part of the database it self but an additional application which talks to the database via 'ODBC'

Having trouble to use array in SELECT statement.

Hello, I have constructed an array using my table field names and trying to pass that array in the select statement. @inc_re = ( Hotels, Asian_Real_Estate, Smart_Buildings, Real_Estate, Senior_Living_Homes ); $quary = "SELECT @inc_re FROM incu_real_estate LIMIT 1"; But I am getting following

Re: GUI

Look up the manual on skip grants. - Original Message - From: "Dr J. Froggatt" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 27, 2001 1:53 Subject: GUI > Hi from the UK, > > > Firstly just let me say how cool and NON microsoft MySQL is. It is a BRILLIANT > PIECE OF

Re: HELPPpp!!!please! Can't uninstall...

You haven't really provided us with enough information to help you. One suggestion though. You did stop the server before trying to uninstall, didn't you? - Original Message - From: "Michael Nathanson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 27, 2001 7:58 Sub

Re: mysql.user puzzler

Firstly mysql security has no relationship with system security. Secondly, what are you trying to do? Is your machine to be a development server only while the "client" is the main production server? If not, then the client machine is a true client and there is no need to install the mysql serv

Re: Need help with select statement.

Thanks Rolf >From: "Rolf Hopkins" <[EMAIL PROTECTED]> >To: "David Jacobowitz" <[EMAIL PROTECTED]>, ><[EMAIL PROTECTED]> >Subject: Re: Need help with select statement. >Date: Tue, 27 Feb 2001 09:21:57 +0800 > >No it's not possible but you can just read in all tables anyway and ignore >the columns

RE: XML support under mySQL

> How is this superior to SQL? It includes the letters "XML", which, apparantly, can do everything from butter your toast to giving you an orgasm like no other you've had before. Don't you just *love* buzzwords! Sorry...I had to say it =) And no, I'm not at all the cynical type...not I! P Why

Re: MySqwl does not start (server)

It is most likely already running. Use ps -ef to find out. - Original Message - From: "Atle Veka" <[EMAIL PROTECTED]> To: "Find4u" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, February 27, 2001 8:43 Subject: Re: MySqwl does not start (server) > > it would be helpful to se

Re: HELPPpp!!!please! Can't uninstall...

At 15:58 26/02/2001 -0800, Michael Nathanson wrote: Hi! If your uninstall problem is the MySQL service (the only one that I guessed). Please, do: Install again the MySQL stuff. Go at \mysql\bin and type the command line: mysqld-nt --remove Go to Control Panel and using the add/remove program ico

Re: Need help with select statement.

No it's not possible but you can just read in all tables anyway and ignore the columns you don't want. - Original Message - From: "David Jacobowitz" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 27, 2001 7:33 Subject: Need help with select statement. > Dear Sir, >

Re: please urgent

- Original Message - From: "webmaster" <[EMAIL PROTECTED]> To: "Joel Gwynn" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, February 27, 2001 6:13 Subject: please urgent > I have downloaded the leatest ver of php, php 4.04pl1, I am runing winnt > 4.0, acording to the info for

Re: XML support under mySQL

On Mon, Feb 26, 2001 at 06:50:27PM -0600, Cal Evans wrote: > How is this superior to SQL? Why replace a great, stable and mature > language for querying databases with a verbose one? Because it _might_ be the great, stable and matura language for storing and querying data of tomorrow.. By

RE: XML support under mySQL

How is this superior to SQL? Why replace a great, stable and mature language for querying databases with a verbose one? Also, a database IS a huge archive of structured data. :) salutations, Cal http://www.calevans.com -Original Message- From: Florian G. Pflug [mailto:[EMAIL PROTECTE

RH 6.1 problems with mysqld & mysql_install_db

>Description: Unf... this all started on the weekend when *nothing* had ostensibly changed with my client's system, running vanilla RedHat 6.1. All of a sudden, all client connections (e.g. $mysql -p test) would simply hang forever on the password prompt. NOTHING. Tried mysqladmin, same thing. rc

Re: MySqwl does not start (server)

it would be helpful to see the last lines of your error logs.. from this it's impossible to tell what's wrong ;) Atle On Tue, 27 Feb 2001, Find4u wrote: > > > this is what happens > > [root@find4uls1 bin]# Starting mysqld daemon with databases from > /var/lib/mysql > 010226 13:12:22 mysql

Re: MySQL 3.23.32 / SuSE Linux 7.1 / php and normal user

On Mon, Feb 26, 2001 at 04:45:50PM +0100, Thomas Spahni wrote: > On Wed, 21 Feb 2001, Hagen Hoepfner wrote: > > > I can normaly use mysql > > if I am root. But if i'm logged in as normal user or try to connect to mysql > > via php i got the following error message: > > > > MySQL Connection Fai

Re: create table

On Sun, Feb 25, 2001 at 10:07:41PM -0800, Jeremy D. Zawodny wrote: > On Mon, Feb 26, 2001 at 01:26:55PM +0800, WANG_KING£¨Íõ¸Ö£© wrote: > > > > Anyone can give me an example of create a transactional table in > > V3.22.23? Thanks. 3.22(!!!).23??? This has IMHO no BDB-Table support. You need 3.2

Re: XML support under mySQL

On Sat, Feb 24, 2001 at 12:50:13PM +0100, Juergen Fey wrote: > Adding XML support to mySQL is no big deal if your`re talking about very > structured data sets like > > > Joe > Montana > not bad at all > > > If you got to handle a lot of these, than its easy to write an external XML > I/O

Re: mod_auth_mysql

On Mon, Feb 26, 2001 at 06:23:29PM -0500, Peter R. Wood - Mailing Lists wrote: > Hi all, > > Does anyone know if mod_auth_mysql is still under active > development, and if so, where can I find current information on it? Which one? There appear to be two. Go here and search for "mysql" http

MySqwl does not start (server)

this is what happens [root@find4uls1 bin]# Starting mysqld daemon with databases from /var/lib/mysql 010226 13:12:22 mysqld ended [1]+ Done./safe_mysqld --user=mysql [root@find4uls1 bin]# ./safe_mysqld -user=mysql & [1] 20057 [root@find4uls1 bin]# Starting mysqld daemon

Re: XML support under mySQL

On Sun, Feb 25, 2001 at 10:37:10AM -0600, Cal Evans wrote: > Glorious Sunday morning greetings to you Jan, > > No, XML is a format for 2 different applications, usually 2 totally separate > applications, to be able to exchange data. It is not an appropriate choice > for storing large amounts of d

Re: Temporary tables, BDB tables, and Innobase questions

On Mon, Feb 26, 2001 at 05:52:09PM -0600, Stephen Faustino wrote: > > 3. I've read several posts regarding the Innobase tables. Where can > I download the source from to start trying to use Innobase rather > than BDB tables? They'll be in 3.23.24 when it is released. Or you can pull them from

HELPPpp!!!please! Can't uninstall...

I installed mySQL on windows 2000 pro. I am interested in using it for one of my sites. It has been causing some problems since I put it on my computer, and Every time I try to uninstall it, it wont let me – I get an error message. Please help me get it off my computer. Thank You. -Mich

mysql.user puzzler

Hi, I'm deploying a solution that uses Mysql to a number of machines. Because I don't want to set passwords and shutdown access to anonymous users by hand on each machine, and because I don't want the security problems associated with having scripts with passwords in plaintext lying around thes

Temporary tables, BDB tables, and Innobase questions

1. Can temporary tables be of type BDB? Now before the question is asked as to why I need transactional support on a temporary table, let me first say that I really don't need it; this is just something we stumbled across during development. If we create a temporary table of type BDB and attem

Redhat 7.0 w BDB3 Compilation Error

>Description: Compilation fails; probably due to a missing library. Alas, I'm unsure which one I would need. It's not one of the documented missing link libraries from the manual. Nor could I find it using the search engine on the mySQL site. The reason I'm attempting to build from the sour

Need help with select statement.

Dear Sir, I have looked in the manual but could not find any clue so I am seeking your assistance. I have a table with 25 fields and I use most of these fields but not all in different DBI scripts. Currently I use: SELECT field_1, field_4, ...getting tired typing field names... FROM myTest; I

mod_auth_mysql

Hi all, Does anyone know if mod_auth_mysql is still under active development, and if so, where can I find current information on it? I have searched the list archives here and indeed turned up 254 instances of people having problems with mod_auth_mysql. From the sounds of it, it doesn't look

Re: XML interface to MySQL

> does anyone know of an XML interface to MySQL which would enable me to > import or export data using the XML language definition? Try http://www.xml.com/pub/a/2000/12/13/perlxmldb.html (note that I have slept and done other things a few times since reading the above, but I think it discusses

problems with insert

I got a mysql table with to collumns: imageID(integer) and imageData(blob). I'm using the mysql++ API. I can't seem to insert both the imageID and imageData into the table. When I'm just inserting the imageData(the blob field) it works out fine. But as soon as I try to pass both fields, things

Re: mysql Digest 26 Feb 2001 14:06:36 -0000 Issue 1161

Hi... > Is there a front-end available for Mysql. I am currently using Mascon > as an administrative front-end, which is very good. However I need a > front-end with less administrative features, something where-by users > can create/edit/drop tables - therefore it has to be very easy to use.

Re: can create, cannot drop...?

on 2/26/01 2:59 PM, G. Adam Stanislav at [EMAIL PROTECTED] wrote: > At 09:11 26-02-2001 -0700, Geoff Coffey wrote: >> Errno 21 on my system is EISDIR -- 'is a directory', which doesn't seem to >> be an error at all... > > It is an error (that is why it starts with an 'E'). Appendix C of > POSIX

RE: auto_increment

I'm converting a product over to mysql from flat file. The guru of the perl/flat file asked about it (he's my senior) so I had to check into it because the flat-file system reused deleted numbers. If it's not worth the work to change it then I tell him it's not worth the work to change it. :) Ju

RE: auto_increment

Just curious, is there a specific business rule that requires you to have a contiguous list or do you just not like holes in the list? Cal http://www.calevans.com -Original Message- From: John Tsangaris [mailto:[EMAIL PROTECTED]] Sent: Monday, February 26, 2001 7:12 PM To: Atle Veka; Jo

Help with a seg fault

bash-2.04# ./mysql.server stop Killing mysqld with pid 11564 010226 15:59:55 mysqld ended bash-2.04# ./mysql.server start bash-2.04# Starting mysqld daemon with databases from /usr/local/mysql/var /usr/local/mysql/bin/safe_mysqld: line 254: 11600 Segmentation fault $NOHUP_NICENESS $ledir/$M

RE: Database Permissions

Jason There are 5 layers to access control in MySQL that are checked to see if a query can be executed. Starting from the most generic these layers are: User --> Db (and Host) --> Tables_priv --> Columns_priv The first layer that is found to have adequate privileges will cause the query to exe

please urgent

I have downloaded the leatest ver of php, php 4.04pl1, I am runing winnt 4.0, acording to the info for this ver of php this ver has all the odbc connetciones incluided, the ver 3.0 has a library called php3_oci80.dll wich is used for conections to oracle 8, where can I find all the librarys

MySQL driver - ClassNotFoundException

Hi, I'm new to MySQL database. I downloaded MySQL database version 3.23.32 and I create a table in the database (database name is "test_data" and the table name is "data"). Then I download the driver MyODBC 2.50.36 for NT(full setup) and fill out the table. I wrote a servlet program (run on Tom

Re: can create, cannot drop...?

At 09:11 26-02-2001 -0700, Geoff Coffey wrote: >Errno 21 on my system is EISDIR -- 'is a directory', which doesn't seem to >be an error at all... It is an error (that is why it starts with an 'E'). Appendix C of POSIX Programmer's Guide describes it as follows: "Attemp to open a directory for wr

RE: auto_increment

I'm using 3.22.23 :/ I think I may have to implement my own auto_increment to capture deleted id's. Thanx. John -Original Message- From: Atle Veka [mailto:[EMAIL PROTECTED]] Sent: Monday, February 26, 2001 1:53 PM To: John Tsangaris Cc: [EMAIL PROTECTED] Subject: Re: auto_increment

Re: mysql.server ignoring my.cnf?

Joel: I'll take another shot. Do you have spaces in your command? Remove them. Change : socket = /var/run/mysqld/mysqld.sock To: socket=/var/run/mysqld/mysqld.sock Cheers, Kent - Before posting, please chec

Re: auto_increment

John Tsangaris wrote: > > If I turn on auto increment and let it do it's thing and then later on > delete a few of the entries (let's say 1, 2, 3) and the current high entry > has an id of 45.. why does mysql continue with 46 instead of using up 1, 2, > and 3 first? Is there a way to bypass this

Re: auto_increment

On Mon, Feb 26, 2001 at 04:23:23PM -0800, John Tsangaris wrote: > > If I turn on auto increment and let it do it's thing and then later > on delete a few of the entries (let's say 1, 2, 3) and the current > high entry has an id of 45.. why does mysql continue with 46 instead > of using up 1, 2, an

Re: Patching w/o the compiler was Re: Replication time patch

Thanks that was the answer I was looking for. On our Linux side we can copile, but I'm doing development work at home on win2k and I don't have a current compiler (perl and java don't need C compilers). On Mon, 26 Feb 2001, Thimble Smith wrote: > Date: Mon, 26 Feb 2001 12:43:13 -0500 > From:

Re: auto_increment

what version of mysql are you using? AFAIK, this behavior is only supported in 3.23.x Atle On Mon, 26 Feb 2001, John Tsangaris wrote: > If I turn on auto increment and let it do it's thing and then later on > delete a few of the entries (let's say 1, 2, 3) and the current high entry > has an

auto_increment

If I turn on auto increment and let it do it's thing and then later on delete a few of the entries (let's say 1, 2, 3) and the current high entry has an id of 45.. why does mysql continue with 46 instead of using up 1, 2, and 3 first? Is there a way to bypass this? John --

load large data files?

From: lmfitzg To: [EMAIL PROTECTED] Subject: [50 character or so descriptive subject here (for reference)] >Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator: >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: <[

Re: mysql.server ignoring my.cnf?

While that is definitely the kind of pinheaded mistake that I'm used to making, that's not what's happening. I just looked at the file again and mysql.server is also ignoring things like the pid file and the log file :( thanks anyway At 12:51 PM 2/26/01 -0800, you wrote: > >make sure that you s

Re: mysql.server ignoring my.cnf?

make sure that you set the sock parameter in both the [client] and [mysqld] sections of the configuration file. This is one of my favorite errors :-/ Best, Kyle On Monday 26 February 2001 12:04, Joel Gwynn wrote: > I tried /etc/my.cnf and got the same results. As far as $DATADIR or $HOME > a

Compatable SQL for indexes

Hi, I am tring to find the most compatable way to write CREATE TABLE statments between mySQL and Postgress. Postgress has a CREATE INDEX as does mySQL, but I would like to be able to create Primary Keys and Indexes in the CREATE TABLE statment. The problem I am running into is that Postgress do

Re: MySQL, Linux and Hardware config

Check under ulimit to raise the number of file descriptors. ulimit -n # Linux has a global limit (4096 in debian' case) which may also be raised. However, as someone else has recommended, look at shortening the time you are actually connected. Connect, get data, disconnect, process d

Re: Security annoucement mailing-list ?

Hi! On Feb 26, Nicolas GREGOIRE wrote: > > > > I'd rather see them sent to the MySQL announcements list. It is > > already VERY low-traffic, and that seems like appropriate content. > > > > No sense creating another list just for the VERY occasional > > announcements when we already have one [

Database Permissions

Greetings, I'm having a little trouble understanding how the permissions work within mySQL. I have 3 current databases. The first is the default mysql database, and the other 2 are ones that I have created. I want to be able to grant access to each table individually based on username.

HAVING clause malfunction; probable bug

2001 Feb 26 Problem: HAVING clause malfunction I get wrong results when using certain combinations of filtering conditions in the HAVING clause. I'm calculating the total number of nights (Nights) and the average number of nights (AvgNights) that travelers stay in hotels. Below are the descrip

Re: mysql.server ignoring my.cnf?

I tried /etc/my.cnf and got the same results. As far as $DATADIR or $HOME are concerned, I don't see them when I do 'printenv'. Is there another way to find out if those may be set, and by what? thanks. At 02:33 PM 2/26/01 -0500, Kent Hoover wrote: >Sorry. Sent the last message before I was do

mysql.server ignoring my.cnf?

Sorry. Sent the last message before I was done If you have a stray $DATADIR/my.cnf or a $HOME/.my.cnf, their contents will override what you have set in /etc/my.cnf. Cheers, Kent - Before posting, please check: http://

mysql.server ignoring my.cnf?

Tried /etc/my.cnf in place of /etc/mysql/my.cnf ? Cheers, Kent - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread,

a query which cannot be fast even theoretically?

Your table bb is not indexed in a way that helps this query. Creating an index on min_number may help somewhat. If your intervals DON'T overlap each other, there's probably a much better algorithm for you to use than an SQL join. (e.g., select each number from aa in sequence, form a query for ea

clever head needed

Hi there! If any of you have tried the following with ASP/ADO and MySQL, please inform me of how you did it: I use ASP and adodb.recordset to connect to a MySQL-database. I use the following code to insert into the db: [CODE START] set rsGroup = server.CreateObject("adodb.recordset") sql = "tbl

mcrypt and encrypted field length

Please see my questions below - I asked the PHP list and no-one responded. Basically I'm new to "mcrypt" and I'm trying to use mcrypt and PHP with MySQL - I'd like to encrypt a 20-character field and store the result in a MySQL column, but I'm not sure 1. what data type to make the column -

Re: LIMIT usage

On Mon, Feb 26, 2001 at 06:19:46PM +0100, Joseph Bueno wrote: > Hi, > > I currently use a SELECT that looks like: > SELECT field > FROM some_table >WHERE some_condition > ORDER BY some_date DESC >LIMIT 2000 > > in order to get the most recent records from some_table. > > Since it

Replication

I would try running multiple MySQL servers on your backup host machine, where each one is a slave to its own respective master DB. I think that keeps maintenance of replication/recovery/restore scenarios much cleaner. If your Master DB A breaks, what you have to do to recover it from Slave A is si

mysql.server ignoring my.cnf?

I'm running mysql 3.23.33 on debian. I'm using /etc/init.d/mysql.server to start up and shut down mysql server. My configuration file is /etc/mysql/my.cnf. In that file, I've set my socket as follows: socket = /var/run/mysqld/mysqld.sock When mysql starts, it seems to ignore this di

Re: Security annoucement mailing-list ?

> I'd rather see them sent to the MySQL announcements list. It is > already VERY low-traffic, and that seems like appropriate content. > > No sense creating another list just for the VERY occasional > announcements when we already have one [mostly] for that purpose. It seems to be a good idea.

Help Installing MySQL

> I keep getting errors trying to install Mysql 3.23.33 on a Digital > Unix 4.0d alpha box. I am using gnumake 3.79.1 and gcc 2.95.2. > > The error message is as follow: > g++ -O3 -DDBUG_OFF -fno-implicit-templates -o mysqlbinlog > mysqlbinlog.o mini_cli > ent.o net_serv.o mini_client_errors.o vio

Re: Security annoucement mailing-list ?

On Mon, Feb 26, 2001 at 04:34:20PM +0100, Nicolas GREGOIRE wrote: > > is it possible to create (I don't think it already exists) a > mailing-list just for security problems about MySQL. > > I'm very concerned about the security of my web sites, and I rely on > MySQL to provide dynamic content. >

GUI

Hi from the UK, Firstly just let me say how cool and NON microsoft MySQL is. It is a BRILLIANT PIECE OF SOFTWARE. Second - help!! I have just downloaded Win32 static binary of MySQLGUI 1.7.4-2 onto my (sadly) IBM PC and when I've unzipped it and run it, it asks for a password. (I may have

Re: Patching w/o the compiler was Re: Replication time patch

On Fri, Feb 23, 2001 at 03:35:06PM -0800, William R. Mussatto wrote: > Your reply triggered a question? > > If you are on a win32 box and using the binary builds, what is the > proceure for getting these patchs? Last time I checked the site is was > still showing 3.23.33 as the current release

Re: Berkeley DB and mysql

Hi, I get an error at "make install" because mySQL did not correctly modify BDB's Makefile (which has been slightly changed). mySQL tries to modify the "install" target of the Makefile so that ist does only contain install: all instead of additional "install_xxx"'s. Previously there was _one

LIMIT usage

Hi, I currently use a SELECT that looks like: SELECT field FROM some_table WHERE some_condition ORDER BY some_date DESC LIMIT 2000 in order to get the most recent records from some_table. Since it is not possible (yet) to optimise an ORDER BY ... DESC by using an index; is it possib

Re: Berkeley DB and mysql

Bill Rossi wrote: > I recently tried to build mysql version 3.23.33, with support for Berkeley > DB. I was using BDB version 3.2.9, and was unable to compile mysql with > this version of BDB. > > Is this a known problem, an if so, what version of BDB should I use with > mysql? MySQL rolls

Re: Hi,AW: LOOKING FOR A FRONTEND FOR MYSQL

Try phpmyadmin in www.phpwizard.com >From: "Denis Mettler" <[EMAIL PROTECTED]> >To: "j.urban" <[EMAIL PROTECTED]> >CC: <[EMAIL PROTECTED]> >Subject: Hi,AW: LOOKING FOR A FRONTEND FOR MYSQL >Date: Mon, 26 Feb 2001 17:13:55 +0100 > >Hi, > >Check out MysqlGUI at www.mysql.com >I think it's the best

using parameters

HI, Is it possible to do a select-statement like this: select * from @parameter ? Thanks, Marijke Find the best deals on the web at AltaVista Shopping! http://www.shopping.altavista.com - Before posting, please check: http:/

Re: Redhat 7 newbie.....

Thomas O'Neill wrote: > I just installed Redhat 7.0 and MySql while i was at it. But the deamon is not >running. I get the > > ERROR 2002: Can't connect to local MySQL server through socket >'/var/lib/mysql/mysql.sock' (111) > > when i try to use the client. Could someone please clue me in as

RE: Security annoucement mailing-list ?

Hi all I find the MySQL mail service very useful but he has a point hat due to the number of e-mails form this list it mite be an idler to split things up a bit? Simon Green ISE -Original Message- From: Nicolas GREGOIRE [mailto:[EMAIL PROTECTED]] Sent: 26 February 2001 15:34 To: [EMAIL PR

mysql.server ignoring my.cnf?

I'm running mysql 3.23.33 on debian. I'm using /etc/init.d/mysql.server to start up and shut down mysql server. My configuration file is /etc/mysql/my.cnf. In that file, I've set my socket as follows: socket = /var/run/mysqld/mysqld.sock When mysql starts, it seems to ignore this di

Re: Antwort: tab-completition not working with libreadline4

On Mon, Feb 26, 2001 at 03:02:41PM +0100, [EMAIL PROTECTED] wrote: > > Since a few weeks tablename completition using tab is not working any longer. > Are you sure that the table information is actually read at start of mysql? Do > a 'rehash' and see if it works then. Cool that helped, thank you.

Re: Error while trying to run binary mySQL on FreeBSD4.0

Drew, the binary was compile for BSDi 4.2, if you have gcc 2.95 installed try compiling from source. You will have other problems though as there are many bugs with threads on 4.0 BSDi. Is there any way you can upgrade to 4.2? Ken - Ken Menze

Re: missing library libz.so

Hi Rutger, The problem is you can't just drop the library anywhere. I am guessing from you message that you do not have root privleges on the server. I doubt that you will be able to add a shared library without root access. The second problem I see you may have is the the binary was compile

Stop while configure.

>Description: When I tried to run configure, I got stuck, couldn't find right answer in your documents. Followed are the last lines on the screen. loading cache ./config.cache checking for a BSD compatible install... ./install-sh -c checking for bison... no checking for byacc... no checki

  1   2   >