RE: [Fwd: Studying mysql]

seems to be an apache problem Hav u setup Apache-php properly IF yes, are u able to access other php pages? -Original Message- From: Wil van der Krogt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 11:43 AM To: mysqllist Subject: [Fwd: Studying mysql] Original Mes

[Fwd: Studying mysql]

Original Message Subject: Studying mysql Date: Tue, 11 Jun 2002 14:49:24 +0200 From: Wil van der Krogt <[EMAIL PROTECTED]> CC: mysqllist <[EMAIL PROTECTED]> Hello Listreaders, I'm new on this list and i'm trying to get a mysql database working on my workstation. I work with t

Re: security paranoia

On Tue, 11 Jun 2002, MikeParton wrote: > Where in the MySQL docs does it discuss DES_ENCRYPT/DES_DECRYPT support? > > Alternatively (and I am posting this to the php lists), anyone know where, > or if, I can get pre-compiled libmcrypt library for php 4.2.1? http://www.mysql.com/doc/M/i/Misce

Re: Autocommit

Serge Paquin wrote: > Hello, > > I am setting up mysqld-max with InnoDB Tables. How can I set autocommit to >off? I want this a global option for the DBMS. Did you read the docs? There is even an example (chapter 7.5.8.6). Oliver --

error using mysql with phpmyadmin

Has anyone ever had an error when using phpmyadmin to access MySQL similiar to the following error: Warning: Wrong parameter count for extract() in ./libraries/grab_globals.lib.php3 on line 18 I could not find the answer in any other lists. Any assistance in how to correct this might be appreci

about default privileges 2

mysqlproblem still.prompt:"error 1045: access denied for user:'@localhost'(using password:no)".i do 'status' from the mysql prompt,it display current user:odbc@localhost,but i dont creat the odbc user. >do a 'flush privileges' from the mysql prompt. That should solve the >problem. >

Re: Unable to connect to remote mysql server.

hi which port no are you referring to ? i even tried : mysql -h 202.157.188.2 -u root -port=3306 -p but it doesn't work. please advice. thx ally - Original Message - From: "Sherzod B. Ruzmetov" <[EMAIL PROTECTED]> To: "Gerald Clark" <[EMAIL PROTECTED]> Cc: "ally" <[EMAIL PROTECTED]

Re: Licenseing Issue

As far as I understand I think you don't need one, but I suggest you to buy one to support MySQL! :) for your customer, only those who install MySQL need MySQL license. Borus - Original Message - 寄件者: "Michael Ivanyo" <[EMAIL PROTECTED]> 收件者: "mysqllist" <[EMAIL PROTECTED]> 傳送日期: 2002

Re: Licenseing Issue

Somebody will ... make it clear in whatever licensing statement you have that the end-user is responsible for licensing third-party components. - Original Message - From: "Michael Ivanyo" <[EMAIL PROTECTED]> To: "mysqllist" <[EMAIL PROTECTED]> Sent: Tuesday, June 11, 2002 10:24 PM Subject

about default privileges 2

mysqlproblem still.prompt:"error 1045: access denied for user:'@localhost'(using password:no)".i do 'status' from the mysql prompt,it display current user:odbc@localhost,but i dont creat the odbc user. >do a 'flush privileges' from the mysql prompt. That should solve the >problem. >

Licenseing Issue

I do not fully understand the license requirements and have a question. The application that I am developing will be able to work with either MySql, Postgres, or Oracle. Will I still need a license if the user decides to connect to a MySql database? --Michael __

Fw: Locked tables

| Hi, | | we have a large database which receives many questions and inserts | all the time. | | we are facing a problem, for it is holding some queries longer than | desired. we got | some statistics from the process list that shows the below | information. Seems that |

aix 4.3.3 problems

I installed the binary from www.mysql.com for the stable release on aix 4.3.3 -- I am getting the following errors from the libz.a library. I haven't been able to solve the problem. Anyone out there run into this problem?? The one I get from the bull site seems to generate a bunch of defunct

about default privileges 2

