Re: Can't connect to local Mysql server (111)

2001-01-11 Thread
Dear Frank, First of all, try to figure out have MYSQL daemon started. use # ps ax | grep mysql If it will show mysql process then try to run # /{path to mysql installation}/mysql_config --socket --port Reagrds, Ruslan O. Nesterov P.S. Try to read th manual it explains all troubles like it ---

SV: Problem with big tables.

2001-01-11 Thread Johan Björk
What, are you saying that this "bug" could be the reason for my problems with can't-create-more-threads, posted recently? --- Johan Björk -Ursprungligt meddelande- Från: Michael Widenius <[EMAIL PROTECTED]> Till: Peter Zaitsev <[EMAIL PROTECTED]> Kopia: [EMAIL PROTECTED] <[EMAIL PROTECT

ERROR 1044

2001-01-11 Thread Franck ABELLI
To change the root password i connected to mysql: bin/mysql mysql>connect mysql localhost mysql>UPDATE user set Password='***' where User='root'; ->No problems mysql>SELECT User,Password FROM user; -> to verify if the pass was set... it was. then i stopped mysql and restart it and it was impossib

FIX [PHP-INST] Problem with PHP/Apache/MySQL on fresh RH7 install

2001-01-11 Thread T. Purol
There is no such thing as a stupid question. only stupid answers *that being my reply to all the other current issues floating around the MySQL list* being your on a redhat i am 100% possitive this is your problem so atleast try it. i myself recieved no replies from this list when i posted the

Re: Enough is Enough.

2001-01-11 Thread Cory Whitesell
I am terribly sorry to hear about your wookie. > Has anyone seen my wookie? > > just that, I have a horrible feeling he's fallen off the internet somewhere! > > - Before posting, please check: http://www.mysql.com/manual.ph

Re: Enough is Enough.

2001-01-11 Thread Neil Zanella
On Fri, 12 Jan 2001, Frederick L. Steinkopf wrote: > I've got a new acronym for all of you flamers out there who are clutterring > up the list with off - topic responses and flames to newbies. (And yes this > is off topic) If you see a message from a newbie that bothers you, just > PTFDK (Press

RE: Mysql doesn't running

2001-01-11 Thread Neil Zanella
On Fri, 12 Jan 2001, Peter Mietlowski wrote: > I seem to be having the same problem, Installed Mysql by the book, but can't > get it running. I checked my logs and found this: > > 010111 14:27:01 mysqld started > 010111 14:27:02 /usr/local/mysql/bin/mysqld: Can't create/write to file > '/usr/

Re: Mysql doesn't running

2001-01-11 Thread Peter Mietlowski
mysqld is in /usr/local/mysql/bin, as for my.conf and MP3Box.pid, they seem nonexistant. I installed it from binaries (tar.gz format), and have tried re-installing many, many times as well as re-downloading the binaries for practically each time. I tried the source, but it seems to error out near

Re: Connection error with fresh installation on RedHat 7

2001-01-11 Thread Neil Zanella
On Thu, 11 Jan 2001, John W Cunningham wrote: > Hi, > > I just installed MySQL via rpms on a fresh installation of Redhat 7 pro > server. It seems fine at first and it seems to be running. When I check > the process with: ps aux |grep mysql, I get: > root 925 0.0 0.4 1516 588 pts/0

RE: Mysql doesn't running

2001-01-11 Thread Peter Mietlowski
I seem to be having the same problem, Installed Mysql by the book, but can't get it running. I checked my logs and found this: 010111 14:27:01 mysqld started 010111 14:27:02 /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/data/MP3Box.pid' (Errcode: 13) 010111 14:27:02

Re: Mysql doesn't running

2001-01-11 Thread Rolf Hopkins
I don't know for sure but it looks like one of the mysql settings got screwed in regards to paths. Do you know where the actual location of mysqld and MP3Box.pid are? A suggestion is to look at the my.conf file and see if there is an incorrect path setting. You installed from source or RPMs?

Number of Tables..?

2001-01-11 Thread Dennis Gerasimenko
What is the largest number of table per database does MySQL support? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this threa

Re: Enough is Enough.

