Re: longtext

Hi, > my question is: is it possible to load in a Longtext column > a .txt file? furthermore, is it possible to do that with a .xml file? of course.. at first you must use seperator, field-encloser and line-terminator, which is not contained in your data. for example this way: SELECT * FROM YOU

longtext

Hello, I'm a MySQL newbye... my question is: is it possible to load in a Longtext column a .txt file? furthermore, is it possible to do that with a .xml file? Thanks in advance, Maurizio Megliola TXT e-solutions S.p.a. Tel.:+39.010.3536634

RE: recursive select

Ah recursion. Nothing like it to get your mind tied up in knots... :) Try this - untested, but this is the basic idea, and it or something like it should work. Call the function with the node you want to start from and the array you want the results to land in... Like so: > -Original M

sorry, it's a test

sorry, it's a test database,sql,query,table - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PRO

URGENT Help pl.

Hi all, I need to convert the records from mysql database into MS.Access. I don't have ODBC.The mysql is in different machine(stand alone).So i need to convert that into a flat file then put into MS-Access. Can u pl.help me in this regard. It's very urgent.It'll b very much useful if i get a r

Data Directory

Hello, I am new to both Linux and MySQL. I used the source to compile MySQL on Linux 7.0 with the default options. It's working fine. But can i change the data directory where all the databases are stored to something other than the default, without having to compile again? Any help would be a

Re: how to install mysql replication?

I'm only a digest subscriber, so I apologise in advance for any mis-quotes: Ok here is my experience with MySQL replication: 1) it's been very stable, and haven't noticed any drift in the replicating servers 2) we have ~7 replicating servers-- 3 in circular replication which recieve all of the up

re:re: startup Help

Thank you, but what does exactly does that mean. An example would help. m. >On Tue, 12 Jun 2001, Martin Scherer wrote: > > > I am told that mysqladmin is not an understood command. > >Looks like you need to update your PATH variable. > >Neil

Re: startup help

At 7:00 PM -0700 6/12/01, Martin Scherer wrote: >I purchased the mysql msql book from O'Reilly as well as another >mysql book with a CD. I loaded the 3.22 versions to a windows and >also to a Linux machine. It took me quite a while to determine >where the files were located on the Linux mach

Re: user variables

At 3:16 AM +0200 6/13/01, Luis A. Fdez. de Retana Aguirre wrote: >Hello, > > My problem is about users variables. I want to do >a script to create a database so: > SET @dbname:="mydbname"; > CREATE DATABASE @dbname;# <-- Don´t >work > CREATE DATABASE (SELECT @dbname);# <--

Re: mysql.sock not created

Thanks for the reply Conducting a 'find' does not turn up the mysql.sock file anywhere on my server. Is there any reason why the installation would not create this file? MySQL did create a directory under /var/lib called mysql, but mysql.sock is not in there. As stated, I'm running a Cobalt Ra

Re: recursive select

Hi, > I'm having a slight problem trying to figure out some logic. I have a > mySQL table that contains 3 columns (child, category, parent). > What I like to do is retrieve all the childrens of the parent and store > them in an php array. I assume you want to get all children for all parents (so

Re: mySQLGUI Error

No, you need to add a user to MySQL that is allowed access from that host. See the GRANT statement in the manual. I'm also betting that that is a dynamic IP address in which case you'll probably have to setup a user with access from 192.168.0.% - Original Message - From: "Anthony Olugben

mySQLGUI Error

I am trying to use MySQL GUI client on W2K to connect to MySQL server running on RedRat Linux 7.1 and I am getting the following error Host '192.168.0.152' is not allowed to connect to this MySQL server. Do I need to change something on my Linux?

Re: MYSQL error

It is Read The Fine Manual. - Original Message - From: "Simon Green" <[EMAIL PROTECTED]> To: "'Aldo Spano'" <[EMAIL PROTECTED]>; "Rolf Hopkins" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, June 12, 2001 6:58 PM Subject: RE: MYSQL error > Read The Manual = RTFM > > > > You

recursive select

Hi, I'm having a slight problem trying to figure out some logic. I have a mySQL table that contains 3 columns (child, category, parent). What I like to do is retrieve all the childrens of the parent and store them in an php array. Any advies on this issue will be very helpful. Thanks in adva

Re: startup help

