building

2001-02-28 Thread WANG_KING(王钢)
When I use C api to connet to mysql. And I compile my program, I got an error: Undefined first referenced symbol in file __udivdi3 /usr/mysql323/installdb/lib/libmysqlclient.s o __umoddi3 /usr/mysql323/installdb/lib/libmysqlclient.s o /usr/mysql32

Re: Maximum Password length?

2001-02-28 Thread Atle Veka
>From the 'user' table in the 'mysql' database: mysql> describe user; +-+---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-+---+--+-+-+---+ | Host| char(6

Maximum Password length?

2001-02-28 Thread Tyrone Mills
My apologies if this is an easy question. I've looked at the docs in the privilege section and haven't found a mention of the max length of password for MySQL. I want to set a fairly long one for each of my web servers that will be hitting my database server. Incase it is important, I'm running 3.

Re: mysql ./config..... concerning lncurses

2001-02-28 Thread wen
markr> error messages show that lncurses, lcurses, ltermcap, could not be found. markr> We are running Debian Linux 2.2x, on SPARC. We are trying to install markr> 3.23.33. Any help would be useful thank you. FYI, you can get 3.23.xx.deb from unstable in Debian. Regards, --Wen [EMAIL PROTECTE

Re: Long deletes

2001-02-28 Thread hooker
> Thanks, Fred. The delete job has been running for 21 hours > at this point, and now rather simple queries on other tables hang > (e.g. SELECT COUNT(*) FROM other_table WHERE index=3Dsome_value). > I'll let it run overnight to see what happens, but I'm not hopeful. > > Here's some addition info

building

2001-02-28 Thread WANG_KING(王钢)
When I use C api to connet to mysql. And I compile my program, I got an error: Undefined first referenced symbol in file __udivdi3 /usr/mysql323/installdb/lib/libmysqlclient.s o __umoddi3 /usr/mysql323/installdb/lib/libmysqlclient.s o /usr/mysql32

mysql ./config..... concerning lncurses

2001-02-28 Thread Mark R. Martinez
Hello, Our problem concerns an abnormal abort of: ./configure --prefix=/usr/local/mysql error messages show that lncurses, lcurses, ltermcap, could not be found. We are running Debian Linux 2.2x, on SPARC. We are trying to install 3.23.33. Any help would be useful thank you. Mark R. M.

BDB tables crashing mysql 3.23.33

2001-02-28 Thread msteele
Hi folks, I'm having a hard time using bdb tables. Here are the details... I've create a few BDB tables, which are causing me great amounts of grief. The tables worked fine for a while, then suddenly started crashing mysqld. I decided to drop the offending database, and re-create it. No problem s

Re: Long deletes

2001-02-28 Thread Michael Villalba
Thanks, Fred. The delete job has been running for 21 hours at this point, and now rather simple queries on other tables hang (e.g. SELECT COUNT(*) FROM other_table WHERE index=some_value). I'll let it run overnight to see what happens, but I'm not hopeful. Here's some addition information for th

Re: Problem compiling mysql on FreeBSD

2001-02-28 Thread Shawn Heeley
Hi Bill and All, Thanks for the suggestions. Here's what I've tried: Installed gmake and gcc. My pkg_info looks like the following (I've cut out the irrelevant ones): bash-2.03 The GNU Borne Again Shell gcc-2.95.3.test3GNU compiler suite gettext-0.10.35 GNU gettext package gl

how do you format this query?

2001-02-28 Thread Ed Lazor
Hi =) Could you help me with creating a proper query? I have a table that stores messages with a field for the message id, thread, and parent. The goal is to create a query that gives me the total threads. I read in a book and found the DISTINCT key allows me to run a query like this: sele

Re: MyODBC for Windows ME

2001-02-28 Thread Miguel Angel Solórzano
At 22:57 28/02/2001 -0500, genge1 wrote: Hi! I don't have Win ME, but according with the product information from Microsoft that OS makes part of the Win9x family. Then in theory the MyODBC driver for Win9x should works. Regards, Miguel >Has anyone installed MyODBC under Windows ME? >Did you use

MyODBC for Windows ME

2001-02-28 Thread genge1
Has anyone installed MyODBC under Windows ME? Did you use the Win95 or NT version? I don't have the OS, still on Win95 and 98, but I have a client who wants to install the driver. Thanks in advance. Greg Engel - Before posting

Solaris tuning vs. Linux SHOW VARIABLE logs

2001-02-28 Thread S A
Turns out the Linux table_cache was 457 to Solaris 64. Could that have been all the speed difference ? - Sam. Solaris mysql> show variables; +-+- --+ | Variable_name | Value | +-

Upgrading MySQL causes Error - ASP

2001-02-28 Thread Celso Pires
Hi there, I've got a site hosted at an ISP and everything was going well when they decided to upgrade the software. Now my site is running under Win2K, IIS5, MySQL 3.23.33 and MyODBC 2.50.36. In order to get easier to explain what is going wrong, I've built the following test: CREATE TABLE p

WinMySQLAdmin - Modifications

2001-02-28 Thread Miguel Angel Solórzano
Hi, The WinMySQLAdmin tool had the following modifications: - Compiled with client 3.23.33 - Added a routine for control of the Wait Service Stopping. This condition is shows with a yellow icon and disables the menu to start the service. When the service is ready to start, the icon cha

Re: Table reorg question

2001-02-28 Thread Andy J
John ALTER TABLE ADD [column] col_declaration is what you are after I think - no need to go making another table For example:- ALTER TABLE example_table ADD example_column INT UNSIGNED NOT NULL AUTO_INCREMENT With the greatest regards to Paul DuBois whose marvellous book MySQL this is unashem

Table reorg question

2001-02-28 Thread John Vaughan
Hello I am using MYSQL Server version 3.22.27 on a Redhat Linux System. The question I have is I have created a database with three tables in it. One of the tables has been populated by data. I later decided I wanted to add a new column to the already populated table. Can anyone explain or po

Solaris much slower than Linux ? tuning tips ?

2001-02-28 Thread S A
We've got our MySQL DB on comparable Linux & Solaris hardware but Linux beats Solaris by about 6 times. Anyone have Solaris tuning tips ? - Do You Yahoo!? Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.

Re: Antwort: RE: Antwort: Re: any ASP/ADO/MySQL programmers out there? (LONG answer)

2001-02-28 Thread Rolf Hopkins
- Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 01, 2001 4:08 Subject: Antwort: RE: Antwort: Re: any ASP/ADO/MySQL programmers out there? (LONG answer) > Ja, das is ganz richtig. Ich glaube wenn Mann hier postet, shreibt hier nur English bit

Re: What's the syntax for using ENCODE()?

2001-02-28 Thread Kyle Hayes
(second try, I had some magic words in this that set off the spam filter...) Just as a general security note, make sure that you are not logging these SQL commands somewhere... If you have entries like: INSERT INTO my_table (blah, blah, blah) VALUES (ENCODE('passwor

Re: Mysql Daemon...........

2001-02-28 Thread Mohamad Ilhami
On Thu, 1 Mar 2001, nirmala wrote: > Hi, > We have installed Mysql on our server(UNIX) . When I am telnet into the > server and try to start Mysql by below procedure, I am getting problem. > Anyone can help me. > > [/usr/home/tree/www/treebc.com] : {2} % cd mysql/bin > [/usr/home/tree/www/tr

Re: load large data files?

2001-02-28 Thread Rolf Hopkins
Try as suggested below then. Break up the file and feed each half into the db and find where the problem lies. You may also need to change your dump commands slightly so that import is ok in future. Because you upgraded, the names of one of your tables or columns may now be a reserved word?!?!?

Re: PSOSSYM

2001-02-28 Thread Rolf Hopkins
Never heard of it. What is it? - Original Message - From: "Bill Herlehy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 28, 2001 23:19 Subject: PSOSSYM > With MySQL software do you also receive PSOSSYM? If not where can I > receive this software. > > -- > Bill

Re: Long deletes

2001-02-28 Thread Fred van Engen
On Wed, Feb 28, 2001 at 02:38:40PM -0500, Michael Villalba wrote: > I have a rather large table (~130 million rows) running under MySQL > 3.23.30 and have been very pleased with the performance of the > database. However, occasionally I have to delete millions of rows > from the table, and it app

Re: MySql Support for Index Organizer tables

2001-02-28 Thread Rolf Hopkins
- Original Message - From: "Nadim H Rabbani" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 28, 2001 22:50 Subject: MySql Support for Index Organizer tables > Hi-- > Iam in the process of evaluating MySQL for research purposes .I would like > to know if MySQL

Re: Please help. MySQL show WARNING.

2001-02-28 Thread Rolf Hopkins
Suggestion only: Try printing $sql on your web page and copy it to mysql prompt and see what error you get, if any. BTW: If you use single quotes, you don't need backslashes but personal choice I suppose. - Original Message - From: "maxx" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Se

Mysql Daemon...........

2001-02-28 Thread nirmala
Hi, We have installed Mysql on our server(UNIX) . When I am telnet into the server and try to start Mysql by below procedure, I am getting problem. Anyone can help me. [/usr/home/tree/www/treebc.com] : {2} % cd mysql/bin [/usr/home/tree/www/treebc.com/mysql/bin] : {3} % ls comp_err

Re: Error 1036

2001-02-28 Thread Rolf Hopkins
Just out of curiosity, why would adding a primary key make a difference to a table being read-only or not? I thought it would be a DB permission problem. - Original Message - From: "Miguel Angel Solórzano" <[EMAIL PROTECTED]> To: "Produktberatung" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>

Re: Antwort: AW: version 3.23.29a-1

2001-02-28 Thread Rolf Hopkins
Or use the no dependency flag or upgrade. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 28, 2001 23:36 Subject: Antwort: AW: version 3.23.29a-1 > > On 28.02.2001 14:28:14 Tobias Wolff wrote: > > > The binary may have a different name. I

auto_increments

2001-02-28 Thread John Nielsen
Hey everyone, This may have already come up a couple of times in the mailling list, but I I was wondering with mysql-3.22.32 if you can have two auto_increment's in one table, e.g.: +--+--+--+-+-++ | Field| Type | Null | Key | Def

Re: Security annoucement mailing-list ?

2001-02-28 Thread Benjamin Pflugmann
Hi. On Mon, Feb 26, 2001 at 08:57:19PM +0100, you wrote [...] > Yes, security info is to be sent to announcement list. Well, the last two weren't sent to the announcement list, AFAIK. Well, it's a question of its own, whether to send an announcement out due to an buffer overflow in the client.

problem installing from source

2001-02-28 Thread mysql
Dear Sirs : I'm attempting to install mysql 3.23.33 from source distribution (I need source , not binary) on my Digital Unix 4.0F , (I have a previous mysql 3.22.32 installed). I follow the steps : CC=gcc CXX=gcc ./configure I can view on at config.log , that's all is fine, but when I run m

Re: windows 2000

2001-02-28 Thread Miguel Angel Solórzano
At 17:28 28/02/2001 -0600, Gerald Jensen wrote: Hi! >We run MySQL (3.22.32) on Windows 2000 servers, and have found that if we The 3.22.32 have a bug on the ServiceMain routine for Win2k OS, that bug was fixed from 3.23.22 MySQL version. The bug consist that the routine left the Service Control

Spatial RDBMS

2001-02-28 Thread Phil Coop
I am using ArcSDE to manage my spatial database. It requires a RDBMS such as Oracle or Microsoft SQL server to manage the nuts and bolts of the database and respond to requests from ArcSDE. Has anyone used MySQL to support their geodatabases in this type of environment or where I might I find some

Re: Problems with MySQLGUI 1.7 and ssh

2001-02-28 Thread Steve Ruby
"Todd A. Jacobs" wrote: > > I downloaded and compiled the latest version of MySQLGUI and am connecting > to MySQL 3.22.32 on OpenBSD. When I try to tunnel MySQLGUI through the > following ssh tunnel: > > ssh -x -g -L 3306:localhost:3306 mysql > > I get this error message from the MySQL

testing

2001-02-28 Thread Sergio Ríos Casas
testing - 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 PROTECTED]> To unsubscribe, e-mail <[EMAIL

Re: What's the syntax for using ENCODE()?

2001-02-28 Thread Geoff Coffey
on 2/28/01 4:18 PM, Kinney Baughman at [EMAIL PROTECTED] wrote: > Hi, > > I'm trying to encrypt credit_card numbers in MySQL 3.23.33. I want to > decrypt them when I retrieve them. > > I've tried: > > mysql> insert into payment (payname1,ccaccount) values > ("Kinney",encode(''

Re: windows 2000

2001-02-28 Thread Gerald Jensen
We run MySQL (3.22.32) on Windows 2000 servers, and have found that if we issue the NET STOP MYSQL command from the DOS Prompt, it does in fact shutdown the service ... it just takes much longer than on the WinNT platform. Patience is the key. Same with removing the installed service. In every in

Re: What's the syntax for using ENCODE()?

2001-02-28 Thread Eric Fitzgerald
Your not closing off enough )'s should look like this: insert into payment (payname1,ccaccount) values ('Kinney',encode('','Ilwfci')); Then, for decode, you do it like this: SELECT DECODE(ccaccount,'Ilwfci') AS ccnumber FROM payment WHERE payname = 'Kinney'; - Original Messag

Re: Re: more Youch (thank you)

2001-02-28 Thread John Jensen
Thank you! Sorry for my frustration, but I have been wrestling with this for a week. In that time, I have neither seen meaningful suggestions, nor have I seen help for a few others with similar problems. I would still like to see a list of warnings that would alert me to pitfalls and other dan

What's the syntax for using ENCODE()?

2001-02-28 Thread Kinney Baughman
Hi, I'm trying to encrypt credit_card numbers in MySQL 3.23.33. I want to decrypt them when I retrieve them. I've tried: mysql> insert into payment (payname1,ccaccount) values ("Kinney",encode('','Ilwfci'); ERROR 1064: You have an error in your SQL syntax near '' at line 1 mys

Problems with MySQLGUI 1.7 and ssh

2001-02-28 Thread Todd A. Jacobs
I downloaded and compiled the latest version of MySQLGUI and am connecting to MySQL 3.22.32 on OpenBSD. When I try to tunnel MySQLGUI through the following ssh tunnel: ssh -x -g -L 3306:localhost:3306 mysql I get this error message from the MySQLGUI client: Can't connect to loc

Best approach for large amount of data

2001-02-28 Thread Robert Badaracco
Hi, I've got 350 mailing lists that have approx 32 fields. Each list will have between 100k to 200k records. Should I create a database for each individual list or create one database with one table for each? If I take the latter approach I'll end up with 35 - 70 million records in a single datab

beta

2001-02-28 Thread marsha
Hi guys, I am part of a team developing an interface from Microsoft Access on a Windows environment to mySQL on a Cobalt RAQ server (LINUX). When you say the software mySQLgui is in "beta testing", what level is that? Is alpha a step higher than beta, as in the best and ready for distribution. O

Re: [auto_increment]

2001-02-28 Thread Jason Landry
Well, except that the value of an auto-increment field CAN be set to a specific value (perhaps negative) an INSERT or UPDATE statement. > If Autoincrement can only work with positive numbers, then any > key that is auto_increment should automatically be made unsigned. > ---

Re: Archive

2001-02-28 Thread Gerald L. Clark
kentj wrote: > > Is there an archive for this mailing list? > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this

Re: Re: more Youch

2001-02-28 Thread Sean Conley
You shouldn't have to reinstall Linux, just uninstall the old RPM, or delete the old version which was installed from source, and install the new version if it be from RPM or whatever. There is no way that the manual could cover every installation medium that exists (RPM, tar, DEB, BSD Ports tree

Accounting software

2001-02-28 Thread Paul Hernandez-Cuebas
I am interested in sourcing an accounting package in mysql. We are a vertical developer in need to port our application to the web. Please respond with serious solutions. We do not require services initially just product. Willing to negotiate source code license if required. Paul Hernandez-Cue

Archive

2001-02-28 Thread kentj
Is there an archive for this mailing list? - 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 PROTECT

[auto_increment]

2001-02-28 Thread tom
>Description: If Autoincrement can only work with positive numbers, then any key that is auto_increment should automatically be made unsigned. >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: 58k.com >MySQL support: [none | licence | email support | extended email sup

Re: Storing Hash

2001-02-28 Thread Eric Pickup
Dunc, Check out either of these modules. You can insert their results into the database and eval them later to restore the structure. http://search.cpan.org/search?dist=Storable http://search.cpan.org/search?module=Data::Dumper For a simple hash, you are probably better off just using a two colu

Re: Re: more Youch

2001-02-28 Thread John Jensen
BUG: Telling me I "shouldn't have done" something, not even mentioned in the manual, does not help me fix the problem. BUG: Having to completely reinstall the operating system (Linux) in order to repair problems with a mysql install. Or does someone actually have any recommendations on this?

RE: how to backup mySQL database?

2001-02-28 Thread Quentin Bennett
Another tip is to store the backup on a separate physical disk and tape to the actual database, because if they are on the same device, and that dies, then there goes your back up too! Quentin -Original Message- From: Dan Adams [mailto:[EMAIL PROTECTED]] Sent: Thursday, 1 March 2001 8:21

writing thread safe code

2001-02-28 Thread Dan Adams
Does anyone have any suggests on how to write thread safe programs with the mysql c api? I\'ve heard a lot about it and know that i\'m going to do it i just don\'t want to have to learn the hard way. - Dan Posted via Project Horizon http://www.projecthorizon.com --

Antwort: RE: Antwort: Re: any ASP/ADO/MySQL programmers out there? (LONG answer)

2001-02-28 Thread Me
Ja, das is ganz richtig. Ich glaube wenn Mann hier postet, shreibt hier nur English bitte. Kein Deutsch order Nederlander (ich glaube das ist Nederlander. Vieliecht nicht). -Original Message- From: John Dean [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 8:33 AM To: [E

Re: Re: Re: Re: Re: Antwort: Re: Antwort: Re: any ASP/ADO/MySQL programmers out there? (LONG answer)

2001-02-28 Thread Entryon Corp., Chief Technical Officer - P. Hasenfratz
Hey, I can't stop laughing anymore ( that has no ironical meaning!!! ) :) :) Good humor in this list, don't stop please :) Philipp - Original Message - From: "Jason Landry" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "John Dean" <[EMAIL PROTECTED]> Cc: "Bob Hall" <[EMAIL PROTECTED]>; <[

Re: how to backup mySQL database?

2001-02-28 Thread Dan Adams
This is the way i do it: - write a script that will run mysqldump on the database of choice and then pipe the result though gzip (this is only to reduce the size) - the script also copies the new backup over the old one where every you may be backing it up - run this script with cron every nigh

Long deletes

2001-02-28 Thread Michael Villalba
I have a rather large table (~130 million rows) running under MySQL 3.23.30 and have been very pleased with the performance of the database. However, occasionally I have to delete millions of rows from the table, and it appears that MySQL hangs on these jobs. To be specific, I am running a delet

Re: Error 1036

2001-02-28 Thread Miguel Angel Solórzano
At 12:25 28/02/2001 +0100, Produktberatung wrote: Hi! The MySQL table has a primary key ?. If the answer is no, add a primary key and try again. Regards, Miguel >Hi You, >I have some trouble with my MYsql installation. I imported several tables >from Foxpro that run/perform EXCELLENT! Great Tool!

Re: XML support under mySQL (Long rant)

2001-02-28 Thread Carsten Gehling
From: "Florian G. Pflug" <[EMAIL PROTECTED]> Sent: Tuesday, February 27, 2001 1:31 AM > I think XML support should not be just "sending the respone of an > SQL-Queries written in a weird way as an XML Document as another weird XML > Document to the client". > > It should make the DB-Server into

Re: Antwort: Re: Antwort: RE: how to backup mySQL database?

2001-02-28 Thread Gerald L. Clark
[EMAIL PROTECTED] wrote: > > On 28.02.2001 16:03:57 Gerald L. Clark wrote: > > > But the dump who't have it set to zero, so it will reload with its > > proper value. > > No, in the dump the column will be set to zero, but since "INSERT INTO Tbl > (AutoCol) VALUES (0)" means that AutoCol should

writing thread safe code

2001-02-28 Thread Dan Adams
Does anyone have any tips on writing programs with threads using the mysql c api? I didn\'t want to have to learn it the hard way. - Dan Posted via Project Horizon http://www.projecthorizon.com - Before posting, please che

Re: Antwort: Re: Antwort: Re: any ASP/ADO/MySQL programmers out there? (LONG answer)

2001-02-28 Thread Jason Landry
> On 28.02.2001 15:33:27 John Dean wrote: > > > Hi > > Since the language of business here at MySQL is English it would be nice if > > all messages to the list are written in English. This way you would have more > > chance of receiving reply > > Yeah, that's just what I was saying :] > But I'm s

Solaris compile failes

2001-02-28 Thread frontz
>Description: I can't make mysql from the provided sources. It looks like get_hash_symbol() is not defined anywhere. Here's where the make fails: make[3]: Entering directory `/export/home/jhfrontz/src/mysql/mysql-3.23.33/sql' c++ -DMYSQL_SERVER

Storing Hash

2001-02-28 Thread Duncan Hudson
I want to take a hash, in Perl w/ DBI, and store it in a column in one of my MySQL tables. I tried writing it to a blob, but I can't read it back later. How would I go about storing the hash and then reprocessing it later? Thanks in advance, Dunc. ---

Antwort: Re: Antwort: Re: any ASP/ADO/MySQL programmers out there? (LONG answer)

2001-02-28 Thread alexander . skwar
On 28.02.2001 15:33:27 John Dean wrote: > Hi > Since the language of business here at MySQL is English it would be nice if > all messages to the list are written in English. This way you would have more > chance of receiving reply Yeah, that's just what I was saying :] --

Antwort: Re: Antwort: RE: how to backup mySQL database?

2001-02-28 Thread alexander . skwar
On 28.02.2001 16:03:57 Gerald L. Clark wrote: > But the dump who't have it set to zero, so it will reload with its > proper value. No, in the dump the column will be set to zero, but since "INSERT INTO Tbl (AutoCol) VALUES (0)" means that AutoCol should be set to the next available value (if Au

RE: Antwort: RE: how to backup mySQL database?

2001-02-28 Thread Fabio Ottolini
mysqldump "spits" not only table structures but data also. When you use mysql to import data it will first attempt to create the table and then load its values. If your table's got AUTO_INCREMENT set it will work fine after recreating the database. Anyway... Give it a try! :) BR, Fabio Ottolini

Re: Unique ID's Alphanumeric to save digits ?

2001-02-28 Thread Gerald L. Clark
Laurent Oget wrote: > > On Wed, Feb 28, 2001 at 08:09:04AM -0600, Gerald L. Clark wrote: > > S A wrote: > > > > > > Can MySQL help with generation of ALPHANUMERIC unique identifiers ? > > > > > > ID's that use the full ASCII char range create more possible combinations with >the same # of charac

Using MySQL with Visual C++

2001-02-28 Thread zulkarnain
Hello, I'm looking for MySQL tutorial with Visual C++. could some one of you provide me an URL ? big thanks, zul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: GROUP BY problem.

2001-02-28 Thread Angel Behar
Thanks for the answer. but actually I'm not saying that mysql is doing wrong, I just want to know HOW can I group by codigo and then get 10 random rows of the grouped ones. Hope I explain me. Thanks again. > Angel Behar wrote: > > > > Hi !!! > > > > I'm running 3.23.28-gamma under windows NT,

Re: Unique ID's Alphanumeric to save digits ?

2001-02-28 Thread Laurent Oget
On Wed, Feb 28, 2001 at 08:09:04AM -0600, Gerald L. Clark wrote: > S A wrote: > > > > Can MySQL help with generation of ALPHANUMERIC unique identifiers ? > > > > ID's that use the full ASCII char range create more possible combinations with the >same # of characters which can be important when

PSOSSYM

2001-02-28 Thread Bill Herlehy
With MySQL software do you also receive PSOSSYM? If not where can I receive this software. -- Bill Herlehy Alcatel USA Program Manager - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Antwort: AW: version 3.23.29a-1

2001-02-28 Thread alexander . skwar
On 28.02.2001 14:28:14 Tobias Wolff wrote: > The binary may have a different name. If there is only a /usr/bin/perl you > may have to create and symbolic link. Which won't work, because RPM doesn't care at all about what the filesystem really looks like. All it cares about is what it THINKS sh

Re: Antwort: RE: how to backup mySQL database?

2001-02-28 Thread Gerald L. Clark
[EMAIL PROTECTED] wrote: > > On 28.02.2001 21:26:17 ?iso-8859-1?Q?F=E1bio_Ottolini?= wrote: > > > Try using mysqldump. > > This won't work always! For instance, I have a table that has a auto_increment > INT column in it. Storing a row with this column set to 0 (zero), will add this > row jus

Re: Antwort: Re: any ASP/ADO/MySQL programmers out there? (LONG answer)

2001-02-28 Thread John Dean
Hi Since the language of business here at MySQL is English it would be nice if all messages to the list are written in English. This way you would have more chance of receiving reply On Wednesday 28 February 2001 12:54, [EMAIL PROTECTED] wrote: > On 28.02.2001 13:13:05 Bob Hall wrote: > > >Og

Re:Innobase

2001-02-28 Thread Heikki Tuuri
Hi Phil, >Looked at the Innobase web site - very exciting looking specs. >SQL: > -a small interpreter with stored procedure syntax like in >Oracle, no SQL optimizer >Does this mean that MySQL using Innobase tables, will this allow for stored >procedures of >multiple

Re: GROUP BY problem.

2001-02-28 Thread Gerald L. Clark
Angel Behar wrote: > > Hi !!! > > I'm running 3.23.28-gamma under windows NT, but I have the following > problem. > I need to query some data and gruop by some field (codigo in this case) so I > run the following query : > > SELECT codigo from ropa where cve_depto='3' AND cve_clase='06' AND a

Re: Unique ID's Alphanumeric to save digits ?

2001-02-28 Thread Gerald L. Clark
S A wrote: > > Can MySQL help with generation of ALPHANUMERIC unique identifiers ? > > ID's that use the full ASCII char range create more possible combinations with the >same # of characters which can be important when squeezing into cookie storage space. > > 4 character numeric ID has 10,000

Re: how to backup mySQL database?

2001-02-28 Thread Steve Ruby
RTFM... Obviously you need to pass the correct usename and password if need with the mysqldump command,, read the manual and/or mysqldump --help Keneth wrote: > > "When I try to dump sql database it gives me some errors 1.Error 1045 > mysqldump --opt database > backup-accp.sql mysqldump: Go

MYSQL Feature :)

2001-02-28 Thread Peter Zaitsev
Hello mysql, Mysql 3.23.32 running on Linux. I've got a table with auto_increment command stuck, well this is no problem there is a record in this table with MAX_UINT value. I'm not really shure if this is a bug or correct behavior, but still it leads to toe problems in this case: insert int

Re: windows 2000

2001-02-28 Thread Andy J
Micke Can't really speak for Professional but I have it running fine on Server and Advanced Server. If my memory is right then 1067 is normally that the service cannot respond to the control function effectively. Together with the fact that you cannot remove the service after uninstall, this sug

Re: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

2001-02-28 Thread andreas otto
Hi Gerald, > In order for andreaso to open mysql.sock, he needs search permission on > /var/lib/mysql. > chmod 775 /var/lib/mysql That was it! Thanks for helping me out ;-) Cheers, Andreas -- andreas otto london (uk) - B

Mysql gone away and ... no return

2001-02-28 Thread Lionel Gauliardon
Hello, I'm working with version 3.22.32 of mysql on Linux Mandrake 7. Here is my problem, mysql server gone away during process. I test all queries with code error CR_SERVER_GONE_ERROR or CR_SERVER_LOST, and it is bad do mysql_ping() to reconnect to the server but this return the error cr_serv

Re: Linux / Mysql server connection

2001-02-28 Thread Gerald L. Clark
Nihat Tunalý wrote: > > I have problem > My server Linux RedHat 6.2 installed MySQL-3.23.33-1.i386.rpm > I want to connect to server for testing but I take an error message: > > 1130 - Host '192.168.0.42' is not allowed to connect to this MySQL Server > > Please Help me... Lookup "grant" in the

Re: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

2001-02-28 Thread Gerald L. Clark
andreas otto wrote: > > Hi, > > Since SuSE 7.1 I experience the following problem using MySQL: > > andreaso@php4win:~ > mysql -u root -p > Enter password: > ERROR 2002: Can't connect to local MySQL server through socket >'/var/lib/mysql/mysql.sock' (13) > > Looks like I don't get a connection

[Error during auto start mysql.server]

2001-02-28 Thread roland . mjp
>Description: When the shell script "mysql.server" is launched and/or stoped, I receave an error message "mysql.server: @HOSTNAME@: command not found" and the variable "pid_file" is not initialised >How-To-Repeat: Evry time when the script is launched with sart an

Re: load large data files?

2001-02-28 Thread Chad Phillips
I have had a similiar problem. Every morning I run a mysqlimport. The file I import is about 500 meg. This ran fine for months but I upgraded to 3.23.33 and now the import has hung three times. >>> "Rolf Hopkins" <[EMAIL PROTECTED]> 02/27/01 11:04PM >>> You really should reply to the list an

RE: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

2001-02-28 Thread Rick Emery
I had the same problem. Ensure that /var has these permissions: drwxr-xr-x Ensure /lib is drwxr-xr-x Ensure /mysql is drwxr-xr-x That fixed it for me rick -Original Message- From: andreas otto [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 6:11 AM To: [EMAIL PROTECTED

MySql Support for Index Organizer tables

2001-02-28 Thread Nadim H Rabbani
Hi-- Iam in the process of evaluating MySQL for research purposes .I would like to know if MySQL supports the following: 1-indexes, 2-cluster tables 3-index-organized tables 4-hashing 5- And any other support for embedded systems. Thanks a lot for your help. Yours Nadi

windows 2000

2001-02-28 Thread Micke Bjork Coolbase
Hello, I´m having a problem running MySQL on a Windows 2000 Professional plattform. There is no problem installing or uninstalling mysql, but you can´t start MySQL or the MySQL service. In the service list a MySQl entry exist, but when I´m tying to start it I get the erro 1067. It is imppossi

RE: auto_increment

2001-02-28 Thread Julian Strickland
The behavior differs between ISAM tables and MyISAM ones. Its all in the manual. > -Original Message- > From: Bard dZen [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, February 28, 2001 1:23 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: auto_inc

RE: Search Engine Theory

2001-02-28 Thread Peter Szekszardi
Hi, On Wed, 28 Feb 2001, Sander Pilon wrote: > Web robots are not search engines (just the things that fill the engines), > as far as I understand. Yes, you are right. I do know the difference between them too. I just missred the letter. (Yes, I should first read and then write) Anyway, the docs

Please help. MySQL show WARNING.

2001-02-28 Thread maxx
Hello. I have installed from ports on FreeBSD 4.2 mysql323-server It's working, but when I make mysql_query from php-file: $sql="INSERT INTO guest (name,city,mail,text) VALUES (\"$name\",\"$city\",\"$mail\",\"$text\")"; mysql_query($sql); In brother window I have Warning from My

Re: MAX number of connections

2001-02-28 Thread clay bond
On Wed, 28 Feb 2001, Decasto David wrote: > can u tell us how to configure mysql , to support more > connections. safe_mysqld --set-variable=max_connections=n -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS

Problem starting mysql with bdb

2001-02-28 Thread Suraj Sharma
Hello, I have compiled  mysql-3.23.33 with Berkeley Db 3.2.9a Iam not bale to startup the mysql deamon using safe_mysqld script. Iam getting the following message in the error file under data dir  /usr/local/var 010228 19:06:09  mysqld started 010228 19:06:10  bdb:  Recovery function for LSN 1 63

Re: Problems with SHOW DATABASES / TABLES

2001-02-28 Thread Sinisa Milivojevic
As building process, nor system libs, may not be perfect, try using our binaries. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /

Antwort: Re: any ASP/ADO/MySQL programmers out there? (LONG answer)

2001-02-28 Thread alexander . skwar
On 28.02.2001 13:13:05 Bob Hall wrote: > >Og nu da jeg så nærmere på din email adresse, er du selvfølgelig velkommen > >til at spørge på dansk... ;-) > > Det er alltid hyggelig å se på andre språg på internettet, men hvis > du skriver på dansk, så skal de aller fleste taper sjansen å lære om > A

AW: version 3.23.29a-1

2001-02-28 Thread Tobias Wolff
The binary may have a different name. If there is only a /usr/bin/perl you may have to create and symbolic link. Tobias. -Ursprüngliche Nachricht- Von: acci [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 28. Februar 2001 13:53 An: [EMAIL PROTECTED] Betreff: version 3.23.29a-1 I have tr

  1   2   >