2001-01-11 Thread Frederick L. Steinkopf
I've got a new acronym for all of you flamers out there who are clutterring up the list with off - topic responses and flames to newbies. (And yes this is off topic) If you see a message from a newbie that bothers you, just PTFDK (Press the F.. Delete Key) - Original Message - From: "Rolf

Re: Connection error with fresh installation on RedHat 7

2001-01-11 Thread Rolf Hopkins
- Original Message - From: "John W Cunningham" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Friday, January 12, 2001 12:48 Subject: Connection error with fresh installation on RedHat 7 > Hi, > > I just installed MySQL via rpms on a fresh installation of Redhat 7 pro >

Connection error with fresh installation on RedHat 7

2001-01-11 Thread John W Cunningham
Hi, I just installed MySQL via rpms on a fresh installation of Redhat 7 pro server. It seems fine at first and it seems to be running. When I check the process with: ps aux |grep mysql, I get: root 925 0.0 0.4 1516 588 pts/0S23:28 0:00 grep mysq But when I try: mysqladmin

third time asking help concerning charsets

2001-01-11 Thread Roman Serbski
I'm sorry, this is the third time I ask help from this list. No suggestions :-(, not even one. If it is a dummy question please point me to some url ... whatever. Good day all! Please help me with charset adding. I have some strange trouble. I use FreeBSD 4.2 STABLE and MySQL 3.23.28-gamma (comp

logical statement as column default

2001-01-11 Thread Ilia Lobsanov
Seems this doesn't work: ...column_name default substring_index(another_column, '.', 1) Would be nice if mysql supported logical statements for column defaults. ilia. - Before posting, please check: http://www.mysql.com/man

Re: Enough is Enough.

2001-01-11 Thread Rolf Hopkins
No one is looking to smack anyone in the face. It doesn't matter how easy or difficult the question is, it is a matter of whether they tried to find the answer on their own first, usually by doing a little research like RTFM. - Original Message - From: "JCampell" <[EMAIL PROTECTED]> To:

Re: Lazy

2001-01-11 Thread Rolf Hopkins
Two things though. The Internet is nice and cushy. Just go to a search engine, type in a word and bingo, you've got your answer. I've known some students these days, have handed in someone else's web page content as their assignment. Not like when I was in school. You had to get off your butt

Occasional table corruption

2001-01-11 Thread hooker
Hi, I posted this question a few days ago, and didn't get a reply, so I thought that I'd try again in case it got lost amongst the documentation/RTFM threads !! I've got a linux database server running MySQL 3.22.32 on kernel version 2.4.0-test8. The database server has a number of housekeepin

Re: query much slower when function used...?

2001-01-11 Thread elble
> okay, with gdb i can see that this column becomes a blob (thereby > not allowing heap tables to be used - which has got to be costing > me speed), is there any function i can use to 'cast' this column > to a fixed length? hrm, apparently LEFT(SUBSTRING(MAX(CONCAT())), N) will do that for me...

Enough is Enough.

2001-01-11 Thread JCampell
Years ago when AOL first provided its users access to newsgroups, they very quickly into what I've seen in this list in the past few days. People ask questions that are contained within FAQs and manuals, and then they get smacked in the face. And ofcourse, they respond with their hurt egos. The

RE: The scaling question?

2001-01-11 Thread Ralf R. Kotowski
On 11 Jan 2001, at 19:18, Chris Murley wrote: > Thanks for you help, can anyone tell me what the file size limit is under > windows?? win 200 or win me? > I think the filesize limit on Win OS'es is 2 GB, video editors have that problem, thats why some implement their own filesystems. Ralf R. K

Re: copying rows from one database to another database

2001-01-11 Thread Rolf Hopkins
This is off the top of my head so check the manual on this. insert into db1.table from db2.table where... - Original Message - From: "Dang Nguyen" <[EMAIL PROTECTED]> To: "'mySQL mailing list'" <[EMAIL PROTECTED]> Sent: Friday, January 12, 2001 4:27 Subject: copying rows from one databas

Re: Please read the manual