mysqlproblem still.prompt:"error 1045: access denied for user:'@localhost'(using password:no)".i do 'status' from the mysql prompt,it display current user:odbc@localhost,but i dont creat the odbc user. >do a 'flush privileges' from the mysql prompt. That should solve the >problem. >

Need help with database design

I would like to set up a MySql database that will store distance information for a milage lookup program. The user will enter the origin city and the destination city for some predefined trips. Then the query will need to return the milage broken down by state. For example, for an origin city i

Re: Subselect translation?

Wouldn't "select table1.id from table1, table2 where table1.id != table2.t1id and table2.id = 9" work? Joins don't have to include output columns from both tables, but columns from both tables can (and should, unless you want cartesian products) appear in the WHERE clause. -Mark - Origina

about default privileges 2

mysqlproblem still.prompt:"error 1045: access denied for user:'@localhost'(using password:no)".i do 'status' from the mysql prompt,it display current user:odbc@localhost,but i dont creat the odbc user. >do a 'flush privileges' from the mysql prompt. That should solve the >problem. >

list

mysql£¬ÄúºÃ£¡ Ö Àñ£¡ hjf [EMAIL PROTECTED] 2002-06-12 - Before posting, please check: http://www.mysql.com/man

Re: Mysql..Python..

> My sense is that it's not as popular for use with MySQL as PHP or > Perl, but yes, there are people using it. A few of the MySQL books > out there have descriptions of how to use the Python interface for > MySQL, and (shameless plug) it's one of the 4 languages covered in > the upcoming MySQL C

Re: MySQl and Dot Net

Here is an online store using MySQL and .NET. Source code for both VB.NET and C#.NET is included. http://www.WeDoNET.net Fredrick - Original Message - From: "mosbah ejebali" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 11, 2002 10:38 AM Subject: MySQl and Dot Net > >

Re: ROOT Access Denied !!

Thank you Ray, this worked! Colin on 6/11/02 2:59 PM, Ray at [EMAIL PROTECTED] wrote: > mysql --password > (or just -p) > > On Tuesday 11 June 2002 7:30, you wrote: >> When I try to connect to mysql as 'root' I get the following: >>> [localhost:/Users/cooldaze] root# mysql >>> ERROR 1045: Ac

Autocommit

Hello, I am setting up mysqld-max with InnoDB Tables. How can I set autocommit to off? I want this a global option for the DBMS. Thanks, Serge. - Before posting, please check: http://www.mysql.com/manual.php (th

Re: about default privileges

do a 'flush privileges' from the mysql prompt. That should solve the problem. Regards, Bhavin. - Original Message - From: "slz" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 11, 2002 6:11 PM Subject: about default privileges hi: I have finish install the mysql in my w

about default privileges

hi: I have finish install the mysql in my win2k.And set a password for root and remove the row in the mysql.user table that has Host='localhost' and User=''.But i can connect to the mysql host and watch my tables when i type "c:\mysql\bin\mysql"!It is security mistakes.how to cancle it?

Re: Subselect translation?

I believe the following query will do what you want it to do: SELECT t1.id from table1 as t1 LEFT JOIN table2 as t2 on t2.t1id = t1.id AND t2.id = 9 WHERE t2.id IS NULL; More information can be found at http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html about sub-select work arounds. Hop

about default privileges

hi: I have finish install the mysql in my win2k.And set a password for root and remove the row in the mysql.user table that has Host='localhost' and User=''.But i can connect to the mysql host and watch my tables when i type "c:\mysql\bin\mysql"!It is security mistakes.how to cancle it?

about default privileges

hi: I have finish install the mysql in my win2k.And set a password for root and remove the row in the mysql.user table that has Host='localhost' and User=''.But i can connect to the mysql host and watch my tables when i type "c:\mysql\bin\mysql"!It is security mistakes.how to cancle it?

A DB Design Question

Hello to all, I would like to set up a MySql database that will store trip information for a milage lookup program. The user will enter the origin city/st and the destination city/st for some predefined trips. Then the query will need to return the milage broken down by state. For example, for

Re: newbie backup restore question

Once mysql is installed on the new system, you should be able to copy the old data directory onto the new and you should be good to go(make sure the permissions and the ownership are preserved) . Regards, Bhavin. - Original Message - From: "Scott" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED

