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,

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

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

[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

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 be a

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

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!!) as

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 machine-name-bin.001 machine-name-bin.002 etc machine-name-bin.index Some of them are huge! They seem

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 doing a

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 I got

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

Re: Uploading to MySQL?

2002-02-12 Thread Robert Cross
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. click this button to upload these files)? Regards Robert Cross, EDS

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

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 RH,

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: o

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 lot.

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

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 something

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 the

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: 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: 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

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

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
would strongly recommend that your colleague take a few minutes and has a look at the on-line copy of the MySQL documentation to clear up some of their misconceptions. Regards Robert Cross. Disclaimer: Writing for myself, not my employers

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

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@%

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 all on