2001-01-11 Thread Rolf Hopkins
If you find it that difficult, make a suggestion to the MySQL team in how you think they can improve it. - Original Message - From: "Doug Young" <[EMAIL PROTECTED]> To: "Matt Wagner" <[EMAIL PROTECTED]>; "Neff Patrick K" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, January 1

RE: The scaling question?

2001-01-11 Thread Chris Murley
Thanks for you help, can anyone tell me what the file size limit is under windows?? win 200 or win me? -Chris --- Christopher Murley Application Index http://www.appindex.net http://www.appindex.org --- On Fri, 12 Jan 2001, Quentin Bennett wrote: > I

Re: BSDI 4.1

2001-01-11 Thread Rolf Hopkins
Perhaps you should submit that to the appropriate section of the user commented on-line manual. - Original Message - From: "Aaron Schlesinger" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 12, 2001 1:46 Subject: BSDI 4.1 > Ok, I finally managed to get it installed. >

Re: index corruption and mysqld crash

2001-01-11 Thread Rolf Hopkins
I can think of only one suggestion. See if there is a cron job or something killing a process. I doubt it though. Hope it helps. - Original Message - From: "Joseph Bueno" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 12, 2001 1:31 Subject: index corruption and mysql

Re: Mysql doesn't running

2001-01-11 Thread Rolf Hopkins
As already suggested, check your error logs but also check that it isn't already running. You can do this with a ps -ef | grep mysqld command. - Original Message - From: "Riccardo Scannapieco" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 12, 2001 1:42 Subject: Mysql

RE: limit to the number of characters allowed in a query?

2001-01-11 Thread Mark Dale
I've tried "mysql --set-variable=max_allowed_packet=8M" with no luck. I'm not getting the error message. The query has multiple selects. When I copy and paste the query with 4 selects in it, everything's fine. If I try with 5, it dies half way thru the 5th select as its pastes. Any more clues

RE: limit to the number of characters allowed in a query?

2001-01-11 Thread Quentin Bennett
There is a limit to the size of a packet sent to mysqld, which is configurable. Check the manual for it, and see if you are hitting that. Regards Quentin > -Original Message- > From: Mark Dale [SMTP:[EMAIL PROTECTED]] > Sent: Friday, January 12, 2001 12:39 PM > To: [EMAIL PROTECTED] >

RE: The scaling question?

2001-01-11 Thread Quentin Bennett
I have a database in which one table has 15,000,000 records and another has 50,000,000 records. Selects work fine so long as you use an index. You may be limited by the OS. Regards Quentin > -Original Message- > From: Chris Murley [SMTP:[EMAIL PROTECTED]] > Sent: Friday, January 12, 2

RE: urgent question

2001-01-11 Thread Quentin Bennett
Surely this is a PHP question, not a MySQL Question > -Original Message- > From: Ryan Hagan [SMTP:[EMAIL PROTECTED]] > Sent: Friday, January 12, 2001 1:14 PM > To: [EMAIL PROTECTED] > Subject: urgent question > > Greetings, > > I have just subscribed to this list, so I am really

urgent question

2001-01-11 Thread Ryan Hagan
Greetings, I have just subscribed to this list, so I am really sorry if I'm asking a question that has been asked already, but I wasn't having any luck plowing through the archives, so I thought I'd try my luck with the list. I'm using MySQL 3.23.29 with PHP4 and apache 1.3.14 on a FreeBSD 4.2

mysql-3.23.30-gamma Compile Problem

2001-01-11 Thread John Romano
Hi All. I'm trying to compile mysql on a intel SMP machine and I get the following error. I'm using redhat 7 any ideas? c++ -O3 -DDBUG_OFF -fno-implicit-templates -rdynamic -o .libs/mysql mysql.o readline.o sql_string.o completion_hash.o ../readline/libreadline.a -lncurses ../libmysql/.libs

Re: The scaling question?

2001-01-11 Thread William R. Mussatto
What size records, what OS, what processor? Linux on 32 bit platform does have a file limit which might come into play. On Thu, 11 Jan 2001, Chris Murley wrote: > Date: Thu, 11 Jan 2001 17:54:23 -0600 (CST) > From: Chris Murley <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: The scalin

Problem in mysql (Help)

