Re: MySQL 3.23.31 configure fails with Berkeley DB 3.2.3h

2001-01-19 Thread Greg Cope
Matt Wagner wrote: Greg Cope writes: Chris Johnson wrote: Description: I just downloaded MySQL 3.23.31 and the "patched version" of Berkeley DB 3.2.3h from the www.mysql.com site. I ran configure with the option to enable the Berkeley DB, but it fails,

Re: PHP and MySQL combo

2001-01-19 Thread Richard Ellerbrock
ps -ef|grep -c mysql Subtract 3 from this as this is the default number of daemons that start. One is spawned for each new child. Yes, if the php script terminates, the mysql child will also terminate. This is not the behaviour with persistant connections though. Please move this over to the

Re: PHP and MySQL combo

2001-01-19 Thread Matt Wagner
Mike Yuen writes: Is there anyway to tell how many connections are currently being served by MySQL. I'm using this in combination with PHP. Also, does MySQL automatically shut down when you leave the page? I'm not using mysql_pconnect - just the regular mysql_connect. Hi! You are

Help me please !!

2001-01-19 Thread Lebrun Jonathan
I use mysql-jdbc-java. I connect java with my database and I've this message : DBLocationHandler: Figuring out the locations and names! (This is a one-time operation!) *** ERROR *** DBLocationHandler:SQL Exception: Column Index out of range * java.sql.SQLException: Column Index

Re: socket problem in red hat.

2001-01-19 Thread Matt Wagner
[EMAIL PROTECTED] writes: Hi there, I am setting up a lab on MySQL and I am not able to. Its a red hat 7.0 server and has PHP installed and working with apache. I installed MySQL from the very RPMs Red Hat provided. Whenever I try to start the server, I get the error message: Can't

Re: you can tell

2001-01-19 Thread Sinisa Milivojevic
john1 writes: dear Sir : MySQL 3.22 on my linux 486 PC seems work so good. when I compile a simple C API programe which catched from the MySQL tutorial, it chokes at the end of compile process . the programe is as follows: #include stdio.h #include mysql.h #define

isamchk error

2001-01-19 Thread Stuart Fox
Hi Can anybody tell me what this error means user@server#isamckh -av {database}/*.ISM isamchk: error: 22 when opening ISAM-table '{database}/tax.ISM'(all tables) System is RedHat 7.0 i386 SMP Standard Kernel mysql-3.22.32 standard compile from source --prefix=/usr/local Ive tried

MySQL 3.23.31 configure fails with Berkeley DB 3.2.3h

2001-01-19 Thread Michael Widenius
Hi! "Chris" == Chris Johnson [EMAIL PROTECTED] writes: Description: Chris I just downloaded MySQL 3.23.31 and the "patched version" of Chris Berkeley DB 3.2.3h from the www.mysql.com site. I ran configure Chris with the option to enable the Berkeley DB, but it fails, telling Chris me I

Re: Select statement that will only take the last submitted entryof it's kind in a certain column.

2001-01-19 Thread Bob Hall
I have a table called CONTENT. Columns called ID (primarykey), DOCUMENT (varchar(50)), DESCRIPTION (text). People submit files to our intranet and we collect info. about them in this table. If people have made changes to the doc. they just resubmit it to the intranet. So there can be many

Re: MAX record on GROUPS

2001-01-19 Thread Bob Hall
This gives me one instance of each file name in the DOCUMENTS column submitted into the database. The only thing though is it gives me the oldest of the file name in the DOCUMENTS column which are submitted. Any ideas how to get the newest one? I've tried adding: , MAX(ID) after the SELECT *.

Re: Update Question

2001-01-19 Thread Bob Hall
Hi. On Thu, Jan 18, 2001 at 05:39:25PM -0500, [EMAIL PROTECTED] wrote: How can I do the following: update location set location.city_id = location_city.city_id where location.city = location_city.name; I want to update one field in a table with values from another table. Is

Re: What degree of concurrency does MySQL support?

2001-01-19 Thread Bob Hall
We are thinking of moving to MySQL. We have a table of several tens of millions of rows, with two indices, which will be accessed by roughly 100 different processes. At any one time, 5 or so of the processes will be doing selects on the table, while 40 or so will be doing updates. However, no

