C API - intermittent problems with insert

2002-04-17 Thread Robert Cross
Hello, I'm using the Suse-provided binary of 3.23.47 on Suse7.3 Linux, and I'm having a funny problem with my program, which uses the C API, on this database. The database I'm accessing is using only the BDB table type. The host system is a relatively low powered IBM 300XL, (PII-233, 96MB RAM, 2G

Re: MySQL Home Uses

2002-04-12 Thread Robert Cross
Jeffrey Flowers wrote: >What I would like to hear is how other people are putting MySQL to work in >their home environment. Like you said yourself the most obvious application is cataloging music CD's. What I'm doing is using it to keep a track of magazine cover disks. I got really annoyed with

[O/T] problem with the list and Eudora/attachments

2002-04-05 Thread Robert Cross
I've been having an off-list discussion with gordon52 at slingshot dot co dot nz, who is having a problem posting anything to the list. Apparently when he sends something, the list manager thinks it's got attachments and bounces it. Now when he sends me a message - no attachments. Can any

microsoft uses MySQL too?

2002-04-05 Thread Robert Cross
Anyone seen this yet http://www.theregister.co.uk/content/53/24714.html good advert for MySQL if it's true!? ("if you want a commercial grade, fully cross platform database, then get MySQL") Bob Cross. Spam filter bypass: mysql database table query Disclaimer: my opinion and no one e

Re: PERL/SQL, again? - Re: Procedures

2002-04-03 Thread Robert Cross
Russell E Glaue wrote: >Actually, I like this proposal of being able to plug in any language into >MySQL. I also want to make a note that Greg Cope has a very good point. >And going from what Greg mentioned in an earlier e-mail in this thread, >the embedded language of choice really needs to b

RedHat6.2 and kernel 2.2.14

2002-03-27 Thread Robert Cross
We've got a RedHat 6.2 system here, and every so often it fails to commit an INSERT to the database, (using BDB table type). Apart from that the system works fine. I was wondering if this is a symptom of the kernel 2.2.14 problem that's mentioned on the download page. Anyone got any views on th

RE: Impact of Free ORACLE

2002-03-26 Thread Robert Cross
"Ron Jamison" <[EMAIL PROTECTED]> wrote: >I'd be hardpressed to find a better, more stable database (MySQL) with the wonderful >support that comes from the whole community. Couldn't agree more. It's a shame that Microsoft, Oracle, IBM's support for their DB's isn't as good, (and inexpensive!!)

Re: Mystery files

2002-03-20 Thread Robert Cross
mysql mailing list user wrote: > Hi, > I my mysql server database directory (that is the directory that holds the > .err and .pid files) so strange files have apeared. They look line > -bin.001 > -bin.002 > etc > -bin.index > Some of them are huge! They seem like binary files, but are f

mysql_num_rows/insert/3.23.41

2002-03-15 Thread Robert Cross
Found a strange problem with a system here I'm wondering if anyone can help with. Got a v3.23.41 installation (source build) on RedHat 6.2 using BDB tables. A front end program uses this database via the C API. gcc on this system is egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) At one point

Re: MySQL Server uptime.

2002-03-08 Thread Robert Cross
Neil Silvester wrote: >The server is a lightning fast Pentium Pro 90 with 32 MB EDO RAM and RedHat >7.0. So anyone who still says that the MySQL database can't cut the mustard, >obviously hasn't tried. >Mysql 3.23.43 >Up 212 days, >Processed 199,654 queries (average = 0.01/sec) For comparison:

Re: MySQL PHP Development IDE

2002-02-21 Thread Robert Cross
>His interest lies not so much in using for database table modeling, but for >PHP and Perl development. >How does PHPEd stack up compared to other PHP IDE's? What experience (good >or bad) has anyone had with it? Is there another product that is better? I've just finished using Quanta+ for doin

Re: suse linux 7.3

2002-02-18 Thread Robert Cross
agc wrote: >well I am running suse linux 7.3 and well to be honest I am a real >newbie, so here I go> I am gettingh this error msg> >cant connect to local mysql server through socket >/var/liv/mysql/mysql.sock >so what should I do_ what does this error msg mean_ cheers I had the same problem and

Probably OT - SQL join help needed

2002-02-13 Thread Robert Cross
Hello experts, I've got a small problem with an sql query here that's got me completely stuck. In my MySQL database I've got two tables here that have identical design, e.g. table 'detail' - columns sales-order, quantity, part-number, price, date-sent and table 'archived' - columns sales-order,

Probably OT - SQL join help needed

2002-02-12 Thread Robert Cross
Hello experts, I've got a small problem with an sql query here that's got me completely stuck. In my MySQL database I've got two tables here that have identical design, e.g. table 'detail' - columns sales-order, quantity, part-number, price, date-sent and table 'archived' - columns sales-order,

Re: Uploading to MySQL?