2001-01-11 Thread Ravi Ranjan
hi, I am working on Mysql Database. I am facing following problem while trying to grant permission after login as administrator mysql Ver 9.16 Distrib 3.21.33b, for pc-linux-gnu (i586) server version: 3.21.33b-log mysql> grant all on temp.* to ravi@localhost identified by 'ravi'; ERROR 106

The scaling question?

2001-01-11 Thread Chris Murley
I know everyone on this list has discussed scaling over and over. I am only in a need of a simple anwser. Can mysql handle a database with 20,000,000 records? There will be several tables(about 10) each with no more that 4 columns. In each table there will be 20 million records. These table

limit to the number of characters allowed in a query?

2001-01-11 Thread Mark Dale
I'm trying to run a very long query and after trying it in various ways, it seems like there is a limit to the number of characters allowed in a query. If this is true, is it possible to increase the number of characters allowed. (the database is hosted at an ISP) I've tried -q and -f in the q

Re: rpm requires perl5 on redhat 7.0

2001-01-11 Thread Matthew Costello
SATYAN NAIR wrote: > dear friends, > i am not able to install MySQL-3.23.30-1.i386.rpm on redhat 6.2 and 7.0 > it says REQUIRES PERL5 at /usr/bin/perl5 > and under /usr/bin i have perl as well as perl5.006 RedHat includes perl5, it is the dependency rule which is broken. Just install as

Problem with big tables.

2001-01-11 Thread Michael Widenius
Hi! > "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes: Peter> Hello mysql, Peter> I've recently tried to do a test of mysqld with big tables (>4GB) on Peter> linux 2.4 mysql 3.23.30 Peter> 1) The strange thing is even without setting up max_rows got a Peter> table to grow for more th

Re: Please read the manual

2001-01-11 Thread Eric Fitzgerald
I'm going to contribute to this discussion again. I want to counter some of your basic arguments. You seem to be trying to place MySQL newbies in the same level as computer newbies. IMHO, this is a very bad thing to do. Someone who is going to be working with MySQL is going to be using it for

Re: query much slower when function used...?

