AntiVir ALERT [your mail: ]

* * * * * * * * * * * * * * * AntiVir ALERT * * * * * * * * * * * * * * * AntiVir has detected the following in a mail from your address: Worm/MyDoom.AE The mail was not delivered. Please remove any potential malicious software from your computer before sending a new mail with

Re: Problems With 4.0 - 4.1 Upgrade on FreeBSD 4.10

Hello. To which version have you upgraded exactly? have you installed from ports or a binary version or compiled from source? What configure options have you specified? You may use some recomendations from: http://dev.mysql.com/doc/mysql/en/Crashing.html First, enable logging to

Re: modifying prepared statement parameters

Hello. You may use something like: prepare stmtl from 'select * from ren1 where yo like concat(%,?,%)'; set @a='1'; execute stmtl using @a; Nathan Coast [EMAIL PROTECTED] wrote: Hi, Is it possible to modify parameters passed to prepared statements? e.g. select

Direct connection to mysql database

Hi, all I would like to know is there anyway where i can connect to the mysql database without add the odbc dsn ? which i want to direct access to the mysql database. i wish to create 1 dsn, and by using this dsn, i able to access all database, even able to create/delete the mysql

4.0.18 - 4.1.7 LEFT JOIN problem

I moved a db from 4.0.18 to 4.1.7 and I realise that the SAME sql query using LEFT JOIN gives me different result. The result from 4.0.18 does s real LEFT JOIN but 4.1.7 differs sometimes and I don't want that. I think it comes from an 'optimization' how can I make a query without using

ERROR 1216: Cannot add or update a child row: a foreign key constraint fails

Hello list, I am getting the following error when i am loading data (Tab seperated data) into a table which has reference to a primary key table. There is data in the primary key table, but still this error is being thrown. ERROR 1216: Cannot add or update a child row: a foreign key constraint

Re: ERROR 1216: Cannot add or update a child row: a foreign key constraint fails

On Monday 22 November 2004 13:10, Dayakar might have typed: Hello list, I am getting the following error when i am loading data (Tab seperated data) into a table which has reference to a primary key table. There is data in the primary key table, but still this error is being thrown. ERROR

Starting mysql as a service once installed

Hello, I have installed mysql but did not install it as a service. All I do is runmysqld-max-nt.exe Now I need it to run as a service. It is on a win2003 machine. Can I make it run as a service once I already have it installed. I cannot lose data and do not want to do a mysqldump, uninstall

Messed up on auto inc

While what I'm working on is only a test database, I'd like to see what I can preserve. I used a data dumping program to create records in my database. However I'm not sure how I messed up , but here is the problem. I have 1016 records in a particular table. The first column is a Primary ID Int

Re: Ok now connector/J doesn't work.

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 William R. Mussatto wrote: [snip] Tried it and now I get connection timed out after three tries. I'm running the testbed using the tomcat buried in netbeans. Cut and pasted the example from the on line docs. Put the jar in the WEB-INF/lib

table field order

I am moving a table from a 3.23.56 db to a 4.1.7 db.  I currently only testing to see if I can.  So far, I have been able to create the receiving table, but not be able to insert the data.  (The only difference I see when using phpMyAdmin is the collation column on the 4.1.7 server) ... I

Re: Starting mysql as a service once installed

On 22 Nov 2004 at 9:34, James Sherwood wrote: Hello, I have installed mysql but did not install it as a service. All I do is runmysqld-max-nt.exe Now I need it to run as a service. It is on a win2003 machine. Can I make it run as a service once I already have it installed. I

Re: 4.0.18 - 4.1.7 LEFT JOIN problem

Hi! On Nov 22, Dilipan Sebastiampillai wrote: I moved a db from 4.0.18 to 4.1.7 and I realise that the SAME sql query using LEFT JOIN gives me different result. The result from 4.0.18 does s real LEFT JOIN but 4.1.7 differs sometimes and I don't want that. I think it comes from an

Re: [PHP-DB] Upgrading mySQL

Hi GH, apart of the contents of the mentioned documents and hints, there is nothing else. Just start the new server in place of the old server with the same options unless told otherwise in the mentioned documents. Am Mo, den 15.11.2004 schrieb GH um 15:06: when I go to both 2.10 Upgrading

