Re: mysql update user

2002-10-30 Thread joseph speigle
On Tue, Oct 29, 2002 at 11:56:01AM +0200, Egor Egorov wrote: > Marco, > Tuesday, October 29, 2002, 7:22:44 AM, you wrote: > > MB> I need your expert and slow guided assistance. > > MB> I would some one to teach me how to do for that user > MB> and allow him/website to have access to that database

Re: Thread Thrashing and 3.23.53a

2002-10-30 Thread Mark
- Original Message - From: "heath boutwell" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, October 30, 2002 4:34 PM Subject: Re: Thread Thrashing and 3.23.53a > If you stick with 53a let us know what you see. Others that > experienced problems upgrad

Re: Questions about logfile's suffix numbering.

2002-10-30 Thread Paul DuBois
At 13:20 +0900 10/31/02, Chung Ha-nyung wrote: Dear, I'v mailed about this question before and got no complete answer, so I'm asking again. Victoria said that suffix number next to 999 will be 1000 but didn't mention about the limit of suffix. I'm wondering whether the suffix number always in

Questions about logfile's suffix numbering.

2002-10-30 Thread Chung Ha-nyung
Dear, I'v mailed about this question before and got no complete answer, so I'm asking again. Victoria said that suffix number next to 999 will be 1000 but didn't mention about the limit of suffix. I'm wondering whether the suffix number always increases. That is, does not return to 000? I'

Re: Questions on MySQL 3.23.36 and MM.MySQL JDBC Driver

2002-10-30 Thread Mark Matthews
Tan Phooi San wrote: Hi, I got some questions regarding MySQL 3.23.36 and MM.MySQL JDBC Driver. Hope you could help me on this. 1. Can both products mentioned above working in Red Hat Linux 7.3 or 8.0? You don't mention what version of MM.MySQL you're interested in, but since it's no longer

Question re: Displaying data on a website.

2002-10-30 Thread Beauford
I have a website using PHP and MySQL and having a problem. This is what I have: $db = mysql_connect("1.1.1.1","name","password"); mysql_select_db("database"); $query = "SELECT title, artist FROM songlist WHERE songlist.songid=1"; $result = mysql_query($query) or die("Query failed"); Then I have

Re: AVG question

2002-10-30 Thread Benjamin Pflugmann
Hello. On Wed 2002-10-30 at 16:45:00 -0800, [EMAIL PROTECTED] wrote: > Hello, > > I am trying to query a table for all unique ID's that have an average of > "10". > > carrier_idrating > = > 34 10 > 368 > 309 > 34 10 > >

Questions on MySQL 3.23.36 and MM.MySQL JDBC Driver

2002-10-30 Thread Tan Phooi San
Hi, I got some questions regarding MySQL 3.23.36 and MM.MySQL JDBC Driver. Hope you could help me on this. 1. Can both products mentioned above working in Red Hat Linux 7.3 or 8.0? 2. What are the latest version of both products? 3. What are the differences between the latest version and both pr

Error No. 5 Question

2002-10-30 Thread David Losen
Hello, I've trying to research the input/output error no 5. Any ideas on what causes it to happen? Does the idea that the hard drive is faulty make any sense? System: RedHat 7.2 mysql 3.29a-gamma Thank in advance for any help. Dave Losen -

Startup question: MySQL comes with RedHat 7.3

2002-10-30 Thread Jack Chen
Hi All, I just installed full RedHat7.3, which comes with a MySQL package. I am wondering whether it is only a client or both client and server. I could not find that mysql.server command. How should I start the server if there is a server? Thank you for your attention. Jack ++

Re: Thread Thrashing and 3.23.53a

2002-10-30 Thread Mark
- Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Mark" <[EMAIL PROTECTED]> Cc: "heath boutwell" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, October 30, 2002 6:06 AM Subject: Re: Thread Thrashing and 3.23.53a > On Wed, Oct 30, 2002 at

re: Unable to Start the Server