Re: MySQL 3.23.31 configure fails with Berkeley DB 3.2.3h

2001-01-19 Thread Thimble Smith
Description: I just downloaded MySQL 3.23.31 and the "patched version" of Berkeley DB 3.2.3h from the www.mysql.com site. I ran configure with the option to enable the Berkeley DB, but it fails, telling me I don't have the proper version of the DB. Here are the last

forcing tcp/ip connect when connecting to localhost

2001-01-19 Thread Ben Peter
Hi all, can I force the mysql clients to use a tcp/ip connect if connecting to 'localhost'? This need stems from the following situation: I have an ssh account and a mysql DB on one host at my isp. The db can only be accessed from 'localhost', not from any other. I use an ssh tunnel to

Re: forcing tcp/ip connect when connecting to localhost

2001-01-19 Thread Richard Ellerbrock
Normally connecting to the true DNS hostname or the ip address of the machine will do the trick. Connecting to localhost will connect via the loopback address of 127.0.0.1. -- Richard Ellerbrock [EMAIL PROTECTED] Ben Peter [EMAIL PROTECTED] 2001/01/19 02:19:47 Hi all, can I force the mysql

Re: checking table fullness

2001-01-19 Thread Richard Ellerbrock
I am not 100% sure I understand you but I presume you are talking about the 2Gig file size limit of some OS'es? If this is the case, just find out where MySQL stores its databases and have a look at the filesize - you are using the C API, so doing a call to get this info should be trivial.

locks, memory and threads

2001-01-19 Thread Herald van der Breggen
Hello, I have a problem with mysql 3.23.30-gamma. On the busy days with much traffic on t he website, it hapens that suddenly mysql is taking all the resources of the machine at very high speed. The swap increases quick, the threads increase from about 30 (which is average) to over 70 and if

Re: checking table fullness

2001-01-19 Thread Richard Ellerbrock
Richard Ellerbrock wrote: I am not 100% sure I understand you but I presume you are talking about the 2Gig file size limit of some OS'es? If this is the case, just find out where MySQL stores its databases and have a look at the filesize - you are using the C API, so doing a call to get this

3.23.31 gives FULLTEXT problems on sparc64 Linux

2001-01-19 Thread Tibor Simko
Hello After upgrading to 3.23.31, FULLTEXT selects give often "error -1 from table handler" for me. The error log says "ft_read_first: Got error -1 when reading table foo". I think I have not seen those for older 3.23.x versions (x=28 or so), at least not that frequently. A small example to

bug in 3.23.22-beta

2001-01-19 Thread Marc Swanson
Hello list, I am wondering if this bug I found in 3.23.22-beta is a known bug that has been fixed in laater servers. How to replicate: create table test_bug ( text_field varchar(20) NOT NULL, date_field timestamp(14) ); insert into test_bug (text_field,date_field) values

Re: Connection Refused

2001-01-19 Thread Gerald L. Clark
[EMAIL PROTECTED] wrote: The grant was done by: # echo "grant INSERT,SELECT on snort.* to snortdb@'XXX.XXX.0.0/255.255.0.0';" | mysql -u root -p The system has TCP wrappers setup and the hosts.allow file is empty and hosts.deny is set to ALL:ALL. next time I'm at work I'll try putting

Re: bug in 3.23.22-beta

2001-01-19 Thread Rolf Hopkins
That's no bug. That is what timestamp is, current date and current time no matter whether you insert or update. Read the manual more carefully. What I think you want is date column, not timestamp. - Original Message - From: "Marc Swanson" [EMAIL PROTECTED] To: "mysql list" [EMAIL

Re: isamchk error

2001-01-19 Thread Gerald L. Clark
Stuart Fox wrote: Hi Can anybody tell me what this error means user@server#isamckh -av {database}/*.ISM isamchk: error: 22 when opening ISAM-table '{database}/tax.ISM'(all tables) If this was part of a script, then database was a variable that contained the full path to the

Re: bug in 3.23.22-beta

2001-01-19 Thread Basil Hussain
Hi, That's no bug. That is what timestamp is, current date and current time no matter whether you insert or update. Read the manual more carefully. What I think you want is date column, not timestamp. If you really do want to store an actual timestamp figure in your table without it being