2001-01-11 Thread elble
> any thoughts/suggestions? > > the only thing that's different is the SUBSTRING_INDEX(MAX(CONCAT())) > construct, and i can't immediately see why that slows it down so > much... okay, with gdb i can see that this column becomes a blob (thereby not allowing heap tables to be used - which has got

FW: Please read the manual

2001-01-11 Thread Scott Gerhardt
My pennies worth: The manual is excellent, read it! Be patient, it may take you a while to find exactly what you are looking for. You can always try entering "mysql your_key_words_here" in the google search http://www.google.com to see what else pops up. Actually the MySQL docs search is pretty

Re: Please read the manual

2001-01-11 Thread Richard Dice
Doug Young wrote: > > If I may add my 0.5c here too, the MySQL manual, like so many of its kind > was obviously written by a highly skilled developer(/s) but who, like > virtually all of that ilk, lacks the ability to impart knowledge to > others. The MySQL manual available at www.mysql.com is t

RE: Please read the manual

2001-01-11 Thread Brian Kaney
If the manual was written any better, you'd put all those book publishers out of business. The reason this list has such a high volume of traffic might not be ambiguity of the online manual, rather the popularity of MySQL. The contents of the manual are more than sufficient, but the search could

RE: Please read the manual

2001-01-11 Thread Aaron Schlesinger
The fundimental problem lies in human nature craving social contact. Even us geeks need it. No matter how good a manual is, people will still come and ask first/read later just to hear (read, whatever)someone else say "Go read the damned manual". I think we all need to lighten up on this whole sub

3.23.28-gamma Crash and data loss

2001-01-11 Thread Jason McWilliams
We have been using 3.23.28-gamma with berkely db files so we can use transactions. Platform: BSDI 4.1 Everything was rolling along fine when we ran into this while doing some simple command line stuff... It gives me the error that mysql has gone away... lost connection... Something I have se

Re: Please read the manual

2001-01-11 Thread Doug Young
If I may add my 0.5c here too, the MySQL manual, like so many of its kind was obviously written by a highly skilled developer(/s) but who, like virtually all of that ilk, lacks the ability to impart knowledge to others. As always, the issue is largely that of ignoring countless items considered tr

Do HEAP tables use table locking?

2001-01-11 Thread Steven Roussey
Hi! Do HEAP tables use table locking? Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (

RE: Please read the manual

2001-01-11 Thread Ralf R. Kotowski
My personal opinion on the documentatios is: It is good, however it is written in a very dry and technical manner which will be hard to understand for less technically inclined people. This I guess is normal since the docs are probably written by the same people that actually work on MySQL.

Re: rpm requires perl5 on redhat 7.0

2001-01-11 Thread Matt Wagner
Matt Wagner writes: > SATYAN NAIR writes: > > dear friends, > > i am not able to install MySQL-3.23.30-1.i386.rpm on redhat 6.2 and 7.0 > > it says REQUIRES PERL5 at /usr/bin/perl5 > > and under /usr/bin i have perl as well as perl5.006 > > > > > > please let me know how do i install the rpm on

Re: copying rows from one database to another database

2001-01-11 Thread Phil Huynh
I think you need to copy data first then delete the data. copying data between two databases: insert into databaseA.table select * from databaseB.table where . delete data : delete from databaseB.table where ... Dang Nguyen wrote: > > Hi All, > > What is the best way

RE: Please read the manual

2001-01-11 Thread Matt Wagner
Neff Patrick K writes: > > > > I in fact finally got mysql up and running last night but not one > word in your manual helped me do it. So in fact all the reading in > the world would have left me sitting in the same position. Neff, What stumbling blocks in the documentation did you run acros

Re: help please!!

2001-01-11 Thread Cory Whitesell
Go to the MySQL Contributed page and go from there to get the Zeos MySQL components. (They may be under Borland Delphi, but they come with components for C Builder 4 and 5) Either that, or you can just use the standard TDataSet components and use MyODBC to create the data source. - Original

Re: I need to migrate MSSql database with relations to MYSql

2001-01-11 Thread Web master
I am trying to do the same thing. The best bet so far is mysqldump. You can find more detail in http://www.sql.com/document and do search on mysqldump Pär Lindhe wrote: > Hello > > I need to migrate the structure of my MSSql database with its relations and > tables to MYSql. Is it possible? And

copying rows from one database to another database

2001-01-11 Thread Dang Nguyen
Hi All, What is the best way to move an entire row of data from a table in one database to another table in a different database? The two databases are on the same system. Thanks in advance, Dang H. Nguyen - Before posting, pl

Data Replace.. ughhh..

2001-01-11 Thread Ashwin Kutty
I have a database with tables containing file names with a .sgm extension.. Any ideas as to how I could traverse the database through the different tables and change all the .sgm extensions to .htm? Any easy way? -- Ashwin Kutty Systems Administrator Dalhousie University Libraries (902) 494-269

Re: RPMS are faulty

2001-01-11 Thread Neil Zanella
The books you are using are probably outdated as installation instructions tend to change from release to release. Installation instructions are perhaps one thing that should not be put in a book. Rather a book should tell you where to find the installation instructions. The MySQL RPMS do adhere

How to compile MySQL using LinuxThreads on FreeBSD

2001-01-11 Thread Rick Jansen
Hi, I just installed LinuxThreads on my server, to use with MySQL to get maximun performance from my dual CPU setup. The README.FreeBSD file tells me to compile applications with the following line: -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads -llthread -llgcc_r But where should i

query much slower when function used...?

2001-01-11 Thread elble
this is curious: the table: CREATE TABLE inbw_day_diffs_2001_Jan_02_10 ( hostname char(20) NOT NULL default '', variable_name char(64) NOT NULL default '', variable_index_value char(114) NOT NULL default '', variable_index_label char(50) NOT NULL default '', variable_result_value_numer

Re: Lazy

2001-01-11 Thread Vadim P.
Excellent post, Neil! I'm with you! (Sorry to be using up the bandwidth with this "me too" stuff, but couldn't help it :)) Cheers, Vadim Neil Davis wrote: > > Guys, > > Amen. When I was 13 and got my first commodore 64, I decided to teach myself > BASIC. All I had was the manual. (the MySQL ma

Re: Install:MySQL, RedHat7, Dell Poweredge 2400 dual PIII 700 MHz

2001-01-11 Thread Vadim P.
No, it should work just fine 'out of the box' with SMP kernel. Most likely you have a permission problem. Check permissions of your MySQL data directories. I have a dual P866 Dell Poweredge 2400 / RH Linux 7.0 / MySQL 3.23.29a. Works just fine. Cheers, Vadim. Lars Freymark wrote: > > Hello! >

thread locking support

2001-01-11 Thread Mitul Tiwari
Hi, I am new to mysql. I want to know if there is thread locking support for java and concurrency control mechanism in mysql. I will be thankful for any help in this regard. Please cc the answer to me since i am not in the mailing list. TIA, Mitul -- M

Re: Mysql doesn't running

2001-01-11 Thread Eric Fitzgerald
Check your error log, usually located in the main database directory (/var/lib/mysql on my sys) - Original Message - From: "Riccardo Scannapieco" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 11, 2001 9:42 AM Subject: Mysql doesn't running > Hi Friends, I'm Riccard

"MySQL server has gone away" error

2001-01-11 Thread Sean Conley
I posted a couple of days ago abou this error and got no response, so I am trying again with a bit more detail this time. I am running mysql 3.23.28-gamma on a pretty much stock RH 6.2 box. I am accessing the database using Perl CGI scripts and the DBI API. I have reset the max_allowed_packet a

I need to migrate MSSql database with relations to MYSql

2001-01-11 Thread Pär Lindhe
Hello I need to migrate the structure of my MSSql database with its relations and tables to MYSql. Is it possible? And how do i make that happen? I have searched through a LOT of sites and forums on the internet but I have not found the answer. Perhaps one of you know the answer? Grateful fore

Re: Lazy

2001-01-11 Thread Neil Davis
Guys, Amen. When I was 13 and got my first commodore 64, I decided to teach myself BASIC. All I had was the manual. (the MySQL manual is the library of congress compared to this manual!) There simply were no other resources for me since I couldn't afford a modem until 2 years later, when I got a

BSDI 4.1

2001-01-11 Thread Aaron Schlesinger
Ok, I finally managed to get it installed. Someone over at MySQL gave me some input and I want to document how to get the bloody thing installed: You must have 1) autoconf and automake installed. 2) Use Make version 3.79 Execute: aclocal autoconf gmake Get lunch, when you come back you'll