2002-10-30 Thread Jason Thiesse
"Error 13 means that mysqld doesn't have permissions on the host.frm file." I changed the permissions on host.frm to the following: -rw-rw-rw- I am still getting the same error. I tried a search on the archive for "errno: 13", but it return 0 results. Any other ideas? Thanks Jason

AVG question

2002-10-30 Thread Kevin
Hello, I am trying to query a table for all unique ID's that have an average of "10". carrier_idrating = 34 10 368 309 34 10 My result should be carrier_id 34 as it is the only carrier with an average rating of 10. A

Re: MySQL-4.0 and PHP with Red Hat 8.0

2002-10-30 Thread Dave Best
Your probably better off getting it and compiling it by hand. Dave - Original Message - From: "Florin Andrei" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 30, 2002 4:36 PM Subject: MySQL-4.0 and PHP with Red Hat 8.0 > Anyone tried to use MySQL-4.0 and the precom

RE: klez worm (OT)

2002-10-30 Thread Peter Lovatt
Hi I am getting two or three klez infected emails a day to the address I use for these lists Somebody out there is probably infected. Do us all a favour and make sure you are virus free :) Thanks Peter sql,query,php blah.. --- Excellence in inte

Problem installing MYODBC3.5 on cobalt cube

2002-10-30 Thread Liam Meadows
sql,query Tried the following but get this error message: [root sun]# rpm -i MyODBC-3.51.04-1.i386.rpm error: failed dependencies: libc.so.6(GCC_3.0) is needed by MyODBC-3.51.04-1 libc.so.6(GLIBC_2.2) is needed by MyODBC-3.51.04

Re: Whats better increase RAM or CPU for a mysql/perl app.

2002-10-30 Thread Bruce Lewis
I agree with those thoughts, but maybe my professional experience in dealing with a similar situation will provide you a little insight. >From experience, if the boxes are not true server motherboards, you may not get the desired results using the 750MHz and 3GB of RAM. This being that even thoug

Re: Lost connection to MySQL server during query

2002-10-30 Thread Frederic Trudeau
Yes, I use RedHat, and have try to find info on the mailing list and google, without any luck. --- Frederic Trudeau Consultant, PHP Coder, Development [EMAIL PROTECTED] - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EM

Error Code Question

2002-10-30 Thread Alan McDonald
This error comes up when altering table structure BUT it times out after a while. Error: 7 - Error on rename of '.\DBNAME\tablename.MYI' to '.\DBNAME\#sql2-61-19.MYI' (Errcode: 13) Some have said - "oh yeah, that's a permissions problem" but if it times out and finally the command executes after

Re: Whats better increase RAM or CPU for a mysql/perl app.

2002-10-30 Thread Benjamin Pflugmann
Hi David. On Wed 2002-10-30 at 14:56:38 -0600, [EMAIL PROTECTED] wrote: > > I have a word search application using mysql and (perl or mod_perl). > After all the optimization of code I now want to get a faster box. > [...] > I have 2 choices: > a. box with 1.3 GHZ with 1.5 GIG of RAM > b. 750 MHZ

Re: (perl) script for replication log rotation

2002-10-30 Thread Marc Prewitt
Here's one which takes log rotation a step further than mysql provides for. It is run on the slaves to keep track of their position and then run on the master to purge up to the earliest slave position. This is useful because you can't reliably get all the slaves' latest position by looking at a

MySQL-4.0 and PHP with Red Hat 8.0

2002-10-30 Thread Florin Andrei
Anyone tried to use MySQL-4.0 and the precompiled PHP (the one from the distribution packages) in Red Hat 8.0? Any problems? -- Florin Andrei Many would-be screenwriters seem to have the impression that they can write a script based only on an idea. This is similar to the impression that many ha

Can anyone tell me what GLIBC version is causing Mysql to crash?

2002-10-30 Thread David Kramer
Can anyone tell me what GLIBC version is causing Mysql to crash? Thanks, DK David Kramer Software Developer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 - Before posting, please check: http://www.mysql.com/manual.php