Bug with Apache

2001-01-19 Thread Simone Gommaraschi
Description: when i compile apache and php4 with mysql and postgresql support i have this error for mysql This is the error # === src/modules gcc -c -I./os/unix -I./include -DLINUX=2 -I/usr/src/php-4.0.4pl1 -I/usr/src/php-4.0.4pl1/main

synopsis of the problem (one line)

2001-01-19 Thread simone
Description: when i compile apache and php4 with mysql and postgresql support i have this error for mysql # === src/modules gcc -c -I./os/unix -I./include -DLINUX=2 -I/usr/src/php-4.0.4pl1 -I/usr/src/php-4.0.4pl1/main -I/usr/src/php-4.0.4pl1/main

RE: Crashing MySQL on FreeBSD4.2 with Apache/php4

2001-01-19 Thread Nicolai Gylling
Hi again Now i've tried running with the 3.23.26-beta from the ports tree for a couple of days, and the server has got a lot more stable, but stil we experience appox. 20 restarts a day. Furthermore we are getting a lot of these: Aborted connection 64 to db: 'username' user: 'testuser' host:

Re: A new engine under MySQL with trx row-level locking

2001-01-19 Thread Heikki Tuuri
Hi! I hope that this message goes to the right 'thread' in the mailing list; not replied to a thread before. Monty recommended that we should wait still for a few weeks before releasing MySQL 4.0/Innobase-alpha, to keep source code versions in control. But I can now report here the current

RE: MySQL 3.23.31 configure fails with Berkeley DB 3.2.3h