Remote user problem

Hi all, I have am in trouble with connecting remotely to my MySQL Server Linux machine. I have installed the latest RPM (4.1.7) on a Linux Fedora Core 3 machine. I have created root account and everything seems to be OK. The only problem is that I can not connect to my MySQL Server remotely

Re: counting sequences

[EMAIL PROTECTED] wrote: Hi! I need to use SQL to count some sequences. We have taken a short snapshot of 1 year for people registered in programs. So we have data in a table like so: ID m1 m2 m3 m4 m5 m6 m7m8 m9 m10 m11 m12 The m1, m2, m3 refers to month 1, month2, month3, etc. The data for 1

Space in SELECT INTO OUTFILE

Please, MySQL doesn´t understands the following special escape sequence: ' \s' ? I want spaces in the export. How to do? Greetings. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Poor performance for SELECT from 50.000 records - MySQL PERFORMANCE TEST

Hello, I have a problem with poor performance when I execute select from 50.000 records. I have a test that retrieve page by page (20 records per page) all data from a table. It means I'm executing 2500 selects in the cycle for retrieving each page and I'm retrieving also time duration of some

Re: Ok now connector/J doesn't work.

William R. Mussatto said: Mark Matthews said: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 William R. Mussatto wrote: Keith Ivey said: William R. Mussatto wrote: I've been googling for 1/2 hr w/o any answers. sorry if I've missed the obvious. Problem. Fresh install of mysql 4.7.1, AS

100+ databases, too many open files - am I out of line?

Hi. I have database structure of about 45 tables, and a separate database for each of the 100+ users. Everything has been working nicely for quite some time. When I wrote a function that looped through all the DBs and ran some queries, MySQL hung and I got too many open files in my .err-file.

Re: Direct connection to mysql database

Hello. For direct connection you may use MySQL APIs. See: http://dev.mysql.com/doc/mysql/en/MySQL_APIs.html Probably this link also will be helpful: http://dev.mysql.com/doc/mysql/en/Without_DSN.html Hi, all I would like to know is there anyway where i can connect to the mysql

Re: Poor performance for SELECT from 50.000 records - MySQL PERFORMANCE TEST

First you are using two distinct queries where you should be using two related. Specifically, add SQL_CALC_FOUND_ROWS to your first query that retrieves data, then issue a query to see how many rows you would have had if you hadn't specified a LIMIT: SELECT FOUND_ROWS() The second query

Re: 100+ databases, too many open files - am I out of line?

Everything has a limit. Sometimes it's just ridiculously high that it might as well be infinity. This is not the case with open files. I'm not sure if MySQL has it's own limit or if it is constrained by the operating system, like it is with file size. Max open files is a function of the OS,

Can't see table information

Hi Folks, I've been running a website on php/mysql database for about a year now. I typically enter data using the phpmyadmin package. The other day I attempted to add some data but it appeared to phpmyadmin that there were no tables in my database. I connected to mysql using the commandline

Innodb corrpution. Very Urgent

Hello, i´m having a problem with a large database... at ibdata1.My ibdata1 is corrupted and i saw other postings and all of them asks to use mysqldump, but in my case there´s a problem... I can´t run mysqld since ibdata1 is corrupted. Those anyone have a tip for me? in logfile says that mysqld

Headers for queries with empty return sets

Hello, I am a new user of MySQL and have a simple question I was hoping the list could help me with. I have been a long time Sybase user and am now looking at converting some of my scripts to MySQL. I ordinarily run scripts as batch from the command line, and parse the results in a

Re: Headers for queries with empty return sets

Eric Yeh wrote: Hello, I am a new user of MySQL and have a simple question I was hoping the list could help me with. I have been a long time Sybase user and am now looking at converting some of my scripts to MySQL. I ordinarily run scripts as batch from the command line, and parse the results

Re: [PHP-DB] Upgrading mySQL

What I have been asking for... is that the upgrade does not tell me *HOW* to install this upgrade. WHich file I should download etc I do not see this under the UPGRADE section... That is what I have been asking Also, it says on the manual (section 2.10) It is a good idea to rebuild and