Re: date/time calc

2002-10-30 Thread Cory Hicks
Chris, This is how I do it: SELECT UNIX_TIMESTAMP(time_sign_out) -UNIX_TIMESTAMP(time_sign_in)/3600 AS hours HTH! Cory On Wed, 2002-10-30 at 13:50, Raymer, Chris wrote: > Having trouble getting the syntax to calculate the time difference given 2 dates >like so: > > A.) 2002-01-02 21:33:0

Re: BUG with dates and BETWEEN operator

2002-10-30 Thread Sinisa Milivojevic
Hi! Thank you for your bug report. It helped us fix a bug . A fix will come in version 4.0.5. This is a patch that fixes a problem: = sql/field.h 1.41 vs edited = *** /tmp/field.h-1.41-18621 Wed Oct 16 12:32:31 2002 --- edited/sql/field.h Wed Oct 30 17:24:58 2002 *** **

mysqladmin question

2002-10-30 Thread Tom Ray
I just got a Red Hat 7.3 box up and running and have mysql on it...I've noticed that when using mysqladmin it doesn't prompt me for a password like other boxes that I've been on(ones I didn't build) have...is there a way to set this? TIA ---

date/time calc

2002-10-30 Thread Raymer, Chris
Having trouble getting the syntax to calculate the time difference given 2 dates like so: A.) 2002-01-02 21:33:00 B.) 2002-01-03 00:12:00 In SQL Server could DateDiff. Have tried combinations of TO_DAYS, MINUTE,HOUR etc to no avail. Please Help. Chris Raymer --

Whats better increase RAM or CPU for a mysql/perl app.

2002-10-30 Thread David Jourard
Hi List, I have a word search application using mysql and (perl or mod_perl). After all the optimization of code I now want to get a faster box. I have 2 choices: a. box with 1.3 GHZ with 1.5 GIG of RAM or b. 750 MHZ with 3 GIG of RAM These 2 choices are limited by cost. What would be bette

Problem JOINing with Aliases