On Tue, 12 Jun 2001, Martin Scherer wrote: > I am told that mysqladmin is not an understood command. Looks like you need to update your PATH variable. Neil - Before posting, please check: http://www.mysql.com/manual.php

startup help

I purchased the mysql msql book from O'Reilly as well as another mysql book with a CD. I loaded the 3.22 versions to a windows and also to a Linux machine. It took me quite a while to determine where the files were located on the Linux machine as the installation process was done by CD. I

Re: Re: how to install mysql replication ?

On Wed, Jun 13, 2001 at 12:49:22AM -, [EMAIL PROTECTED] wrote: > database,sql,query,table - which is really too constricted! On Tue, Jun 12, 2001 at 04:10:44PM -0400, Jim Ziegler wrote: > 010410 16:37:24 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' >position 4 > 0

Re: Replication still not working

On Wed, Jun 13, 2001 at 12:42:00AM -, [EMAIL PROTECTED] wrote: > database,sql,query,table Anyone have an interpretation of this: 010612 20:37:32 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 4 010612 20:37:32 Slave: reconnected to master 'ftp@localhost:3307

user variables

Hello, My problem is about users variables. I want to do a script to create a database so: SET @dbname:="mydbname"; CREATE DATABASE @dbname;# <-- Don´t work CREATE DATABASE (SELECT @dbname);# <-- Don´t Work I have tried to define @dbname=mydbname directly but it blocks.

Re: last_insert_id() issue w/ DBI

On Tue, Jun 12, 2001 at 04:47:47PM -0500, Paul DuBois wrote: > > Try using: > > $dbh->do ("UPDATE ... WHERE k = ?", undef, "xxx") > and then access $dbh->{mysql_insertid} to see if you get a different > result. I suspect perhaps not, but it's something to try. Unfortunately I get the same resu

Re: my.cnf mystery

The command lines are divided up by topics in the manual, I think. I know that there is a specific section on replication. A table of all of them in one place would be a helpful appendix in a future edition of the documentation. [hint, hint, MySQL AB developers...] --On Tuesday, June 12, 20

Re: my.cnf mystery

At 8:15 PM -0400 6/12/01, William M. Quarles wrote: >Which program? Uh ... what? mysqld, mysql, mysqladmin, mysqldump, mysqlshow, ... For example, if you run mysql --help, the output includes: Possible variables for

Re: How to upgrade MySQL without breaking PHP/Apache?

Think you're right, but I've hundreds of mysql_connects on the server. The php.ini trick did it though. Thanks. Whit On Tue, Jun 12, 2001 at 04:32:10PM -0500, Joe Stump wrote: > You can also put this in your mysql_connect ... check out the syntax for it > but I believe you can do this: > > mysq

Re: my.cnf mystery

On Tue, 12 Jun 2001, William M. Quarles wrote: > Which program? Here's what the /etc/my.cnf file on my system looks like: [client] port=3306 socket=/home/mysql/mysql.sock [mysqld] port=3306 socket=/home/mysql/mysql.sock The first section affects the "mysql" client. The second section affects

Re: how to install mysql replication ?

Okay, let's put it this way: if it was not installed, it would not be creating an error log about replication, it would only give you an error message when you run mysqlamdin. Make sure you have also read chapter 4.16, most importantly 4.16.5. it has some important information in it, too. --

Re: my.cnf mystery

Which program? --On Tuesday, June 12, 2001 15:52 -0500 Paul DuBois <[EMAIL PROTECTED]> wrote: > At 4:34 PM -0400 6/12/01, William M. Quarles wrote: >> I don't think that's what Dennis person wants to know, I think he >> wants to know every single variable that he can control in my.cnf. > > Runni

Re: GRANT annoyance...

On Tue, 12 Jun 2001, David Simcik wrote: > Trying to grant super-user level permissions on my root account, but I keep > getting back an error: > > mysql> GRANT ALL PRIVILEGES ON *.* TO root@% IDENTIFIED BY 'user' WITH GRANT > OPTION; > ERROR 1064: You have an error in your SQL syntax near '% IDE

Re: MySql to Oracle migration