2001-01-19 Thread Ivanisevic, Irena
Hi ! I am trying to implement BDB tables on windows NT. I have installed mysql 3.23.31 and have downloaded Berkeley db file 3.2.3. I am new to mysql. I have tried to look for instructions but I have no luck. Thanks Irena -Original Message- From: Michael Widenius [mailto:[EMAIL

Re: MySQL 3.23.31 configure fails with Berkeley DB 3.2.3h

2001-01-19 Thread Thimble Smith
On Fri, Jan 19, 2001 at 12:48:44PM +, Greg Cope wrote: But does the conspiricy not continue ? Yes, I suppose it does. I guess my secret spy status as enemy of the state is now out in the open, plain as day. Do you not need to patch aclocal.m4 as this contains a referance to 3.2.3g,

Re: Crashing MySQL on FreeBSD4.2 with Apache/php4

2001-01-19 Thread Ken Menzel
Nicolai, As I sent you earlier, on the 17th, you MUST upgrade your FreeBSD to FreeBSD-stable of January 10th or later, or apply the patch I sent you and recompile, or use the contributed binary on the mysql web page: http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.30-gamma-unknown-

HELP with SQL statement

2001-01-19 Thread Mike Podlesny
I have a table called RATING and two fields one called POSITIVE and the other called NEGATIVE. I need to write an SQL statement for my mySQL database that will return the value of the total of POSITIVEs minues the total of the NEGATIVEs. Any ideas?

how to use count to compare number?

2001-01-19 Thread Liu Danyu
dear all: I need some help from you. The dataset is as following maker pc.id a1 a2 a3 b4 b5 I need to retrieve the maker which include at least 2 pc.id. I try to write in this form, but it is error! select maker from table1 where count(pc.id) 2 group by maker. thank

myisampack - segmentation fault

2001-01-19 Thread Gernot Pansy
Hy! i have some trouples to compress one table (http://www.notz.ro/table.tar.gz) with myisamcheck. myisampack always terminate with a segementation fault. here an example: istanbul:/var/mysql/sms_plus # /usr/local/mysql/bin/myisampack -vf message_archiv_25 Compressing

HELP with SQL statement

2001-01-19 Thread Mike Podlesny
Actually let me reword this because Tomi's answer won't quite work. The table has a field called Rating. A number 1 is stored to represent positive a 2 is stored for neutral and a 3 is stored for negative. I need to query that will query up all the number 1's (positives) and subtract all the

Re: Front End Needed

2001-01-19 Thread bill
Hello, I need to find a web front end that I can use to update a table in MySQL. What I'm looking for is a program that will display an entire table with records as a web page for editing. Something like a submit button at the bottom to send in the updates to the server. Does something

Is there any probleme with datatype DATE ??

2001-01-19 Thread Michel Tignyemb
I have just install the source distrib. 3.23.30g of MySQL. I have this (while I am testing ) : mysql CREATE TABLE t1 ( datum DATE ); Query OK, 0 rows affected (0.00 sec) mysql INSERT INTO t1 VALUES ( "2000-1-1" ); Query OK, 1 row affected (0.00 sec) mysql INSERT INTO t1 VALUES (

Feature Request:

2001-01-19 Thread Aaron's Shell Login
I am BEGGING you to please make the describe command OPTIONALLY display the Privileges column. Before 3.23, I was able to see the describes properly. Now the command is almost totally useless to me! Aaron - Before posting,

RE: MySQL 3.23.31 configure fails with Berkeley DB 3.2.3h

2001-01-19 Thread Sinisa Milivojevic
Ivanisevic, Irena writes: Hi ! I am trying to implement BDB tables on windows NT. I have installed mysql 3.23.31 and have downloaded Berkeley db file 3.2.3. I am new to mysql. I have tried to look for instructions but I have no luck. Thanks Irena Hi! Support for BDB

temp tables lock unrelated tables

2001-01-19 Thread Michael Griffith
Using SHOW PROCESSLIST or mysqladmin proc Every time a table reports status of 'copying to tmp table' all other UPDATE queries are locked, even in unrelated tables. For example: Query #1: SELECT * FROM a JOIN B WHERE Status: copying to tmp table Query #2: UPDATE C SET x=x+1 WHERE..

Re: HELP with SQL statement

2001-01-19 Thread Tomi Junnila
* Mike Podlesny [EMAIL PROTECTED] wrote on 19.01.01 17:52: Actually let me reword this because Tomi's answer won't quite work. The table has a field called Rating. A number 1 is stored to represent positive a 2 is stored for neutral and a 3 is stored for negative. I need to query that will

Re: HELP with SQL statement

2001-01-19 Thread Milo Stefani
I think that this will do SELECT -(Sum(Rating-2)) AS Total FROM Rating GROUP BY 1; - Original Message - From: "Mike Podlesny" [EMAIL PROTECTED] To: "Tomi Junnila" [EMAIL PROTECTED]; "mySQL Mailing List" [EMAIL PROTECTED] Sent: Friday, January 19, 2001 4:50 PM Subject: HELP with SQL

MySQL Ver 11.11 Distrib 3.23.31 JDBC

2001-01-19 Thread Victor Batista
Hello, I am having an error while trying to connect through JDBC to mysql using the "mm.mysql-2.0.2-bin.jar" driver. The error occurs whether I run my Java program locally or remotely. SQLException: Server configuration denies access to data source SQLState: 08001 VendorError: 0

how to count rows in JDBC ResultSet ?

2001-01-19 Thread Dainius Ramanauskas
Hello, I want to know the number of rows in a JDBC-ResulSet just by calling a function like it's done in PHP with mysql_num_rows($result) There seems to be no such function in the ResultSet interface as defined in Java 2. cheers Oliver Doepner

Re: 3.23.31 gives FULLTEXT problems on sparc64 Linux

2001-01-19 Thread Sergei Golubchik
Hi! On Jan 19, Tibor Simko wrote: Hello After upgrading to 3.23.31, FULLTEXT selects give often "error -1 from table handler" for me. The error log says "ft_read_first: Got error -1 when reading table foo". I think I have not seen those for older 3.23.x versions (x=28 or so), at least

Re: temp tables lock unrelated tables

2001-01-19 Thread Sinisa Milivojevic
Michael Griffith writes: Using SHOW PROCESSLIST or mysqladmin proc Every time a table reports status of 'copying to tmp table' all other UPDATE queries are locked, even in unrelated tables. For example: Query #1: SELECT * FROM a JOIN B WHERE Status: copying to tmp table

Re: temp tables lock unrelated tables

2001-01-19 Thread Michael Griffith
My TMPDIR is actually not separate from the data. There is plently of disk space. In fact, thinking it was some sort of RAM problem I reduced the size of the database by almost 30% with no change in performace. You say this should not happen, yet as I've been searching the mailing list there's

Re: Connection Refused

2001-01-19 Thread Kevin . Brown
Doing that was just a test, and I didn't think it would work since Inetd is not running on the box at all. In fact the only way to get to these boxen (aside from walking over) is via SSH. I find it interesting that on the box that I want to actually do the logging to I can telnet to port 3306

The function of auto_increment and Premier Key?

2001-01-19 Thread SED
Hi I'm relatively new to MySQL though I familiar to other simple databases. I have been reading the manual but not doing well understanding the function of auto_increment and Premier Key. Lets say I have a table with a few columns. One of them is an ID with auto_increment. It has 1000 rows. If I

Simple DoS scenario against mysql slaves

2001-01-19 Thread Andreas Steinmetz
Referring to my post "instant slave crash (signal 11) on 'set password'" to [EMAIL PROTECTED]: The scenario is still valid for 3.23.31. This means that any valid mysql user can cause the replicating slaves to crash using the 'set password' command. So any valid user can even unintendedly cause

Connection Freeze (new feature proposal)

2001-01-19 Thread Artem Koutchine
Hi! I've been thinking here about databases and their use in WEB developemnt and have come to a conclusion that transactions are very often useless in real web applications, because creating one logical object in database (sorry for OO notatitions, but I often use RDBMSes for mapping object

Re: MySQL 3.22.32 shutting down

2001-01-19 Thread Ken Menzel
What OS and version? Is it patched to current patch levels? - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: "Michael L. Smeby, Jr." [EMAIL PROTECTED] To: "Mysql Mailing List" [EMAIL PROTECTED]

installing and configuring Mysql on red hat linux 6.2

2001-01-19 Thread Stephen Lambert,CSI
Hi, I would like to know where i can find information how to: Install and configure My sql on red hat linux 6.2 Create,manage and backup database, several client. Where can i find professional and not expensive support to learn how to manage my sql. Thank.. Stephen T.

Replicating MySQL

2001-01-19 Thread Karl J. Stubsjoen
Hello, How could we replicate our MySQL DB from one server to another? As a back up measure, incase our pages fail to connect to ServerA, it'll then try to connect to ServerB? Thanks! Karl ...and what is the word I am looking for, it isn't replicate but something else?

Re: Simple DoS scenario against mysql slaves

2001-01-19 Thread Sasha Pachev
On Friday 19 January 2001 11:16, Andreas Steinmetz wrote: Referring to my post "instant slave crash (signal 11) on 'set password'" to [EMAIL PROTECTED]: The scenario is still valid for 3.23.31. This means that any valid mysql user can cause the replicating slaves to crash using the 'set

RE: TRUNCATE causes corrupted tables

2001-01-19 Thread Steven Roussey
Hi! No, I can't repeat it on command, sorry. However, I can give a little more info. When inserting, the index file got bigger. It was the data file that was set to 0 bytes, but did not get bigger on inserts. Doing a repair fixed it. I have some tables truncated via scripts, so I turned on

RE: Replicating MySQL

2001-01-19 Thread John Halladay
"Mirror" is the word you're looking for. -Original Message- From: Karl J. Stubsjoen [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 11:55 AM To: MySql list Subject: Replicating MySQL Hello, How could we replicate our MySQL DB from one server to another? As a back up

Re: How do I use index files?

2001-01-19 Thread Don
Prior to updating, I want to search the table to see if my Key exists. That way, I can add it or just update the associated fields. How do I tell my script which Index file to use? I can't seem to find the equivalent of the dBase style "Set Order to". Errr... If I understand your

Need MYSQL for COBALT Rack3

2001-01-19 Thread lkeeton
Need some help. I need the RPM files for the Cobalt Rack 3. Any ideas. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

Re: Connection Refused

2001-01-19 Thread Gerald L. Clark
Do you hae the line 127.0.0.1 localhost.mydomain localhost in your /etc/hosts file? It sounds like your resolver is not working. [EMAIL PROTECTED] wrote: Doing that was just a test, and I didn't think it would work since Inetd is not running on the box at all. In fact the only way

Re: forcing tcp/ip connect when connecting to localhost

2001-01-19 Thread Pete Harlan
can I force the mysql clients to use a tcp/ip connect if connecting to 'localhost'? Normally connecting to the true DNS hostname or the ip address of the machine will do the trick. Connecting to localhost will connect via the loopback address of 127.0.0.1. If you connect to the true DNS

3.22.23 table problem

2001-01-19 Thread Goodman, Michael
I'm not sure exactly what happened, but mysql was freezing everytime I tried to access a particular table...everytime I tried to select anything from it, alter it, drop it, whateverjust nothing worked and mysql crashed. I ended up having to temporarily remove the table files, kill mysql and

Database access Logging

2001-01-19 Thread Arslan Saeed
Hi, I want my mysql to track user login information and commands they run at mysql client? Any one can help me to do this please? bye! - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Connection Refused

2001-01-19 Thread Kevin . Brown
The line is 127.0.0.1 localhost.localdomain localhost Do you hae the line 127.0.0.1 localhost.mydomain localhost in your /etc/hosts file? It sounds like your resolver is not working. [EMAIL PROTECTED] wrote: Doing that was just a test, and I didn't think it would work since

Re: forcing tcp/ip connect when connecting to localhost

2001-01-19 Thread Ben Peter
Pete, thanks for your exhaustive answer. I didn't try using '127.0.0.1' instead of 'localhost', as I though that anything that points to the lo interface would be using a socket. luckily, speed is no concern to me, as this connection is only used to make php development while being able to

Re: How do I use index files?

2001-01-19 Thread Gerald L. Clark
Don wrote: Prior to updating, I want to search the table to see if my Key exists. That way, I can add it or just update the associated fields. How do I tell my script which Index file to use? I can't seem to find the equivalent of the dBase style "Set Order to". Errr... If I

Re: How do I use index files?

2001-01-19 Thread Don
Don wrote: Prior to updating, I want to search the table to see if my Key exists. That way, I can add it or just update the associated fields. How do I tell my script which Index file to use? I can't seem to find the equivalent of the dBase style "Set Order to". Errr...

encode() question

2001-01-19 Thread Lonnie Cumberland
Hello All, I have noticed that the Encrypt() is a oneway function that will also give different resulting messages for the same message being encrypted multiple times. I have also noticed that the Encode() will result in a message that is a binary type. What I need to do is to find a way to

Re: isamchk error

2001-01-19 Thread Stuart Fox
"Gerald L. Clark" wrote: Stuart Fox wrote: Hi Can anybody tell me what this error means user@server#isamckh -av {database}/*.ISM isamchk: error: 22 when opening ISAM-table '{database}/tax.ISM'(all tables) If this was part of a script, then database was a variable that

temp tables lock unrelated tables

2001-01-19 Thread Michael Griffith
Earlier I posted a message about SHOW PROCESSLIST reporting queries "locked" whenever another thread is "Copying to tmp table" After many more hours of diagnosis, the actual problem is somewhat different: MySQL does report other processes as locked. But they do not wait until the temp table

Weird update where something != otherthing

2001-01-19 Thread Diogo Zulli
Maybe this the correct behavior, but I am confused about the statments below: CREATE TABLE testing ( fmsg CHAR(1) DEFAULT 'N' ); INSERT INTO testing VALUES (NULL); INSERT INTO testing VALUES ('Y'); INSERT INTO testing VALUES ('X'); INSERT INTO testing VALUES ('Y'); INSERT INTO testing VALUES

inserts with now() resulting in replication-problems

2001-01-19 Thread Jan Kirchhoff
My Replication-Slave crashed a few days ago with an error in the error-log saying something like "duplicate primary key processing query "INSERT INTO testtable (time,name,number) VALUES (NOW(),'Hello',10)" testtable's primary key was (time,name) time: datetime name: varchar number: int What

Re: encode() question

2001-01-19 Thread Gerald L. Clark
Lonnie Cumberland wrote: Hello All, I have noticed that the Encrypt() is a oneway function that will also give different resulting messages for the same message being encrypted multiple times. I have also noticed that the Encode() will result in a message that is a binary type.

Re: temp tables lock unrelated tables

2001-01-19 Thread Gerald L. Clark
Michael Griffith wrote: Earlier I posted a message about SHOW PROCESSLIST reporting queries "locked" whenever another thread is "Copying to tmp table" After many more hours of diagnosis, the actual problem is somewhat different: MySQL does report other processes as locked. But they do

Re: Replicating MySQL

2001-01-19 Thread Jeremy D. Zawodny
On Fri, Jan 19, 2001 at 11:54:34AM -0700, Karl J. Stubsjoen wrote: How could we replicate our MySQL DB from one server to another? Yes. And it's documented in the fine manual: http://www.mysql.com/doc/R/e/Replication.html As a back up measure, incase our pages fail to connect to ServerA,

mysql++: How to save a row[i] as a char*

2001-01-19 Thread Juergen Leeb
How can I get a row[i] in a char* or a qstring variable? thank for helping! juergen leeb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

Re: ANNOUNCE: myrepl - automate inital mysql replication setup on master server without down-time

2001-01-19 Thread Jan Kirchhoff
* It'd be handy to create a compressed tar file (.tar.gz). I'll probably add that. great ;) but i'll transfer it compressed with scp, so it's no big problem for me. But a "-z"-switch would probably be useful for lots of people. * It'd be nice to specify which databases/tables

Re: inserts with now() resulting in replication-problems

2001-01-19 Thread Vivek Khera
"JK" == Jan Kirchhoff [EMAIL PROTECTED] writes: JK If the Slave gets out of sync (loses the connection to the server), connects JK again and tries to catch up, it processes those two queries *within one JK second* which would result in an duplicate primary key on the slave. The JK Slave

Replication

2001-01-19 Thread Paul Mattheis
I never like doing the simple things, it's the complex things that are more fun... I would like to be able to create my own backend for the replication slave server. Meaning, I would like to recieve the replication log data from the master (getting all the benefits) and then do something

Re: Replication

2001-01-19 Thread Jeremy D. Zawodny
On Fri, Jan 19, 2001 at 05:16:16PM -0500, Paul Mattheis wrote: I never like doing the simple things, it's the complex things that are more fun... I would like to be able to create my own backend for the replication slave server. Meaning, I would like to recieve the replication log data

MySQL is safe (enough?)

2001-01-19 Thread Fábio Ottolini
Dear all, I know that many MySQL developers are subscribers of this list and I decided to ask this question with all the possible respect that the developers and MySQL itself deserves. I think it's the most appropriate list to do this and the place where I will receive the most precise answers.

Re: What degree of concurrency does MySQL support?

2001-01-19 Thread Jeremy D. Zawodny
On Fri, Jan 19, 2001 at 06:58:34AM -0500, Bob Hall wrote: MySQL has only table level locking, which means that each update will lock the entire table, which means that updates must be done one at a time. There are a couple of open source extensions of MySQL that are supposed to offer row

MySQL and Oracle

2001-01-19 Thread Jason Radley
I am currently using php and mysql and I was wondering if you can take the data from a mysql database and move it to a oracle database? Thank you, Jason - Before posting, please check: http://www.mysql.com/manual.php (the

Insert-Select problem

2001-01-19 Thread Tobias Talltorp
I am performing a query in two tables and output it into a temporary table for further sorting. The problem is that in one of the tables (TableB), I have an additional id that I want to be added to the temptable. This id is not present in TableA. I get this error message when I run the query for

copying a table

2001-01-19 Thread Nancy Quesenberry
I too am having trouble with the simple task of copying a table. I am using 3.22.23b. I wanted to use the create with insert but was told this isn't supported by 3.22. So i have created the new table and figured I would use an insert. i can't get this to work either. insert into NewTable

examples of large mysql databases

2001-01-19 Thread Brett Paden
I have been using mysql for many years and have failry reliable web-based applications using tables with 3 million+ records. I am curious as to other people's experiences with larger amounts of data, like 5 to 50 million record tables (I am assuming each record has dozens of columns of various

Re: Connection Refused

2001-01-19 Thread James F Wilkus
AMEN. On Fri, Jan 19, 2001 at 06:44:22PM -0700, Colin Faber wrote: !!! localhost.localdomain is not a TLD!! Don't break the RFC with this redhat crap. [EMAIL PROTECTED] wrote: The line is 127.0.0.1 localhost.localdomain localhost Do you hae the line 127.0.0.1

replication of tables with 10 million rows?

2001-01-19 Thread Jan Kirchhoff
one of my tables has ~10 million rows (but just 4 columns: int,double,double,date (date,int as primary key)) and when i started a replication on that database it crashed within 48 hours without any messages in the error-log. the mysql-server stays, up, just the replication dies. i don't have

Re: replication of tables with 10 million rows?

2001-01-19 Thread Jeremy D. Zawodny
On Sat, Jan 20, 2001 at 03:58:44AM +0100, Jan Kirchhoff wrote: i just wondered if someone has a replication running with that number of rows or even more in one table? One of the tables in our replication setup has ~35 million rows in it. The rows are similar in nature to yours. We've not

Re: examples of large mysql databases

2001-01-19 Thread Jeremy D. Zawodny
On Fri, Jan 19, 2001 at 08:12:49PM -0600, Brett Paden wrote: I am curious as to other people's experiences with larger amounts of data, like 5 to 50 million record tables (I am assuming each record has dozens of columns of various datatypes). ~35 million records in one table without any

RE: A report generator MySQL

2001-01-19 Thread Daniel Von Fange
What output media do you want? Paper or web? Some text formating tools I have found are: http://www.geocities.com/SiliconValley/Ridge/4280/GenericReportWriter/grwhom e.html http://mytextreport.sourceforge.net/en/manual.html Or, if you want to output to HTML, you could use the PHP programing

Re: A report generator MySQL

2001-01-19 Thread Danny
-Hello - You can try the following methods:- Use php to code the report. This is easy once you have experience with php but there are many free php code out there such as phpwizards.net which can assist you. Cystal Report by Seagate is also a very good report generator. I am sure Cystral

Re: Setting Up Users!

2001-01-19 Thread Danny
MySQL has nothing to do with /etc/passwd You need to look at the mysql by typing in mysql -u root -p mysql Then you type in DESCRIBE mysql You should see somehting like the user table. All you have to do is use INSERT INTO sql statements or even look up the mysql manual for the usage of

Re: MySQL and Oracle

2001-01-19 Thread Tõnu Samuel
Jason Radley wrote: I am currently using php and mysql and I was wondering if you can take the data from a mysql database and move it to a oracle database? Thank you, mysqldump exports data from MySQL database and them Oracle should be able to import it. -- MySQL Development Team __

Re: Setting Up Users!

2001-01-19 Thread Tõnu Samuel
Muhanad Mustafa wrote: Ok, i'm very new to Mysql. . The documentation is a little confusing for me to figure out so I thought this might help. I had created a database on my system called "customer15" I did this mysqlcreate database customer15 Now I want to setup a mysql username

Re: What degree of concurrency does MySQL support?

2001-01-19 Thread Bob Hall
On Fri, Jan 19, 2001 at 06:58:34AM -0500, Bob Hall wrote: MySQL has only table level locking, which means that each update will lock the entire table, which means that updates must be done one at a time. There are a couple of open source extensions of MySQL that are supposed to

OT: Alpha XL300 Server Buying Advice?

2001-01-19 Thread Van
Greets All: Sorry about the off-topic, but, not finding much useful out there w/ respect to a buying decision. e-Mail me off-list, please. Have an opportunity to pick up this unit very cheap with 18GBytes of scsi storage, 192 MBytes RAM, on a 300MHz Alpha XL300 Processor. Looking at setting

Fatal bug in 3.23.31

2001-01-19 Thread Sasha Pachev
We have just discovered a fatal bug in 3.23.31 that will cause mysqld to segfault if the client closes connection without a call to mysql_close() -- very common situation with many clients, including earlier versions of PHP 4. The bug is very serious. We recommend that you either apply the

MyODBC installation

2001-01-19 Thread muruganandam
I have downloaded the win95 version for MyODBC and when i tried instaling using setup.exe it says cannot copy MFC30.DLL which is already present in the system directory. can you help me please. I have a 3.23.25 beta version of server. regards

configure.in

2001-01-19 Thread Hiroyuki Sato
Dear MySQL Devloperes. When compile mysql-3.23.31 with db-3.2.3h, BerkeleyDB cannot detect in configure There are two plan patches for compile MySQL with db-3.2.3h I think this is better than current configuren. plan A: +=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=

  1   2   >