2002-10-30 Thread Bruce Hodo
I have a database defined with the following tables: CREATE TABLE pix ( id int(11) NOT NULL auto_increment, propertyid int(11) NOT NULL default '0', filename varchar(25) default NULL, caption varchar(50) default NULL, width smallint(4) unsigned NOT NULL default '0', height smallint(4)

Where are all of the .TMP files coming from

2002-10-30 Thread Norris, Joseph
Hello everyone, I have a small system running on a windoze 2000 box, several perl scripts that slice'n'dice and put stuff into my db. Other perl scripts do simple queries - maybe one join in the whole mess. Everything was running great - but now I get repeated groups of TMP files that I can not de

Re: Thread Thrashing and 3.23.53a

2002-10-30 Thread Benjamin Pflugmann
Hi. On Wed 2002-10-30 at 10:20:05 -0800, [EMAIL PROTECTED] wrote: > >Heath, I once had similar symptoms when my DNS resolving had problems > >and all new connections "slept" for some seconds while they were > >waiting for an response. My work-around was to use --skip-name-resolve > >until the DNS

RE: Re[2]: Start Transaction in InnoDB

2002-10-30 Thread Fernando Grijalba
This is what I think. When Autocommit is set you DO NOT have to enter COMMIT after you update your DB (Update, Insert Delete), but you will be changing the DB after every statement, therefore you cannot change your mind after the command is execute. Now as for BEGIN, it will begin a Transaction r

Re: Thread Thrashing and 3.23.53a

2002-10-30 Thread Jeremy Zawodny
On Wed, Oct 30, 2002 at 10:20:05AM -0800, heath boutwell wrote: > >Heath, I once had similar symptoms when my DNS resolving had problems > >and all new connections "slept" for some seconds while they were > >waiting for an response. My work-around was to use --skip-name-resolve > >until the DNS pro

Last row in table

2002-10-30 Thread Aamer Rauf
I have a mysql database. Lets say it has a table called "maintable" with primary key as main_id. I want to add other tables to the database and use main_id as foriegn keys in those tables. If I want to start with the last row of the maintable how can I using a perl script get main_id from the la

OT: CF and mySQL - cont'd thread

2002-10-30 Thread FlashGuy
I don't know what I'm doing wrong. I've check the DOC but I can't seem to import a comma-delimited text file exported from Access into mySQL. I've created the database, table and fields. WHen I do a Import texfile everything looks OK via MySQL-Front. My text file contains only commas as delimit

Re: Thread Thrashing and 3.23.53a

2002-10-30 Thread heath boutwell
>Heath, I once had similar symptoms when my DNS resolving had problems >and all new connections "slept" for some seconds while they were >waiting for an response. My work-around was to use --skip-name-resolve >until the DNS problem was solved. Benjamin, Thanks for the suggestion but the connectio

Replication issue

2002-10-30 Thread Michael T. Babcock
I'm replicating over a local SSH tunnel to a remote machine ... both MySQL instances have been working fine in the past (and both have their own binary logs, and only one database is being replicated between the two). I'm getting this in the error logs: 021030 13:13:25 Slave: connected to mas

Re: Demo CD

2002-10-30 Thread Jan Steinman
>From: David Shields <[EMAIL PROTECTED]> > >As promised WAY too long ago, the techniques and tools to create an Apache / PHP / >MySQL Demo CD are now available... >Requires Spoon Installer (included in download), Apache / Mysql / PHP / Visual Basic >6 (blech). While I appreciate your doing this,

RE: Backup InnoDB

2002-10-30 Thread Scott Pippin
The info for mysqldump is at: http://www.mysql.com/doc/en/mysqldump.html We have a databse of about 300M it takes 2-3 minutes to do a complete mysqldump of the data. I would recommend, though, saving your larger tables to a separate file to make the import(if you ever need to do it) go faster. S

RE: Backup DB

2002-10-30 Thread Scott Pippin
There are two ways to do backups. 1. Backup the files themselves. 2. Use mysqldump to dump the data into a text file which can be read in by MySQL. http://www.mysql.com/doc/en/mysqldump.html We have a database of about 300M it takes 2-3 minutes to do a complete mysqldump of the data. I would rec

RE: Backup InnoDB

2002-10-30 Thread Kees Hoekzema
Hey, Use mysqldump. See the manual / cli help for how to do it :0 -kees > -Original Message- > From: Silmara [mailto:silmara.sami@;uol.com.br] > Sent: Wednesday, October 30, 2002 5:39 PM > To: [EMAIL PROTECTED] > Subject: Backup InnoDB > > > How can I do backup of only one DataBase? A

Re: Unable to set variable.

2002-10-30 Thread Peter Brawley
> I am typing the following at the command line to change the value of a > variable: > > mysqld --set-variable max_allowed_packet=1600 > > And get the following message: > 021030 17:08:34 Can't start server: Bind on TCP/IP port: Address > already in use > 021030 17:08:34 Do you already have a

Re: Innodb database corrupted

2002-10-30 Thread Pedro Rocadas
Mysql Greetings. I'm doing some tests using innodb for the first time and last night, during a storm, our energy system fall, the ups couldn't help. This happened when we have a substancial number of connections to the database. When the energy came back, we realised that the database was corrupt

Re: Re[2]: Start Transaction in InnoDB

2002-10-30 Thread Peter Brawley
Dyego, BEGIN, not set begin. My understanding is that BEGIN is a synonym for SET autocommit=0. PB - > AB>> I would like to know, how can I start a new transaction using InnoDB Tables? > > EE> Use BEGIN statement: > EE> http://www.mysql.com/doc/en/COMMIT.html > > EE> Don't forget to SET

Backup InnoDB

2002-10-30 Thread Silmara
How can I do backup of only one DataBase? And How can I do recovery the data? I'm working with MySQL ( InnoDB) and I have three DataBase in my TableSpace. But I would like doing backup of only one. regards, Sil - Before postin

Unable to set variable.

2002-10-30 Thread Renato Lopes
Hi! I am typing the following at the command line to change the value of a variable: mysqld --set-variable max_allowed_packet=1600 And get the following message: 021030 17:08:34 Can't start server: Bind on TCP/IP port: Address already in use 021030 17:08:34 Do you already have another my

Re: Funny results using Match Against

2002-10-30 Thread Mark Matthews
Jason White wrote: I used this statement to create a table annotation. create table annotation ( user_id int not null NOT NULL, oai_id varchar(255) NOT NULL, element varchar(255), value text, datestamp varchar(10), status enum("A", "I"), fulltext(value) ); I then ins

Binlog closed, cannot RESET MASTER

2002-10-30 Thread Rainer Fuegenstein
Hi, we are running mysql 3.23.36 on a redhat 7.1 (intel) server; mysql is installed as RPM. for some strange reason, the following error appeared in /var/log/msqld.log over the weekend: 021027 4:02:00 /usr/libexec/mysqld: Binlog closed, cannot RESET MASTER Status information: Current locks:

Funny results using Match Against

2002-10-30 Thread Jason White
I used this statement to create a table annotation. create table annotation ( user_id int not null NOT NULL, oai_id varchar(255) NOT NULL, element varchar(255), value text, datestamp varchar(10), status enum("A", "I"), fulltext(value) ); I then insterted so test data into the

Re[2]: Start Transaction in InnoDB

2002-10-30 Thread Dyego Souza do Carmo
Dobrý den, quarta-feira, 30 de outubro de 2002, 13:09:01, napsal jste: EE> Alexander, EE> Wednesday, October 30, 2002, 1:40:11 PM, you wrote: AB>> I would like to know, how can I start a new transaction using InnoDB Tables? EE> Use BEGIN statement: EE> http://www.mysql.com/doc/en/COMMIT.html

Re: Thread Thrashing and 3.23.53a

2002-10-30 Thread Jeremy Zawodny
On Wed, Oct 30, 2002 at 11:17:44AM +0100, Benjamin Pflugmann wrote: > Hi. > > Allow me to disagree. Although most often the symptoms you cite are a > sign that the operation is disk-bound, they are more a sign of > blocking per se, of which the most common cause is disk operation. In > the above c

Re: Unable to Start the Server

2002-10-30 Thread mails
Hi, run the safe_mysqld as mysql and not as root. Remove the directories " rm -rf /var/lib/mysql " and create it again as root and then "chown -R mysql.mysql /var/lib/mysql" then as mysql run "mysql_install_db" and again as mysql run "safe_mysqld" Bye. On Wed, 30 Oc

Re: Thread Thrashing and 3.23.53a

2002-10-30 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 30 October 2002 06:06, Jeremy Zawodny wrote: > On Wed, Oct 30, 2002 at 05:56:52AM +0100, Mark wrote: > > > > Is this all true? Bummer. :( I just upgraded to 3.23.53 (from > > .49). I cannot afford to get these huge load averages on my news

re: Unable to Start the Server

2002-10-30 Thread Victoria Reznichenko
Jason, Wednesday, October 30, 2002, 5:15:54 PM, you wrote: JT> For the life of me I can not get mySQL server to start. JT> Background: JT> System: Red Hat 8.0 JT> mySQL verion: whatever shipped with 8.0 JT> I think I have read the mysql.com documentation enough to determine either JT> a. I'm cl

Re: Unable to Start the Server

2002-10-30 Thread Mark Hennessy
Check the permissions on the files in /var/lib/mysql, they have to be readable and writable by the user that mysql runs as (usually mysql) if I recall correctly. -- Mark P. Hennessy [EMAIL PROTECTED] On Wed, 30 Oct 2002, Jason Thiesse wrote: > Date: W

Re: Thread Thrashing and 3.23.53a

2002-10-30 Thread heath boutwell
If you stick with 53a let us know what you see. Others that experienced problems upgrading from .49 reported positive results when trying the 53a binary. --- Mark <[EMAIL PROTECTED]> wrote: > Is this all true? Bummer. :( I just upgraded to 3.23.53 (from .49). I cannot > afford to get these huge

Re: Unable to Start the Server

2002-10-30 Thread Martin Hudec
Hello Jason, just pasting you something what appeared whiles ago... If you have Redhat, a GLIBC upgrade might have broken your MySQL installation. (Look in the mailing list archives). What happens when you telnet to port 3306 on your Linux database server from the machine Tomcat is running on?

Re: Re: Thread Thrashing and 3.23.53a

2002-10-30 Thread heath boutwell
> > MYTOP reports key eff at 98.30% > > +--+---+ > | Variable_name| Value | > +--+---+ > | Aborted_clients | 58| > | Aborted_connects | 6 | > | Bytes_received | 281234326 | >

Unable to Start the Server

2002-10-30 Thread Jason Thiesse
For the life of me I can not get mySQL server to start. Background: System: Red Hat 8.0 mySQL verion: whatever shipped with 8.0 I think I have read the mysql.com documentation enough to determine either a. I'm clueless b. I'm clueless or c. all of the above. I have ran mysql_install_db, appears

RE: ODBC problem

2002-10-30 Thread Fernando Grijalba
Make sure that Return matching rows is checked in your DSN Configuration. Also you can try a DSN-Less Connection like sql_connection.ConnectionString="Driver={MySQL};server=localhost;DB=DBName;U ID=;PWD=" For MySQL 3.51.04 you have to write Driver={MySQL 3.51.04} for it to work. HTH JFernando

re: Start Transaction in InnoDB

2002-10-30 Thread Egor Egorov
Alexander, Wednesday, October 30, 2002, 1:40:11 PM, you wrote: AB> I would like to know, how can I start a new transaction using InnoDB Tables? Use BEGIN statement: http://www.mysql.com/doc/en/COMMIT.html Don't forget to SET AUTOCOMMIT=0; -- For technical support contracts, goto https://

re: Updating a table column using other columns

2002-10-30 Thread Victoria Reznichenko
Etienne, Wednesday, October 30, 2002, 1:51:32 PM, you wrote: ED> I would like to know if MySQL allows some way to do ED> "UPDATE SomeTable SET SomeColumn=(SELECT SomeExpression FROM SomeTable, ED> SomeOtherTable WHERE SomeTable.ForeignKey=SomeOtherTable.PrimaryKey);" ED> Although I had some idea

RE: access2mysql data types

2002-10-30 Thread Fernando Grijalba
I use TINYINT. it stores 0 for false and 1 for true. I tried with enum, but the communication with MS Access was not happening. In Code you can treat this as a Boolean and in the UI if you have checkboxes the values of 1 or 0 also work. HTH. JFercan *** sql *** -Original Message- From

RE: i almost hate queires, please help!!!

2002-10-30 Thread James Northcott
> Here's what I did. Based on the same query (the one you > provided) as below > I executed the following: > > select mgrname, pjname from managers, projects, pocs > WHERE pjid = 'x' > AND pocs.pjid = projects.pjid > AND pocs.pmyid = 'x' > AND pocs.altid = 'x' > AND (pocs.pmyid = managers.pmyid

RE: ODBC problem

2002-10-30 Thread GAY Samuel
It's ADODB. Here is the "open" code : [...] Set sql_connection = New ADODB.Connection sql_connection.ConnectionTimeout = 10 sql_connection.CommandTimeout = 10 sql_connection.ConnectionString = "Data Source=MoniteurReseau" sql_connection.Open [...] In my ODBC data source "Monit

RE: Errors trying to connect to MYSQL using tomcat - do I need to open any ports on my firewall or is this done internally?

2002-10-30 Thread Kevin Passey
Hi again Mark, I have completed a re-install from the rpm files MySQL-3.23.53a-1.i386.rpm. and the client. I've added in the relevant records to grant myself priv to a database (marketing) that I have created. USE mysql; INSERT INTO host VALUES('localhost','marketing','Y','Y','Y','Y','Y','Y','Y',

MySQL for W2K

2002-10-30 Thread FlashGuy
Hi, I'm having a little trouble. I've installed mySQL. I've started the service via WinMySQL admin. I was able to create my databases. I also installed MySQL-Front and DBTools. The problem is when I startup any of the tools and try to create a connection I get a MySQL Error - COnnection failed

RE: ODBC problem

2002-10-30 Thread Fernando Grijalba
How are you connecting your app? DSN, ADO Connection String, DAO, etc... JFercan *** sql *** -Original Message- From: GAY Samuel [mailto:S.GAY@;envergure-conseil.com] Sent: October 30, 2002 04:47 To: Mail List MySQL (E-mail) Subject: ODBC problem Hi, To test MySQL I'm migrating a smal

Re: Errors trying to connect to MYSQL using tomcat - do I need to open any ports on my firewall or is this done internally?

2002-10-30 Thread Mark Matthews
Kevin Passey wrote: Hi Mark, Thanks for your response, my problem is that I've done that. It works on a windows machine running mysql, I've set my Linux machine up the same and it doesn't work. The only difference is that I am running MSQL 3.23.51-nt on my windows machine and the latest rpm's

RE: Errors trying to connect to MYSQL using tomcat - do I need to open any ports on my firewall or is this done internally?

2002-10-30 Thread Kevin Passey
Hi Mark, Thanks for your response, my problem is that I've done that. It works on a windows machine running mysql, I've set my Linux machine up the same and it doesn't work. The only difference is that I am running MSQL 3.23.51-nt on my windows machine and the latest rpm's on my Linux machine.

Re: Errors trying to connect to MYSQL using tomcat - do I need toope n any ports on my firewall or is this done internally?

2002-10-30 Thread Mark Matthews
Kevin Passey wrote: Hi all I have downloaded the latest rpms and added records to HOST,DB,and USER files in the mysql database. I am trying to access the database from a web page using a tomcat server running on the same machine. I get the following message : Server configuration denies access

Updating a table column using other columns

2002-10-30 Thread Etienne DUPUIS
Greetings, I would like to know if MySQL allows some way to do "UPDATE SomeTable SET SomeColumn=(SELECT SomeExpression FROM SomeTable, SomeOtherTable WHERE SomeTable.ForeignKey=SomeOtherTable.PrimaryKey);" Although I had some ideas (like sending SELECT result to a file, deleting table SomeTable

Re: Start Transaction in InnoDB

2002-10-30 Thread Dyego Souza do Carmo
Dobrý den, quarta-feira, 30 de outubro de 2002, 09:40:11, napsal jste: AB> Hi, AB> I would like to know, how can I start a new transaction using InnoDB Tables? AB> Alexander AB> mysql, query AB> ___ AB> Yahoo! Encontros AB> O

Start Transaction in InnoDB

2002-10-30 Thread Alexander Burbello
Hi, I would like to know, how can I start a new transaction using InnoDB Tables? Alexander mysql, query ___ Yahoo! Encontros O lugar certo para encontrar a sua alma gêmea. http://br.encontros.yahoo.com/ --

Demo CD

2002-10-30 Thread David Shields
As promised WAY too long ago, the techniques and tools to create an Apache / PHP / MySQL Demo CD are now available. I've made them available for download, with some documentation, on http://www.broadowlersystems.co.uk/democd - please feel free to download and play. Requires Spoon Installer (inc

Problem uploading file.

2002-10-30 Thread Renato Lopes
Hi! I am uploading files to a MySQL database. It all works fine for relatively small files. The biggest I was able to upload was 926K. However, when I try to upload a 1.3M file I get the following error message: "Unable to upload file. Error: MySQL server has gone away". My php.ini settings a

Errors trying to connect to MYSQL using tomcat - do I need to open any ports on my firewall or is this done internally?

2002-10-30 Thread Kevin Passey
Hi all I have downloaded the latest rpms and added records to HOST,DB,and USER files in the mysql database. I am trying to access the database from a web page using a tomcat server running on the same machine. I get the following message : Server configuration denies access to data source. Am I

Problem uploading 1.3M file to database.

2002-10-30 Thread Renato Lopes
Hi! I am uploading files to a MySQL database. It all works fine for relatively small files. The biggest I was able to upload was 926K. However, when I try to upload a 1.3M file I get the following error message: "Unable to upload file. Error: MySQL server has gone away". My php.ini settings a

Re: Thread Thrashing and 3.23.53a

2002-10-30 Thread Benjamin Pflugmann
Hi. On Tue 2002-10-29 at 16:01:00 -0800, [EMAIL PROTECTED] wrote: > On Tue, Oct 29, 2002 at 03:56:04PM -0800, heath boutwell wrote: [...] > > Load average of 1.5 seems high when we are only averaging 14 queries > > per sec (nothing else going crazy running on the box) > > > >procs

re: Lost connection to MySQL server during query

2002-10-30 Thread Egor Egorov
Frederic, Tuesday, October 29, 2002, 11:49:19 PM, you wrote: FT> What are the possible causes for this error message ? The possible source of error is the glibc provided by RedHat. Do you use RedHat? If so, check the mailing list archives, there were a lot of possible error descriptions during la

Disaster recovery from index

2002-10-30 Thread Audun Ytterdal
Hi. I've got a major filcorruptionissue on my hands. RAID, bad scsi-cables ,Reiserfs for Linux 2.2 and a corrupt backup. That's not a good combination. I've managed to salvage a few tables with isamchk, but the most important tables is missing it's .ISD file. The datafile. The only files I've g

ODBC problem

2002-10-30 Thread GAY Samuel
Hi, To test MySQL I'm migrating a small VB project wich already run with SQLServer2000 to try ODBC. I've a problem with two versions of MyODBC (2.50.39 and 3.51.04). I can connect, make some "select..." with succes, one update, and my VB program always crash on an update ! Here is the request,

Re: Create child table question

2002-10-30 Thread Heikki Tuuri
Jannie, - Original Message - From: "Jannie Qu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 10:18 AM Subject: Create child table question > sql, query, mysql > > Hi, all, > I met a problem with creating the following table: pub_user. > -- Parent table > CRE

Re: InnoDb referencing key bug?

2002-10-30 Thread Heikki Tuuri
Peter, InnoDB does not allow the index name to be specified in a foreign key constraint: " The syntax of a foreign key constraint definition in InnoDB: [CONSTRAINT symbol] FOREIGN KEY (index_col_name, ...) REFERENCES table_name (index_col_name, ...) [ON DELETE

Re: [newbie question] how do you change the default charset of MySQL under windows

2002-10-30 Thread Paul Yuen
Thanks Daniel, You've been extremely help already. Thanks a lot! I'll let you know if I finally manage to get it working. Thank you once again! Paul - Original Message - From: "Daniel Kiss" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 30, 2002 4:17 PM Subject: Re:

Re: [newbie question] how do you change the default charset of MySQLunder windows

2002-10-30 Thread Daniel Kiss
Hi Paul, Was the table01 created before you did the new settings and restart the service? Because if yes, youhave to recreate the table or rebuild the indexes. Anyway, I don't really know how chinese double-byte character representation works. Fortunately the Hungarian language uses the latin c

Re: [newbie question] how do you change the default charset of MySQL under windows

2002-10-30 Thread Paul Yuen
Hi Daniel, Actually I've tried the following in the "my.ini" file: [mysqld] default-character-set=big5 [WinMySQLAdmin] Server=C:/mysql/bin/mysqld-nt.exe but when I open up the command prompt and enters the mysql monitor, try the following I got into something like this: mysql> update table01 s