newbie backup restore question

I have a mysql database that I backed up by copying my /var directory to a cd before I installed a new release of linux. How do I restore it on the new system? Do I need to create the database in the new version of mysql first, or just copy some files from the old data directory into the new

mysql@lists.mysql.com

>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release:

Re: mysql Digest 11 Jun 2002 13:45:36 -0000 Issue 1945

On Tue, 11 Jun 2002, Trevor Phillips wrote: > Date: Tue, 11 Jun 2002 13:27:53 +0800 > From: Trevor Phillips <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Problem with Escaping quotes > > I'm writing some routines which generate SQL queries, and I'm trying to > keep things generic. As su

Re: MySQL AB: Need documentation clarification

> both InnoDB and MyISAM keep also dynamically statistics about tables. In > most cases running ANALYZE TABLE does not bring any benefit in query > optimization. Personally, I'm pretty shocked to hear you say this. I was under the impression that running ANALYZE TABLE was a "good thing" and helpe

Re: Query problem

Now it has transformed into this: "); } else{ print( "Non riesco a connettermi al server."); exit; } $user=$_POST['user']; $password=$_POST['password']; $query=(mysql_query("select * from admin where User='%$user%'",$link)); $row = mysql_fetch_array($query); if($row["user"]==$user

Subselect translation?

Hi, I have a little problem making a query with only one SELECT phrase; I wan't to solve this with a JOIN since sub-selects are not supported in MySQL: select table1.id from table1 where table1.id not in(select table2.t1id from table2 where table2.id = 9) I can't imagine this not being possible

Query problem

Hi all, it's the first time i use this ML and i'm pretty new to php and sql so please excuse me for every well known thing i say. I'm trying to make a little login routine. Here i post my code: "); } else{ print( "Can't connect to the server."); exit; } $user=$_POST['user']; $password=$

Re: security paranoia