On Tue, Jun 12, 2001 at 05:06:59PM -0500, Zhu George-CZZ010 wrote: > > Is there a way/tool to migrate the Application from MySql to Oracle > 8i? Oracle has one available on their web site... -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (

Re: mysql query urgent!!!

>i, >I have to write simple mysql script. I need folowing things: > >Number of people logged in previous 0 to 24 hours >Number of people logged in previous 24.5 to 48 hours >Number of people logged in previous 48.5 to 72 hours >Number of people logged in previous 72.5 hours to 7 days >Number of pe

Re: Dinamic Compression/Decompression

On Tue, 12 Jun 2001, Emiliano F Castejon (Castle John) wrote: > I would like to know if there is a way to use a compressed MYSQL bank > for read and write (dynamic compression/decompression). I'm not sure if it is possible to do this natively in MySQL; I'll let someone else answer that. You cou

Dinamic Compression/Decompression

I would like to know if there is a way to use a compressed MYSQL bank for read and write (dynamic compression/decompression). Using "myisampack" utility I can only create a read-only bank. Is there any internal compression scheme in MySQL ? Disk space is an important factor in my work. Every day

Re: mysql.sock not created

On Wed, 13 Jun 2001, Brian Walker wrote: > mysqladmin: connect to server at 'localhost' failed error: 'Can't > connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' > (111)' Check that mysqld is running and that the socket: > '/var/lib/mysql/mysql.sock' exists! When this ha

Re: mysql.sock not created

On Wed, 13 Jun 2001, Brian Walker wrote: > I've established that the MySQL server is running, but I cannot create > or do anything with it. Here is some examples. > > ERROR 2002: Can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock' (111) It probably created mysql.soc

Query help!

Can someone tell me why: SELECT Items.*, IF(Items.status IN ('Event', 'Not Purchasable', Special') OR ('-6-12' >= Items.start AND '-6-12' Items.end),1,0) as inseason FROM Items, Categories WHERE Items.category=Categories.id AND Items.showitem>0 AND Categories.id >

Re: [[Mysqlcppapi-main] What's the easiest way to export MySQL table structure and data AUTOMATICALLY using MySQL++?]

"David Ayliffe" <[EMAIL PROTECTED]> wrote: > As subject; I'm using the MySQL C++ API's and compiling under MS VC++ 6? > > I want to accept a table name at runtime, and then export both the data > and data structure to a file which is compatible with MS Access; which > the table will eventually be

MySql to Oracle migration

Is there a way/tool to migrate the Application from MySql to Oracle 8i? Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To requ

mysql.sock not created

Hello I've established that the MySQL server is running, but I cannot create or do anything with it. Here is some examples. [root@www bin]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) [root@www bin]# mysqladmin -u root -p create ecre

RE: GRANT annoyance...

'IDENTIFED BY ...' option set the password for your user, ('root' in this case). Your problem, however, is that the %-sign needs to be protected with quotes: mysql> GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY 'user' WITH GRANT OPTION; HTH ~

Re: last_insert_id() issue w/ DBI

At 4:34 PM -0500 6/12/01, Erik Rantapaa wrote: >This really might be a DBI problem, but I find it's pretty weird. > >I am attempting to perform atomic updates by using UPDATE statements >like: > > UPDATE counter SET v = last_insert_id(v+1) WHERE k = 'xxx'; > >where counter has the schema: cr

Re: GRANT annoyance...

At 5:25 PM -0500 6/12/01, David Simcik wrote: >Trying to grant super-user level permissions on my root account, but I keep >getting back an error: > >mysql> GRANT ALL PRIVILEGES ON *.* TO root@% IDENTIFIED BY 'user' WITH GRANT >OPTION; >ERROR 1064: You have an error in your SQL syntax near '% IDEN

Re: How to upgrade MySQL without breaking PHP/Apache?

On Mon, Jun 11, 2001 at 09:12:36PM -0500, Joe Stump wrote: > You should be able to change your mysql.sock in your my.cnf or php.ini file > and it will work. I'm thinking that it's a sock error you are getting. Joe, Thanks. By coincidence this appeared in the php.net annotated manual today: ===

last_insert_id() issue w/ DBI

This really might be a DBI problem, but I find it's pretty weird. I am attempting to perform atomic updates by using UPDATE statements like: UPDATE counter SET v = last_insert_id(v+1) WHERE k = 'xxx'; where counter has the schema: create table counter (k varchar(16) primary key, v int)

Re: How to upgrade MySQL without breaking PHP/Apache?

You can also put this in your mysql_connect ... check out the syntax for it but I believe you can do this: mysql_connect("server:port:socket","username","password"); --Joe On Tue, Jun 12, 2001 at 05:17:58PM -0500, Whit Blauvelt wrote: > On Mon, Jun 11, 2001 at 09:12:36PM -0500, Joe Stump wrote:

GRANT annoyance...

Trying to grant super-user level permissions on my root account, but I keep getting back an error: mysql> GRANT ALL PRIVILEGES ON *.* TO root@% IDENTIFIED BY 'user' WITH GRANT OPTION; ERROR 1064: You have an error in your SQL syntax near '% IDENTIFIED BY 'user' WITH GRANT OPTION' at line 1 What

export bug in access? myodbc?

I tried to export a table from ACCESS to odbc database. This table had an auto-increment field (the first) and then a bunch of varchar fields. The length parameters for the varchar fields were not forwarded in the CREATE statement. Here's the failed line in mysql.log: 010612 13:56:46 73 Q

What's the easiest way to export MySQL table structure and data AUTOMATICALLY using MySQL++?

As subject; I'm using the MySQL C++ API's and compiling under MS VC++ 6? I want to accept a table name at runtime, and then export both the data and data structure to a file which is compatible with MS Access; which the table will eventually be imported into. Are their any API's to do this? Any

Re: my.cnf mystery

At 4:34 PM -0400 6/12/01, William M. Quarles wrote: >I don't think that's what Dennis person wants to know, I think he >wants to know every single variable that he can control in my.cnf. Running a program with the --help option will list the program's variables. The syntax for setting any of th

Re: how to install mysql replication ?

I think we would need much more information than what you have given to verify what is going wrong, but I am not the expert on replication yet, since I haven't got it working yet. Although I am confused, for you requested that somebody tell you how to install it, and last I heard you basically

Re: my.cnf mystery

I don't think that's what Dennis person wants to know, I think he wants to know every single variable that he can control in my.cnf. --On Tuesday, June 12, 2001 3:09 PM -0500 Paul DuBois <[EMAIL PROTECTED]> wrote: > At 3:36 PM -0400 6/12/01, Dennis wrote: >> Of the many mysql resources I have

Re: install problem

> Installing mysql on solaris 6 sun4u sparc SUNW,Ultra-5_10 > release: > > -- mysql-3.23.38.tar.gz > > via > ./configure --prefix=/dir --with-low-memory Is that really what you type: --prefix=/dir ? strange name for a DIRectory? Can be a reserved word. > make > make install > > I get to: > > ya

Re: how to install mysql replication ?

Okay, I will get in on this, too. I found the replication procedure in the documentation to be very complete (we are all talking about , right? Read all parts of Chapter 11, right?). I had no problem following the procedure. However, I will admit that the replicatio

Re: how to install mysql replication ?

On Tue, Jun 12, 2001 at 12:45:15PM -0700, Jeremy Zawodny wrote: > On Tue, Jun 12, 2001 at 03:41:25PM -0400, Jim Ziegler wrote: > > On Tue, Jun 12, 2001 at 12:50:20AM -0700, Jeremy Zawodny wrote: > > > On Tue, Jun 12, 2001 at 02:15:41PM +0700, Said Madrus wrote: > > > > Dear all, > > > > can anybod

Re: my.cnf mystery

At 3:36 PM -0400 6/12/01, Dennis wrote: >Of the many mysql resources I have (including a book and searching >the website), there doesnt seem to be a definitive outline of what >variables can be controlled by my.cnf. set-variable = var_name=var_value should work for pretty much any variable tha

mysql@lists.mysql.com

>Description: Unable to compile a binary for mysql-3.23.38. >How-To-Repeat: Downloaded mysql-3.23.38.tar.gz. Used gunzip, then gtar to uncompress. No errors indicated. Used the command from the mysql instruction manual: CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -f

Re: how to install mysql replication ?

On Tue, Jun 12, 2001 at 03:41:25PM -0400, Jim Ziegler wrote: > On Tue, Jun 12, 2001 at 12:50:20AM -0700, Jeremy Zawodny wrote: > > On Tue, Jun 12, 2001 at 02:15:41PM +0700, Said Madrus wrote: > > > Dear all, > > > can anybody tell me how to install mysql replication > > > step by step :-). > > > t

Re: how to install mysql replication ?

On Tue, Jun 12, 2001 at 12:50:20AM -0700, Jeremy Zawodny wrote: > On Tue, Jun 12, 2001 at 02:15:41PM +0700, Said Madrus wrote: > > Dear all, > > can anybody tell me how to install mysql replication > > step by step :-). > > thanks in advance. > > Best regards, > > It is described step-by-step in

my.cnf mystery

Of the many mysql resources I have (including a book and searching the website), there doesnt seem to be a definitive outline of what variables can be controlled by my.cnf. Is there a list somewhere outlining the possibilities? Dennis

RE: query

> Hi: > > Just wondering what 'MUL' means in the key column when you look at > tables...I understand PRI is primary key... The index contains values which occur MULtiple times (as opposed to a UNIque index where every value occurs once) database,sql,query --

Re: Access Database into mysql

You should be able to export data directly from Access to a delimited text file. Curtis On Thu, 7 Jun 2001, Ute Hoffmann wrote: > Hi, > > I have a database table, which was made with Microsoft Access and am to move > the data into a mysql database table. As there are some long entries, which

Re: Multiple CPU's in Freebsd

Hi Rafael, This is not an easy task, there are really only two ways to accomplish this. But first I must ask if you have check how much CPU % is currently in use? Is consistently high? The other cpus's will be used to runs things such as Apache, but mysql will run on one processor. Or, y

Re: Solaris 8/Sparc configure problem

I think i recompiled my compiler, i was using the one from sunfreeware.com, then i got the source, compiled it, and that error no longer comes up, But now i have a different error completly, so there you go :-) ( i had this same problem on the gd1.8.4 and it fixed it ) --- "Rutherford, John (L

EXARO perl module?

I have been given the source to a large perl-based cgi application. It uses a Template Manager packaged as EXARO. I have never heard of this package, nor can I find any information about it online. I was hoping that someone on this list has heard of this package and can send me some informat

indexing speed

Hi, I'm running MySQLd-NT on an Athlon 1.33GHz w/512MB RAM, under Win2000. I'm doing a fulltext index on a varchar(255) column in one of my tables. Admittedly, the table has ~77million rows, but the indexing has been going for almost a *week* now. What can I do to optimize MySQL for fulltext inde

Solaris 8/Sparc configure problem

I just attempted to compile mysql 3.23.38 on a Solaris 8/sparc systems with gcc 2.95.3 (installed from binary from sunfreeware.com), . When I run ./configure --prefix=/usr/local/mysql the configure dies with: checking return type of sprintf...configure error, cannot run test program while cross

Re: query

On Tuesday 12 June 2001 09:39, Benjamin Pflugmann wrote: > Hello. > > On Tue, Jun 12, 2001 at 04:07:11PM +0100, [EMAIL PROTECTED] wrote: > [...] > > Your message cannot be posted because it appears to be either spam or > > simply off topic to our filter. To bypass the filter you must include > >

Re: Can't get started

Though I wouldn't be 'happy' using the environment setup you have, the real issue that's causing your problem(s) is the fact that you downloaded and installed the package (note the word "sparc" which means that this package is for Sun SPARC based computers): mysql-3.23.38-sun-solaris2.7-sparc

Re: Replication and Transaction

Hello. Sorry, but I fear, I am not sure what you mean by "sync of a row". In MySQL, replication sends complete commands to the slave and if the command is received completely, it will be executed. The server holds a log about all commands and when the connections breaks, the slave remembers the

RE: Problem with source command for command line (win version)

Another shot in the dark. The user table in db mysql should also have a host entry for the user specified - verify that you do not just have an entry for localhost. (Use % wildcard to indicate all hosts instead, or duplicate the row with localhost on it and use the windows host name.) -Orig

Re: query

Hello. On Tue, Jun 12, 2001 at 04:07:11PM +0100, [EMAIL PROTECTED] wrote: [...] > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > database,sql,query Sa

Re: No identical entries in a field

On 6/11/01 11:11 PM, "Jari Mäkelä" <[EMAIL PROTECTED]> wrote: > Hi, > > how a field ( names of products ) of database should be defined so that you > could not enter identical entries at the field? > > Or does one need to do the validation before inserting info? > > Jari Mäkelä > How about cr

Re: Problem with source command for command line (win version)

The "access denied" message is most likely occurring because you are not supplying the password option (-p) to the mysql command. - TIM > Using the source command on the command line, I am getting "access > denied" (to > the file, I am guessing). > > I have tried these statements: > > (1) "sour

Re: Problem with source command for command line (win version)

Hi. May sound like a stupid question, but do you have read access to source_file? Please quote the complete line with error message. Are you able to execute another statement on the server? What does source_file contain? When it tries to create a database, a table, whatever - do the user you u

Replication and Transaction

Helo, I'm intersted to know about MySQL replication, I could make it work, I will send some problems I found later. I have a question about the replication in MySQL: Does it implement transaction? Imagin if the connection break exactly in a sync of a row. What hap

mysql query urgent!!!

i, I have to write simple mysql script. I need folowing things: Number of people logged in previous 0 to 24 hours Number of people logged in previous 24.5 to 48 hours Number of people logged in previous 48.5 to 72 hours Number of people logged in previous 72.5 hours to 7 days Number of people log

RE: query

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 12 June 2001 16:03 To: Craig Gilbert Subject: Re: query Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the fo

Problem with source command for command line (win version)

Using the source command on the command line, I am getting "access denied" (to the file, I am guessing). I have tried these statements: (1) "source filename" (2) "mysql -h hostname -u user database < source_file" and I received the same "access denied" message. What am I doing wrong? Edward

Re: Can't get started

The shell is tcsh. I can do an nslookup and find organa. My /usr/local directory points to a space on another server. I wanted to keep it on my server(organa), which is why I used a subdirectory of /export. Besides, I don't have permission to write to /usr/local. My OS is Solaris2.7 /i386. T

Re: Installation problem

On Tue, 12 Jun 2001, Gerry Tool wrote: > This morning after a restart of the computer, mysqld starts. For future > reference, where are the mysql logs? In manual :) This question cannot be answered with single sentence. Check the manual as there are few differet logs in different OS-s in diff