Re: Innodb corrpution. Very Urgent

Carlos, - Original Message - From: Carlos Augusto [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Monday, November 22, 2004 10:37 PM Subject: Innodb corrpution. Very Urgent Hello, i=B4m having a problem with a large database... at ibdata1.My ibdata1 is corrupted and i saw

Subqueries X Joins

Hello, I wondering about Subqueries X Joins. What is the fastest technic? I´ve read the Manuals and I found some texts saying Joins are faster and other saying Subqueries are faster. Well, if both so. When Subqueries are faster and when Joins are faster? If this question has been answered

Re: 4.0.18 - 4.1.7 LEFT JOIN problem

At 15:23 +0100 22-11-2004, Sergei Golubchik wrote: Hi! On Nov 22, Dilipan Sebastiampillai wrote: I moved a db from 4.0.18 to 4.1.7 and I realise that the SAME sql query using LEFT JOIN gives me different result. The result from 4.0.18 does s real LEFT JOIN but 4.1.7 differs sometimes and I

Re: 4.0.18 - 4.1.7 LEFT JOIN problem

On Monday 22 November 2004 04:15 pm, Santino wrote: I can confirm it anyway: I think we have a bug.. Unless someone else see something, might want to take this to bugs.mysql.com Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 578 to server version:

Problems with Dump from Linux to Windows

Hello Group, I'm desperatly trying to set up a mysql test-environment on my Windows XP Sp1 system. Therefore I dumped out the database on a RedHat Linux Server (both are MySQL 3.23.56) and imported this dump into the same MySQL DB on the windows System (using mysqldump -u root -p --opt

Re: [PHP-DB] Upgrading mySQL

Warning!! Make sure the php module will handle the new password scheme in 4.1. DBD::mysql from AS will not. There are work arounds. I'm having to fall back to 4.0 because I can't get .jsp to work with 4.1 database (no connection). GH said: What I have been asking for... is that the upgrade

archived versions of MySQL

I need to snag a copy of MySQL 4.0.20 for Windows. Is there somewhere on the MySQL I can grab older versions? Thanks, T __ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.com -- MySQL General Mailing List For

Re: Ok now connector/J doesn't work.

William R. Mussatto wrote: Tried it and now I get connection timed out after three tries. I'm running the testbed using the tomcat buried in netbeans. Frankly, the whole concept of running a server from within an IDE sounds so sketchy to me -- but I'm definitely not an IDE kinda guy :-) Have

Re: archived versions of MySQL

On Mon, Nov 22, 2004 at 03:49:52PM -0800, Emmett Bishop wrote: I need to snag a copy of MySQL 4.0.20 for Windows. Is there somewhere on the MySQL I can grab older versions? http://downloads.mysql.com/ -- Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives:

Re: MySQL Books

Sasha, Plugs from authors are interesting, but plugs from readers are what really sell a book. I will check it out though. Thank you for the response. Jonathan Sasha Pachev [EMAIL PROTECTED] 11/19/04 5:36 pm Jonathan Duncan wrote: I have the MySQL first edition book by Paul. Still a

Lock wait timeout exceeded Errors

I believe I have read or skimmed all of the posts to this group with Lock, wait and timeout in their body over the past year (172) with no answers in sight (if I missed a post, please let me know). I am unable to figure out what is causing this problem that is 100% reproducible on a

Re: Ok now connector/J doesn't work.

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 William R. Mussatto wrote: Tried it and now I get connection timed out after three tries. I'm running the testbed using the tomcat buried in netbeans. Cut and pasted the example from the on line docs. Put the jar in the WEB-INF/lib dirctory.

Re: Direct connection to mysql database