Mysql doesn't running

2001-01-11 Thread Riccardo Scannapieco
Hi Friends, I'm Riccardo Scannapieco, an italian's boy! Sorry for my english, it isn't very good! I installed mysql 3.22.25-1 but it doesn't running! When I launch the command safe_mysqld & the deamons start and end quickly. How I can resolv my problem? ---

mysqlhotcopy patch

2001-01-11 Thread Michael Widenius
Hi! > "Ask" == Ask Bjoern Hansen <[EMAIL PROTECTED]> writes: Ask> Hi Monty, Ask> a few fixes to mysqlhotcopy. Ask> :-) Applied; Thanks! Regards, Monty - Before posting, please check: http://www.mysql.com/manual.ph

index corruption and mysqld crash

2001-01-11 Thread Joseph Bueno
Hello, I have switched this morning our Web server from mSQL to MySQL. I am using MySQL 3.22.32 installed from MySQL-3.22.32-1.i386.rpm on a Linux server (RedHat 6.2). mysqld dies very ofen (uptime is between 2mn and 20mn) and the only messages I have in error file look like : Number of process

Re: ???

2001-01-11 Thread Rolf Hopkins
That garbage was written in Chinese, but you probably don't have the chinese character font so all you'll see is garbage. The guy said he installed Redhat7.0 and also perl 5.6.0 in the /usr/sbin directory. When he tried to install MySQL, he gets the "now famous" perl5 dependency check error and

Re: rpm requires perl5 on redhat 7.0

2001-01-11 Thread CK Raju
Try building from source from the mirror site http://mysql.hjc.edu.sg if u are in India. Cheers. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list a

Re: Visual Basic and MySQL connection