Re: Procedures

Seung-woo, I understand the point you are making, a stored procedures is a group of queries that can be executed together like a function. As you have said "if you can [write] SQL and Perl programs, you could write a function that works like stored procedures in MS SQL server or Oracle". M

Re: compile problem on solaris , possibly others

I also, just installed the zlibc lib from source and it is still having this issue WOW, solaris is so much harder to work with than linux ( for my ignorant self anyway ) --- Mark Vann <[EMAIL PROTECTED]> wrote: > Well, i just did a pkginfo | grep zlib and this is > what I got, > > app

Re: compile problem on solaris , possibly others

Well, i just did a pkginfo | grep zlib and this is what I got, application JGzlib zlib So it appears to be installed. Any ideas? --- Sinisa Milivojevic <[EMAIL PROTECTED]> wrote: > Mark Vann writes: > > I am currently trying to compile mysql on solaris > 2.7 > > , running on an ul

Re: Multiple CPU's in Freebsd

---Reply to mail from Sinisa Milivojevic about Multiple CPU's > [EMAIL PROTECTED] writes: >> Hi, >> Can anyone help me out! Does MySQL run efficently in a multi >> CPU environment. > [..] > MySQL supports as many CPU as you might have, but FreeBSD threads do > not support SMP, so MySQ