Yup, Thanks a lot. This is exactly the solution what i want. Thank you very much. :) - Original Message - From: Kardos Andrs [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 23, 2004 5:20 AM Subject: Re: Direct connection to mysql database You can use one DSN, and then

Re: Ok now connector/J doesn't work.

Hassan Schroeder said: William R. Mussatto wrote: Tried it and now I get connection timed out after three tries. I'm running the testbed using the tomcat buried in netbeans. Frankly, the whole concept of running a server from within an IDE sounds so sketchy to me -- but I'm definitely not

Re: Ok now connector/J doesn't work.

Mark Matthews said: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 William R. Mussatto wrote: Tried it and now I get connection timed out after three tries. I'm running the testbed using the tomcat buried in netbeans. Cut and pasted the example from the on line docs. Put the jar in the

handshake problem with resin

hello,everyone Communication failure during handshake. Is there a server running on localhost:3306? is what mean,how to solove this problem?? thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How do you do the math

I see guys talk about doing the math to determine how many apache servers you need. How much ram you have or have left. My question is how do you determine how much your MySql can handle? I am running a dell dual 2.8 with 2 gig of ram Raid 5 Whats the max connections MySql can handle?

On but off topic Putting a file in Ram

I have a small file that calls a search function at Findwhat in case Mysql locally overloads. I just put on a new partner who looks like they may call my server 40 million times a month. I know there is some way to put a file into Ram for super fast response. Question is how do I do this? Will

Re: Problems with Dump from Linux to Windows

UPDATE: Here's what i could figure out till now A look with a hex editor showed me that there was a change from 0B to 0A and 07 to 20 in the corrupted files compared with the original ones. Somebody had the same problem -- MySQL General Mailing List For list archives:

Thread concurrency

Just out of curiosity I recently turned this up from a 4 to a 16 to see what would choke. Nothing did. Matter of fact it seems like my load went down quite a bit. Is there something wrong with leaving it this way? Since it should be really simple tasks on Xeon processors shouldn't it be

Re: Ok now connector/J doesn't work.

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 William R. Mussatto wrote: Mark Matthews said: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 William R. Mussatto wrote: Tried it and now I get connection timed out after three tries. I'm running the testbed using the tomcat buried in netbeans.

Re: MySQL Books

This is my favorite advanced MySQL book. It's by Jeremy Zawodny (looks after MySQL installations for Yahoo.com) (fix the link if it wordwraps in this email): http://www.amazon.com:80/exec/obidos/ASIN/0596003064/kieranwebobje-20? creative=327641camp=14573link_code=as1 -Kieran

Upgrade?

I'm using 4.15 currently, and it seems to be very stable. I noticed that a v4.17 or something has come out recently. Is it worth upgrading? Can I just install the new version without damaging my current databases or are there specified steps? Where would I find them if there are? Thanks,

Re: Upgrade?

At 20:09 -0700 11/22/04, Steve Grosz wrote: I'm using 4.15 currently, and it seems to be very stable. I noticed that a v4.17 or something has come out recently. Versions 4.15 and 4.17 of what? You're asking us whether it's worth upgrading without specifying what it is you're asking about? Do

Re: Upgrade?

I'm referring to the MySql server v.4.1.5 that I'm using now, as compared to the newer release of v.4.1.7 Paul DuBois wrote: At 20:09 -0700 11/22/04, Steve Grosz wrote: I'm using 4.15 currently, and it seems to be very stable. I noticed that a v4.17 or something has come out recently.

Re: very slow concurrent queries on HEAP table

At 06:10 PM 11/21/2004, you wrote: Hi all, I've got a rather odd performance problem with concurrent queries here. My query regrettably always needs to do a full table scan - really can't be helped. So my idea was to cache the data in a HEAP table to get maximum performance out of it and it

making a pattern table

Hi! I am wondering if there is a way using SQL to make a pattern file (I'm not sure exactly what to call it) of the sort following, which keeps track of people in programs of different kinds, by months of the year. A given file can be set up as below examining only 1 type of program (that is

Re: InnoDB data files keep growing with innodb_file_per_table

Heikki, I recreated the tablespace more than a week ago, set datafile size to 10M:autoextend and its size hasn't changed since the first data import, so the problem was indeed caused by corrupted datafile. It's great that you added more debug logging, because the weirdest thing about the problem

Still problems with blocking sockets with c-api

I noticed that all mysql client programs i have (cmd line tool mysql and own applications) block when the connection to a server is physically cut. 1. make connection 2. do some querys 3. line cut 4. mysql_ping() or mysql_query() block the application forever a strace from mysql cli-tool shows