2001-01-11 Thread Scott Baker
So you've "bound" the datasource to the text box. I've never done that. I've always done all my ado updates manually. I suggest you look into doing all the ADO work on the backend, and manually update your text boxes. I've never had any problems doing that. Binding isn't very good practic

Re: RPMS are faulty

2001-01-11 Thread Rolf Hopkins
This is an FAQ. Just force the install, ignoring dependencies. --nodeps, I think, is the switch. This will be fixed with the next Mysql version. - Original Message - From: "kentj" <[EMAIL PROTECTED]> To: "Neil Zanella" <[EMAIL PROTECTED]>; "MySQL Mailing List" <[EMAIL PROTECTED]> Sent: F

Re: Lazy

2001-01-11 Thread John Cichy
Thanks, but actually I'm late 30s. The high school where I went was given federal and state funding to build their system and the class room had it's own liberary of 1000+ books. We did not not have access to the internet, in fact I don't think the phrase had been 'coined' yet. We used DECwrite

Re: 请教!

2001-01-11 Thread Rolf Hopkins
我懂你的意思可是我中文不好, so I'll write English instead. This is an FAQ. Just ignore the error and force the install.I.e. use the --nodeps flag - Original Message - From: "weixin2001" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 11, 2001 19:49 Subject: 请教! > 我在我的机器上安装了Redh

Re: RPMS are faulty

2001-01-11 Thread kentj
I am running SuSe 7.0 and have had the same experience. I think that I remember reading in the SuSE manual about some standard Linux directory structure which they are using. I wonder if this is a recent Linux standard and MYSql.RPm has not been updated to use this structure. I do not find the fil

Re: Lazy

2001-01-11 Thread Rolf Hopkins
Interesting. My guess is that you must be in your early 20s. When I was at high school (& even uni), apart from normal lessons, researching for assignments, etc, meant going to the library, not downloading the answer from the internet. Internet didn't exists in those days. Maybe in the States i

Re: Failed test

2001-01-11 Thread Wico de Leeuw
Hiya update: when using --force this one fails too and the system is redhat 6.2 rename0.16 0.12 0.32 [ pass ] replace 0.19 0.08 0.30 [ pass ] rollback 0.17 0.09 0.26 [ pass ] rpl01

Failed test

2001-01-11 Thread Wico de Leeuw
Hiya I compiled mysql-3.23.30-gamma.tar.gz using pggc version pgcc-2.95.2.1 and kernel 2.4.0 CFLAGS="-Os -O6 -march=pentium" CXXFLAGS=$CFLAGS configure: ./configure --enable-static --prefix=/usr/local/mysql --localstatedir=/home/mysql --enable-assembler when running the tests: ... join_o

Re: ERROR 1044

2001-01-11 Thread Rolf Hopkins
- Original Message - From: "Franck ABELLI" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 11, 2001 23:29 Subject: ERROR 1044 > i can now connect to mysql but when i login as root with the root > password i get the ERROR 1044 : Access denied. > if i don't give any pa

Re: Lazy

2001-01-11 Thread John Cichy
Human nature and education... In most cases as youngsters we are 'given' the answers and the methods for solving our problems. As we get older we continue to expect this and un-able to function when told to figure something out. My first computer class in High school (NCR Mainframe/BASIC), I h

Re: Please read the manual

2001-01-11 Thread Rolf Hopkins
It is not that the "seasoned veterans" don't want to help you. They want to know that you have helped yourself first before seeking help from them. It is obvious when someone asks a question and they haven't tried reading the manual first. A question that comes up from time to time is "how do I

ERROR 1044

2001-01-11 Thread Franck ABELLI
i can now connect to mysql but when i login as root with the root password i get the ERROR 1044 : Access denied. if i don't give any password i can connect but if i write: mysql> use mysql i've got the same message, so i can't do anything neither connect nor create database,tables... -i made the

Replication in production environment

2001-01-11 Thread Martin Mrvka
Hi! I'm using mysql version 3.23.29a under a heavy loaded production environment. Now I've set up our mysql server as replication master and installed second mysql machine to be the slave. Replications as itself works, but how do I get the slave server in sync with the master without shutting do

Re: Please read the manual