Re: Please Help

Hello. On Mon, Jun 11, 2001 at 10:18:17PM -0230, [EMAIL PROTECTED] wrote: > Can someone please help with this database problem. There are too few information to give a satisfying answer. Especially the context (i.e. the query in question) is missing. The error message states, that you somehow c

RE: MYSQL error

Read The Manual = RTFM -Original Message- From: Aldo Spano [mailto:[EMAIL PROTECTED]] Sent: 12 June 2001 14:30 To: Rolf Hopkins Cc: [EMAIL PROTECTED] Subject: Re: MYSQL error What is RTFM? A. Scrive Rolf Hopkins <[EMAIL PROTECTED]>: > There are settings that could probably fix the pro

Re: MYSQL error

What is RTFM? A. Scrive Rolf Hopkins <[EMAIL PROTECTED]>: > There are settings that could probably fix the problem then but I would > need > to RTFM. > > - Original Message - > From: "Aldo Spano" <[EMAIL PROTECTED]> > To: "Rolf Hopkins" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Se

Re: Installation problem

This morning after a restart of the computer, mysqld starts. For future reference, where are the mysql logs? Thanks. Gerry Rolf Hopkins wrote: > What do the mysql error logs say? > > - Original Message - > From: "Gerry Tool" <[EMAIL PROTECTED]> > To: "Rolf Hopkins" <[EMAIL PROTECTED

Re: (sleeping) processes of > 90% CPU

Wouter de Jong writes: > On Tue, Jun 12, 2001 at 02:16:27PM +0300, Sinisa Milivojevic wrote: > We are running 2.4.5-ac4 currently on the server. Could you tell me why your binary >should run better ? Cause I tried it, and it dind't make a lot of difference. > > -- > Met vriendelijke groet/With

Re: Multiple CPU's

[EMAIL PROTECTED] writes: > Hi, > Can anyone help me out! Does MySQL run efficently in a multi > CPU environment. I am using FreeBSD 4.1 at the moment but I am > looking to upgrade to 4.3 because as most ppl know 4.1 had that > bug that meant Mysqld would use 100% of the CPU. So my > que

Re: 3.23.39 somewhere?

Michael Kunze writes: > Hi all, > > a bugfixed MySQL version 3.23.39 was announced on Freshmeat on June, > 7th, but there is no announcement on the list and nothing on the site. > Was it a premature announcement? > > Michael Yes, it was. It is in building process right now. -- Regards, _

Re: compile problem on solaris , possibly others

Mark Vann writes: > I am currently trying to compile mysql on solaris 2.7 > , running on an ultra1 with 512 megs of memory. I have > uninstalled the bin package off sunfreeware.com for > gcc and replaced it with 2.95.3 compiled on my box. I > also have the libstdc++ library with G++ installed as >

Re: (sleeping) processes of > 90% CPU

On Tue, Jun 12, 2001 at 02:16:27PM +0300, Sinisa Milivojevic wrote: > > To solve SMP problems with Linux, you should use latest kernel 2.4.* > and our binary. We are running 2.4.5-ac4 currently on the server. Could you tell me why your binary should run better ? Cause I tried it, and it dind't

Filtrar uma Query

Olá Tenho uma tabela que contem o nome do produto e a origem dele, sendo IMP - importado RJ \ SP | AM | nacional RS | MG/ SP-CL \ RJ-CL | Empresas coligadas a nossa empresa AM-CL / O problema aqui é filtrar os nacionais junto com importado ou nacionais com coligadas Tipo, como faço p/ re

Re: (sleeping) processes of > 90% CPU

To solve SMP problems with Linux, you should use latest kernel 2.4.* and our binary. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larn

Re: New JDBC3.0 driver for MySQL

Hi I and my friends we are going to write new JDBC driver for MySQL. = Where can we get description of communication protocol between client = and MySQL server? Tomek=20 Hi! Get hooked to our BK mysql-4.0 repository and you will find all docs you need in Docs subdir. If you have any probl

Bug!

Hi! I'm runing win98 se and my mysql server have become gone nuts.. When I create a computerbase it can dissapear a day later or something like that,,,sometimes I cant eaven create a table.. I have tryed to reinstall it.. but it wount work! what do you suddgest

Re: mysqld --skip-networking and mysqlgui 1.7.5

Brett G. Lemoine writes: > Is mysqlgui capable of connecting to the mysqld daemon via a unix > socket, or must it use the network. Mysqlgui appears to ignore > the 'socket' option in the my.cnf file. Am I out of luck, or did > I possibly make a mistake in the compile? > > thanks, > bl > -- > //

Re: Error starting mysql server

Weining Zhao writes: > Hello, > > I donwloaded the mysql 3.23.38 binary for AIX 4.3.3 and installed an IBM rs6000 >workstation. When I started mysql server with safe_mysqld, I got following error >message: > > > > > Start MySQL server deamon > exec(): 0509-036 Cannot load program

Re: Can any body supply "libmysqlclient.so" for Solaris 7?

[EMAIL PROTECTED] writes: > > > Could anybody e-mail me a copy of "libmysqlclient.so" for Solaris 7 -or- let me > know where I can get one? > > Many Thanks, >=Adrian= > > > Information in this message is confidential and may also be legally privileged. > It is intended solely for the pers

  1   2   >