Where in the MySQL docs does it discuss DES_ENCRYPT/DES_DECRYPT support? Alternatively (and I am posting this to the php lists), anyone know where, or if, I can get pre-compiled libmcrypt library for php 4.2.1? TIA - Original Message - From: "Tonu Samuel" <[EMAIL PROTECTED]> To: <[EMAI

Re: MySQLHost? What MySQLHost?

P Willmington wrote: > Hi, > > OK - Here's plain text. I don't know anybody else that uses it, so let's see > if you accept it THIS time! You'd be suprised how many of us prefer to read the content without any flashy additions (content vs. style, I suppose). Anyway. > I have a network made

MySQLHost? What MySQLHost?

Hi, OK - Here's plain text. I don't know anybody else that uses it, so let's see if you accept it THIS time! I have a network made up of two PCs, one is Win98 and the Server is Linux. I am not using NIS, preferring to use "host" instead. I can ping each machine at either end and Samba works just

Re: Mysql..Python..& ..MSQLdb

I haven't used Python...I use PHP and MySQL...I've found PHP does everything I have asked it to do (and I have a lot more to work with). And, it has been incredibly easy to pick up and use. - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "R Talbot" <[EMAIL PROTECTED]>; <[

Re: ROOT Access Denied !!

Add -p to the command line. [localhost:/Users/cooldaze] root# mysql -p On Tuesday 11 June 2002 09:30, Colin Cooler wrote: > When I try to connect to mysql as 'root' I get the following: > >[localhost:/Users/cooldaze] root# mysql > >ERROR 1045: Access denied for user: 'root@localhost' (Using pas

Re: Mysql..Python..& ..MSQLdb

At 16:30 -0400 6/11/02, R Talbot wrote: >I have been using perl and Mysql together but have >decided to try python and Mysql together. > I download and extracted MYSQLdb 0.35-1 from Andy Dustman's page. >The module does not seen to have instructions for use. Can anyone point >me to intructions or

Which Language to use

Afternoon We are currently using MySql to drive our web server. We are in the process of pondering the thought of using it for our meat and potatoes applications. The problem/blessing is that our current database is Informix which comes with its own 4gl. In order for us to move to MySql we would

Re: Advise Requested: Troubleshooting Perl/Mysql/Sendmail Performance

On Tue, 11 Jun 2002, Keith Smith (E-mail) wrote: > The system: a perl mailing list tool which accepts add/deletes via > emails (sendmail piped) and then updates the backend database > accordingly. > > The problem: once about 10 or more emails arrive, I begin to get > performance problems from t

Re: mysqld refusing connections while getting sloooow

Dear Gelu, > This is a specific behaviour for tables which are not properly indexed. Looks like my friend needs more RAM and better indexing :-) Thanks! Regards, -- Stefan Hinz <[EMAIL PROTECTED]> CEO / Geschäftsleitung iConnect GmbH Heesestr. 6, 12169 Berlin (German

Re: mysqld refusing connections while getting sloooow

Dear Nilesh, > I think increasing memory and giving more memory to MySQL would help. I will advice my friend to buy more RAM, faster harddisks (good for the hardware industry, too), and to do better indexing :) Thanks! Regards, -- Stefan Hinz <[EMAIL PROTECTED]> CEO / Geschäftsleitung iCon

Mysql..Python..& ..MSQLdb

I have been using perl and Mysql together but have decided to try python and Mysql together. I download and extracted MYSQLdb 0.35-1 from Andy Dustman's page. The module does not seen to have instructions for use. Can anyone point me to intructions or examples. My purpose is a user friendly GUI

Advise Requested: Troubleshooting Perl/Mysql/Sendmail Performance

Hi: I'm hoping you can lend some helping thoughts The system: a perl mailing list tool which accepts add/deletes via emails (sendmail piped) and then updates the backend database accordingly. The problem: once about 10 or more emails arrive, I begin to get performance problems from the Linu

Re: license...

On Tue, 11 Jun 2002, Colin Faber wrote: > According to the Arguments document this isn't true. The API's are > published under the LGPL license and are not governed by the same > restrictions as the server it self. 3.23.x API is LGPL 4.x is API is GPL 3.23.x and 4.x servers are both GPL Own

Re: security paranoia

On Tue, 11 Jun 2002, Ray wrote: > looking for something like > encrypt(str, protected_str) > and > decrypt (crypt_str, private_str) > and probably a make_key_pair() > > its not a vital part of my current project, but i'm sure someone will get > cracked into (again) and then there will be anothe

security paranoia

i'd like to setup a system that would allow for sensitive information to be encoded (like cc numbers), however having different keys for encoding & decoding the data. found these in the manual, but they use the same pass_str. ENCODE(str,pass_str) Encrypt str using pass_str as the password. To

Re: not able to edit table:((

The mysql user was not granted write permission on the database? Anil Garg wrote: >The persmissions seems to be ok. >ne other ideas!! >- Original Message - >From: "Kiss Dániel" <[EMAIL PROTECTED]> >To: "Anil Garg" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> >Sent: Tuesday, June 11, 2002 12:

Re: Errno 13 on starting mysqld (Suse 8)

MySQL doesn't own the files. chown -R mysql /var/lib/mysql eh wrote: >Errno 13 on starting mysqld > >I am using SUSE 8.0 >on a 586 computer >I installed MYSQL 3.23.48 from the Suse-CD (By the while four times) > >At first I was running (as described in >/usr/share/doc/packages/mysql/README.Su

Re: mysql auto_increment question

Taylor Lewick wrote: >Hi all. I have searched the documentation, and i found some info, but I wanted to ask >the lsit a little more about auto_increment. > >First, if I use auto_increment, and then delete a field, I assume mysql leaves the >remaining fields with the original numbers... >i.e.

Update problem

Good afternoon! I have a table of subscribers from which I select data to create another table which will indicate which of these subscribers should get a reminder letter. I need to set a column in the subscriber file indicating the date of the reminder, so that the subscriber will not be sent an

Re: Database renaming?

Any permissions set for users on the database will be invalid. Martin Rode wrote: >Hi there, > >I was wondering if I can rename a MySQL instance (MyISAM) by simple >stopping the server and rename the data directory? A quick test did not >show any problems. I am now wondering if I can get other p

MySQL DBA wanted

> Sorry for Job posting. Looking at the popularity of MySQL it would be > better if there is separate mailing list for Job Offered/Wanted for > MySQL. > > We are SIP based VoIP company located in Edision,NJ,USA looking for > MySQL DBA with 1-2 years of solid MySQL experience. Experience with

ROOT Access Denied !!

Hi, Try using the following command: mysql -u root -p Where is the name of the database you wish to use. If everything works you will get the password prompt: [root@nms-des root]# mysql -u root -p telefonia Enter password: Then put your root password (by default is null - simply press ent

Re: mysqld refusing connections while getting sloooow

Hi, My opinion is: This is a specific behaviour for tables which are not properly indexed. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Ori

ROOT Access Denied !!

When I try to connect to mysql as 'root' I get the following: >[localhost:/Users/cooldaze] root# mysql >ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) I can connect as a normal user, but can't create any databases or do other necessary admin functions, so I need to be

Errno 13 on starting mysqld (Suse 8)

Errno 13 on starting mysqld I am using SUSE 8.0 on a 586 computer I installed MYSQL 3.23.48 from the Suse-CD (By the while four times) At first I was running (as described in /usr/share/doc/packages/mysql/README.Suse ) "rcmysql start" as root from /var/lib/mysql/ (and later from /usr/bin/) C

RE: mysqld refusing connections while getting sloooow

I think increasing memory and giving more memory to MySQL would help. Nilesh -Original Message- From: Jared Richardson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 1:48 PM To: Stefan Hinz; [EMAIL PROTECTED] Subject: Re: mysqld refusing connections while getting slw We'v

query

When I try to make a backup executing the sql: backup tb_name1, tb_name2 to 'c:\temp' and I have a error like "Failed copying .frm file: errno =3D 2" What I have to do in this case. Regards Alexander A busca mais veloz e precisa da internet. Acess

RE: How to set max_connections ?

Do I need to have some kind of permissions to change a variable ? Thanks, Rekha -Original Message- From: Steve Katen [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 6:17 PM To: Rekha Das; '[EMAIL PROTECTED]' Subject: Re: How to set max_connections ? what do you mean it doesn't d

Re: mysqld refusing connections while getting sloooow

We've seen very similar behavior when there are very long SQL queries being run that are disk intensive.. generally speaking, something is having to traverse the table (or a temp table) line by line. If he has any logging capability, see long each SQL query is taking to return to his app then cle

RE: MySQl and Dot Net

[snip] Hi all I need you help can I use MySql database with .Net Freamwork ? I'm programming with VB.Net thnks [/snip] Yes, ODBC. HTH! Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) h

MySQl and Dot Net

Hi all I need you help can I use MySql database with .Net Freamwork ? I'm programming with VB.Net thnks _ Téléchargez MSN Explorer gratuitement à l'adresse http://explorer.msn.fr/intl.asp. --

Re: Cannot use mysql as

HI, Egor: Thank you very much for your help. I had this MySQL before. NOw it is working after I did as you told. Thanks again! Duo> 9DF12, > Monday, June 10, 2002, 8:57:10 PM, you wrote: > > 9> I have just installed and run my mysql server as the root user. I > have > 9> entered > 9> the MYSQL mi

Re: not able to edit table:((

The persmissions seems to be ok. ne other ideas!! - Original Message - From: "Kiss Dániel" <[EMAIL PROTECTED]> To: "Anil Garg" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, June 11, 2002 12:59 PM Subject: Re: not able to edit table:(( > Greetings, > > Stop the MySQL server and

programming for Oracle and Mysql

Dear all: Thanks to those of you who responded to my 'scripts needed' email. Programming for Oracle and MySQL - is the syntax for both of these products VERY different ? Or are they pretty close ? Oracle uses PL/SQL (which I know a bit) but what does MySQL use ? Is it worlds apart from PL/S

RE: How to set max_connections ?

Where can I get a sample my.cnf? Thanks, Rekha -Original Message- From: Steve Katen [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 6:17 PM To: Rekha Das; '[EMAIL PROTECTED]' Subject: Re: How to set max_connections ? what do you mean it doesn't do anything? you should be able t

mysqld refusing connections while getting sloooow

Dear list, a friend of mine asked for assistance on the following problem (which I cannot solve myself): He has a mysqld 3.23.38 running on Linux, with 2 cpus (400 MHz celeron) and 512 MB ram. mysqld runs as a production server, with some applications running about 80 queries per second. There a

Re: not able to edit table:((

Greetings, Stop the MySQL server and check the table files. I think they are read only if you use Win32, or under Linux the user 'mysql' does not have the write right to the tables or its directories In the last case: chmod 660 * and/or chown mysql:mysql * At 12:39 2002.06.11. -0400, you wro

Re: license...

Hi, According to the Arguments document this isn't true. The API's are published under the LGPL license and are not governed by the same restrictions as the server it self. Also regarding GPL'd software. Should you develop software to interface MyODBC or MySQL that is completely up to you. You

mysql auto_increment question

Hi all. I have searched the documentation, and i found some info, but I wanted to ask the lsit a little more about auto_increment. First, if I use auto_increment, and then delete a field, I assume mysql leaves the remaining fields with the original numbers... i.e. if I haverows 1 through 10 and

not able to edit table:((

Hi, I am not able to edit a table: the sql queries i tried are follows: >delete form documents where id = 134;gives the following error: error: table documents is read only repair doesnt seem to work repair table documents; Table Op Mst_typeMsg_text mydb.docume

Re: problem with mysql threads on freebsd

On Tuesday 11 June 2002 16.30, Dan Nelson wrote: > In the last episode (Jun 11), Leo De Geer said: > > im not abel to get mysql to use more then one thread on my freebsd > > 4.5-stable any one having a klue that wrong? > > Do not assume that the way Linux manages threads is the only one. > Mys

RE: Is Table Name 'PURGE' ALLOWED

Hi, > To answer my own question yes this word is reserved. Yes, it is reserved, but you may still use it any query that you like, by quoting the name. To take from the manual: "Note that if the identifier is a restricted word or contains special characters you must always quote it with ` when y

Database renaming?

Hi there, I was wondering if I can rename a MySQL instance (MyISAM) by simple stopping the server and rename the data directory? A quick test did not show any problems. I am now wondering if I can get other problems which I have not encountered so far. Please reply to my mail, I'm no subscriber

mysql@lists.mysql.com

>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator: >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release: my

Re: Possible bug -- enum element is single space, but this is invalid as

David, Tuesday, June 11, 2002, 3:28:52 PM, you wrote: DH> I have encountered a strange problem with the enum type in version DH> 3.23.49. It may be a bug, but I'd be grateful to hear comments. DH> Here's a short example which illustrates the problem. First, I create DH> a table with an enum colu

Re: on delete cascade

Pierre, Tuesday, June 11, 2002, 4:51:16 PM, you wrote: PB> does mysql-max 3.23.50 support the option on delete cascade for the PB> foreign key, the documentation is not very clear on this point Yes, since 3.23.50 MySQL supports ON DELETE CASCADE and ON DELETE SET NULL on InnoDB tables. PB> Pie

Re: Reg. Host Problem in MYSQL

Arulmanikandan, Tuesday, June 11, 2002, 5:21:40 PM, you wrote: A>I installed MySQL from your site.After setup.exe i A> followed your instructions. A> When i want to check the installtion by the following A> command A> D:\mysql\bin>mysqlcheck -h=pc271 mysql A> it gives the error. A> m

Re: problem with mysql threads on freebsd

Hello, Out of curiosity--Is this the key reason that Yahoo finance switched from FreeBSD to Linux? :-) \\sql\\ -- Patrick Hsieh <[EMAIL PROTECTED]> GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg - Before posting, pl

Re: How to set max_connections ?

Hello Steve Katen <[EMAIL PROTECTED]>, How do you tell the number of connections currently in use? On Mon, 10 Jun 2002 18:17:19 -0700 Steve Katen <[EMAIL PROTECTED]> wrote: > what do you mean it doesn't do anything? > > you should be able to set it on the command line as: > > --set-variable=

Re: problem with mysql threads on freebsd

Hello Leo De Geer <[EMAIL PROTECTED]>, > the problen nr 2 i dont have but the server we have dont handle the load on > one cpu. at the moment we are runing the sql on a linux instead (same > hardwere) but i sucks. alla auter servers is freebsd and they run mutch beter > Why MySQL on Linux suc

RE: stupid question

I am assuming this is not a MySQL question since MySQL interacts with SQL commands that are all in characters. try using strstream. You can poke just about anything into it and get a string out. If you must have a char*, then use the c_str() function of the string class. The best implementatio

Re: Is Table Name 'PURGE' ALLOWED

I get the ID-10-T award of the day. http://www.mysql.com/doc/R/e/Reserved_words.html To answer my own question yes this work is reserved. PEBKAC Thank You /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\ Does mysql allow you to name your table

Is Table Name 'PURGE' ALLOWED

Does mysql allow you to name your tables anything. I created a table called 'purge' and insert 3 field purgeday, purgemonth, purgeyear. ALL of the fields are set to INT or INT NOT NULL. When I try to add a record to this table I get and error 'SELECT * FROM purge LIMIT 0,50' Anyone have a clu

Re: license...

- Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 11, 2002 10:03 AM Subject: Re: license... | Silmara, | Monday, June 10, 2002, 10:19:28 PM, you wrote: | | SCB> I'm developing a program, that is not free software and i'm usi

Re: problem with mysql threads on freebsd

In the last episode (Jun 11), Leo De Geer said: > im not abel to get mysql to use more then one thread on my freebsd > 4.5-stable any one having a klue that wrong? Do not assume that the way Linux manages threads is the only one. Mysql on FreeBSD does create threads; they are just not visibl

Reg. Host Problem in MYSQL

Hi, I installed MySQL from your site.After setup.exe i followed your instructions. When i want to check the installtion by the following command D:\mysql\bin>mysqlcheck -h=pc271 mysql it gives the error. mysqlcheck: Got error: 2005: Unknown MySQL Server Host '=pc271' (11001) when try in

Re: license...

Silmara, Monday, June 10, 2002, 10:19:28 PM, you wrote: SCB> I'm developing a program, that is not free software and i'm using mysql with SCB> myodbc. The question is if i need a license or not... Yes, you need license. Using any of MySQL API's for commercial programs requires licences. Please

RE: on delete cascade

[snip] does mysql-max 3.23.50 support the option on delete cascade for the foreign key, the documentation is not very clear on this point [/snip] No , it does not. Jay sql, mysql, query - Before posting, please check: http

on delete cascade

does mysql-max 3.23.50 support the option on delete cascade for the foreign key, the documentation is not very clear on this point Pierre -- sql,query - Before posting, please check: http://www.mysql.com/manual.php (th

Studying mysql

Hello Listreaders, I'm new on this list and i'm trying to get a mysql database working on my workstation. I work with the Powerpack distribution from Linux Mandrake edition 8.0. For the moment I don't have installed an ethernet card for server facillities. I do everything from the KDE desktop env

Re: Unable to connect to remote mysql server.

The port number is wrong. Change it to 3306, and u should be fine. :>I hv mysql server running on a remote machine(ip 202.157.188.2) and i'm :>trying to connect to it by ssh from another machine(ip 202.157.137.97) as :>follows : :> :>$ mysql -h 202.157.188.2 -u root -p :>Enter password:

Re: Unable to connect to remote mysql server.

1. What does this have to do with ssh? 2. Does root@yourmachine have permission to connect to mysqld on 202.157.188.2? ally wrote: > Dear all, > >I hv mysql server running on a remote machine(ip 202.157.188.2) and i'm >trying to connect to it by ssh from another machine(ip 202.157.137.97) as >f

RE: MySQl price

Well, I'm under the impression that if the application you're selling provides links to MySQL but not the database itself you don't have to pay for a license for each sale; it's up to the buyer of the app to obtain a MySQL license. I'd sure talk to someone at mysql.com, though. --Walt Weaver B

RE: Reseting auto_incremented id's

[snip] Is there any way to reset this id field to 0 when I am done processing the users? I read this can be accomplished by an myisamchk. But I do not want to have system calls thru my script? Is there any other way to do this? [/snip] TRUNCATE tablename Empties the table and resets the A

  1   2   >