2001-01-11 Thread Mikel King
In order to conserver bw I'll only through my $0.01 in...;) I do believe that if you search the list you will see that many of us who are not on the devteam do answer questions. Although I do whole heartedly believe in RTFM; I agree with you about the power of the people, and feel it is important

Re: Warning: Can't create a new thread (errno 11).

2001-01-11 Thread Rune Hansen
On Thu, 11 Jan 2001, Johan Björk wrote: > I _need_ help with this connections-to-mysql issue. Until I changed a few stuff in >the MySQL setup, I kept getting the "Too many connections" message when connecting. >After increasing both max_connections and table_cache, I get the error: > > Warning:

Re: Checking if a record exists

2001-01-11 Thread Gerald L. Clark
Xavi Gracia wrote: > > Hi !!! > > I was wondering if there's any other method in SQL to test if a given record exists >that the typical error handling or the archetypical select clause looking for the >primary key. > > I'm making a table where the e-mail adress is the primary key, nothing ama

Re: Lazy

2001-01-11 Thread Don
Good idea Quentin Bennett wrote: > Perhaps, along with the 'Please check the manual' message at the end of all > messages, there should be a reference to a reliable archive, allowing list > users who are referred to the archive an easy way of finding it! > > Quentin > > > -Original Message--

Re: Lazy

2001-01-11 Thread Don
> Carlos Corzo wrote: > > > Some people have tried the manuals verbatim but are really confused > > because they are not at your intellectual level. If this list is for > > the "intelligent only", change the title please. Not everyone can > > decipher a manual. I may post questions but there ar

Warning: Can't create a new thread (errno 11).

2001-01-11 Thread Johan Björk
I _need_ help with this connections-to-mysql issue. Until I changed a few stuff in the MySQL setup, I kept getting the "Too many connections" message when connecting. After increasing both max_connections and table_cache, I get the error: Warning: Can't create a new thread (errno 11). If you ar

RE: New DBTools version Available

2001-01-11 Thread Siim Einfeldt aka Itpunk
Thank you. > Both things are really implemented, in one way or another. > > To secure your servers parms just uncheck Save Password in the > Options=>Preferences. This way every time you start DBTools it will ask you > the passwords to connect. > > Importing from MSEXCEL it's already don

RE: BLOB Type?

2001-01-11 Thread indrek siitan
Hi, > I was looking to see the length or size of the BLOB data type in the > manual and it is not listed. Does anyone know the size of BLOB? > Also what is the largest number that can be stored in BIGINT? you can find answers to both of your questions at: http://www.mysql.com/doc/C/o/Column_ty

Re: Please read the manual

2001-01-11 Thread Edwin Martinez
Mr. Samuel, Im new in this field (mysql, linux, etc.), I am a MCSE, and at this time, I try to impulse this software (Mysql, Linux, etc) in Central America, I see many feactures in this software but I need to Know if exist a maillist for dummies as I, mybe in a two months I can give to people like

BLOB Type?

2001-01-11 Thread Mike Podlesny
I was looking to see the length or size of the BLOB data type in the manual and it is not listed. Does anyone know the size of BLOB? Also what is the largest number that can be stored in BIGINT? Thanks, Mike - Before posting

jdbc

2001-01-11 Thread Lebrun Jonathan
Sorry for my English. I would like use jdbc with MySQL. I write this code but I've a running error. Why ? The code : import java.sql.*; import java.util.Properties; import java.io.FileInputStream; import java.io.IOException; public class ConnectionDB { private Connection con; public Conn

RE: Please read the manual

2001-01-11 Thread Neff Patrick K
Maybe it is the lack of coffee this morning talking or maybe it is the fact that I have spent 4 days trying to get mysql up and running on linux(a platform I am unfamiliar with) but I assumes this mailing list would allow me to have contact with other users who have been thru the same issues I hav

RE: MySQL transaction problem (Again...)

2001-01-11 Thread Mehalick, Richard RE SSI-GRAX
I have started testing MySQL 3.23.30g with latest MySQL provided Berkeley source (3.2.3g) I am using RedHat 6.2 and RPM source of MySQL. I compiled MySQL and altered my existing tables to BDB. So far my tests show that transactions are working. They are working for new BDB tables and the altere

  1   2   >