2002-02-12 Thread Robert Cross
ript, in which case you've got one of three routes: 1. LOAD DATA mysql command, (see manual section 3.2.3 for details). 2. A program using one of the API's, (I'm doing something vaguely similar to what you want, and I'm using a C program). 3. PHP and a web page, (i.e. "

Re: Suse V/S Redhat - mysql performance difference.

2002-01-21 Thread Robert Cross
Jatin Nansi wrote: >I have 2 servers 1 running redhat 7.2 and the other running suse 7.3. >the hardware config is : >RH7.2: Fast desktop (IDE HDD/128 MB memory PIII 550 MHz). >Suse 7.3: Low end server (Ultra SCSI 2, PIII 850 MHz, 256 MB RAM). >Now i expect to see the suse server go faster than R

Re: PCAnywhere like linux client - mysql data files administration

2001-12-17 Thread Robert Cross
Jack A Fobel wrote: >I remember seeing a program awhile back that acts like pcanywhere or >terminal services, to connect to a linux or windows box. Anyone remember the >name? Depends what you mean: a. Terminal services, or b. pcanywhere(tm) If it's (a), then you've got a wide choice of: oco

Re: [OT] Undescriptive subjects.

2001-12-10 Thread Robert Cross
Gordan Bobic wrote >I've got an additional idea - how about configuring the mailing list remailer >to put something like [MySQL-General] or [MySQL-Internals] in the subject >line? For some of us who are on multiple lists, it gets really hard to work >out what is what without reading the whole l

Re: Hacked Servers

2001-12-04 Thread Robert Cross
mysql at hotchilli.co.uk wrote: >We have 2 Redhat 6.1 servers and MySQL 3.22.32 and both boxes >appear to have been hacked on Friday last and MYSQL client just hangs >when connecting to the localhost MYSQL server. >MySQL is running on both boxes and suffer the same problems. >We have Intrusion s

Re: opinion - voating

2001-11-27 Thread Robert Cross
Neil Zanella wrote: >On Mon, 26 Nov 2001, Ken Kinder wrote: >> Oracle is certainly more full-featured, but if you know very little about >> databases, Oracle is not the right choice. I agree. First of all the system requirements are high. >For instance the Oracle Universal Installer took someth

Re: MySQL for Dummies (newbies)?

2001-10-25 Thread Robert Cross
Todd wrote: >I come from a microsoft environment and never really had to deal with a >command line based database before. >All the documentation for MySQL doesn't make sense to a rookie and is >frustrating... Anywhere to go where I can feel like I can learn >something? Go to your local compute

Re: How to copy table structure easily.

2001-10-22 Thread Robert Cross
Dexter wrote: >Just want to copy the table structure of a table i Have but dont have the >the create statement and dont want to have to type it again , it has a lot >of fields. Can I easily replicate a table. Hi Dexter, I had the same problem and seem to remember finding the answer hidden in th

Re: intro mysql book

2001-09-16 Thread Robert Cross
another oracle dba <[EMAIL PROTECTED]> wrote: > Can someone recommend an intro MySQL book. I'm looking for a > book with info on MySQL Like you I too have come from an Oracle background to Mysql. Two main sources of information as far as I'm concerned: 1. The MySQL manual that comes with the

Re: Faster mysql

2001-09-12 Thread Robert Cross
Marcin wrote: >How I can make my mysql faster ? Can I compile it with special options? Check out section 5.5 of the manual. I found there's also some very useful information readily available in the file INSTALL-SOURCE* in the top level of the source directory. I'm not sure whether GCC v3.0 mig

Re: Video game programming????

2001-09-12 Thread Robert Cross
>> I was just browsing thru the amazon.com site and just happened to read a >> customer review on the MySQL (other new riders) book by Paul DuBios and >> Michael Widenius. >Ah, the "Perl and MySQL for the Web" book, I imagine. No, Nilesh does mean the "MySQL" book by New Riders, the one with

Re: Video game programming????

2001-09-12 Thread Robert Cross
>It has a wierd review from someone which says >"I was extremely dissapointed to say the least. This book doesn't even begin >to cover **video game programming in mySQL**, not even the basics. In fact, >it doesn't cover **video game programming at all**. . blah blah ." >What's video game

Re: command line open source ARRRGGGGGG!!!!!!

2001-09-07 Thread Robert Cross
Chadrick Mahaffey wrote: >what does all this mean? I tried to type this in my command console changin >/ to \ and I don't understand what is happening. I get all kinds of errors. It looks to me that you're trying to use the Unix install notes - don't! Refer to section 2.1.2 in the excellent man

Re: Licensing terms for an Intranet site

2001-08-29 Thread Robert Cross
>If I'm using MySQL for an intranet site within my corporation, is there any >licensing required? John, we're in the same kind of situation here, (I'm using MySQL as part of something that I'm delivering to another part of the business for their internal use). AFAIK the position is that if you

Re: Downsides of MySQL?

2001-08-16 Thread Robert Cross
y to install/configure, resource-miserly, and fast. Like I said I'm fairly new to MySQL so maybe some of what I've written may not be 100% the gospel, as it's based on my knowledge. I would strongly recommend that your colleague take a few min

Replication housekeeping

2001-08-14 Thread Robert Cross
I've got a fairly simple MySQL system here using replication, one master and one slave. Looking at the system the other day and the database logs are sure building up. Is there any standard way ("best practice") - preferably automated - to keep these under control? If not, I've have a go at doi

Re: Security problem with 3.23.38

2001-07-30 Thread Robert Cross
I wrote: >> I've got a wierd problem with 3.23.38, built from source, running on RedHat >> v6.2 (Intel). Put simply the wildcard character for user access doesn't >> work. From my reading of the docs any of the following: >> grant all on mtdb.* to user1 identified by "bozo1"; >> grant

Security problem with 3.23.38

2001-07-30 Thread Robert Cross
I've got a wierd problem with 3.23.38, built from source, running on RedHat v6.2 (Intel). Put simply the wildcard character for user access doesn't work. From my reading of the docs any of the following: grant all on mtdb.* to user1 identified by "bozo1"; grant all on mtdb.* to user2@"