rlimit and rlimit64 problems when compiling with ICC 8.1

Hello, I was able to compile mysql 4.0 and 4.1 (static) successfully with intel compiler 8.0 on an IA32 system running redhat enterprise linux 3.0. However when I tried to compile with intel compiler 8.1 with the same options (same as ones used by mysql AB, except i link statically) I kept getting

Re: Sub queries

>> > There are obviously many possible variations of your query; I just > stated one that was pretty close to your original query. It's really > not clear to me yet what you were trying to do so I just wanted to show > you typical syntax. >> >> Ok sorry ppl I should have given a typical example i

Re: Problem with mysqldump

-- Original message -- From: Tom Crimmins <[EMAIL PROTECTED]> > > $ mysqldump -u root -p govern > test.sql > Enter password: > mysqldump: Got error: 1017: Can't find file: './govern/VT_SY_LANGUAGE.frm' > (errno: 24) when using LOCK TABLES > perror says 24 is too m

Re: Problem with mysqldump

perror 24 Error code 24: Too many open files Looks like you've hit a system limit. Michael Tom Crimmins wrote: In mysql version 4.1.7 running on Redhat 3ES I get the following error from mysql dump. $ mysqldump -u root -p govern > test.sql Enter password: mysqldump: Got error: 1017: Can't find f

Re: next autoindex

-- Original message from Richard Whitney <[EMAIL PROTECTED]>: -- > Hello! > > I have situation where I need to find the next autoindex of a table - not just > max(field) because the next autoindex may not jive with the number created by > max(field) http://dev.mysql.

Re: Sub queries

- Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 28, 2004 9:26 PM Subject: Re: Sub queries > > >> > > The keyword UNION should ensure that all duplicate rows are removed > > from the combined result set. If you use UNION ALL instead of UNION

Problem with mysqldump

In mysql version 4.1.7 running on Redhat 3ES I get the following error from mysql dump. $ mysqldump -u root -p govern > test.sql Enter password: mysqldump: Got error: 1017: Can't find file: './govern/VT_SY_LANGUAGE.frm' (errno: 24) when using LOCK TABLES This file does in fact exist and mysql h

next autoindex

Hello! I have situation where I need to find the next autoindex of a table - not just max(field) because the next autoindex may not jive with the number created by max(field) Any ideas? Am I making sense? Thanks! R. Whitney Transcend Development "Producing the next phase of your internet presenc

mysql online administration docs equivalent of the book?

Hello, I was wondering if people consider the on line docs at the mysql web site to be equivalent to their books regarding the database administration. Does the book go into more detail, or is all the contents of that book online? Thanks for the clarification, and pointers to good online mysql a

Odd build problem since 4.1.2

Hi all, I had no problem with compiling 4.1.2-alpha (or 4.0.x) and it has been working fine. But for both 4.1.5-gamma and 4.1.7, when I get to make test, all the tests fail. Normally, alias (the first one) fails and the whole thing stops, but using --force, they all fail. I get a log error abou

Re: Dumping Select statement output onto a text file

There are several ways to get output to a text file, from the Unix shell you can: > mysql -e "select * from table" database > output.txt or if you're looking for more of a log of what happened in the MySQL client, from the MySQL shell: > tee output.txt > select * from table; Mulley, Nikhil wrot

Re: Sub queries

>> > The keyword UNION should ensure that all duplicate rows are removed > from the combined result set. If you use UNION ALL instead of UNION, > the duplicates are left in the result set. > Yeh right, funny, early versions of 4.0, UNION had in the docs this was only avail in 4.1, i am so sure i

4.1 Crashing upon running mysqld_Safe

Hi all , I am trying to install the latest 4.17-standard Linux release on our server and and it gets caught in an endless loop of crashes. I have read the error logs , and followed the stack trace advice from the docs , but to be honest Im not sure how to interpret what it reports. Here is w

Re: run mysql service in Linux

Dear Gleb, [EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# chown -R root /var/lib/mysql [EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# chown -R mysql /var/lib/mysql [EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# chgrp -R root /var/lib/mysql [EMAIL PROTECTED] bin]# ls co

Re: A DB Design issue

Ok thanks a bunch, I'll take this information and see what I can come up with. Chris [EMAIL PROTECTED] wrote: Your system sounds more like BNF (Backus-Naur Form) expression evaluator than a regular expression evaluator. Both are similar in that you can specify sequences of things (letters or wo

why aren't my PRIMARY KEYs being used?

I've created two temporary tables: CREATE TEMPORARY TABLE `activenodes` ( `id` smallint(6) unsigned NOT NULL default '0', `name` varchar(50) NOT NULL default '', `rsrcc` bigint(21) NOT NULL default '0', PRIMARY KEY (`id`) ); CREATE TEMPORARY TABLE `activelayers` ( `id` int(10) unsigned

Re: Sub queries

electroteque wrote: Also I am trying to push for 4.1 to be installed on the servers i build web apps on. When will be a possible date to say that gamma which is practically production quality, to actually say production quality ? heheh. Our systems guy will only trust it if it says that, god on

Re: many-to-many query

Quoting Rhino <[EMAIL PROTECTED]>: > I wasn't sure if you understood the concept of association tables so forgive > me if I told you things you already knew; I didn't mean to be patronizing. No problem--you weren't patronizing at all, and I did tell you I was new at this! > With respect to you

Dumping Select statement output onto a text file

Hi List, How do I dump the data from console to the text file from the output generated by SELECT statement ? Thanks, Nikhil.

Re: Sub queries

- Original Message - From: "electroteque" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 28, 2004 6:33 PM Subject: Sub queries > Hi there, I have Mysql 4.1 on my development machine, I have been > trying to test out if I am going to be able to do this. What I would

Re: Upgrading MySQL erased all data

So, do you have a question or are you just bragging? ;-) Rhino - Original Message - From: "Steven Roussey" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 28, 2004 7:20 PM Subject: Upgrading MySQL erased all data > Installing MySQL 4.1.7 (upgrading from 4.1.3) on Ma

Upgrading MySQL erased all data

Installing MySQL 4.1.7 (upgrading from 4.1.3) on MacOS X erased the contents of /usr/local/mysql/data -- the privs and data of the previous installation. FYI Luckily (and unfortunately) we have a backup of that database from last week. (The guy that did it here in the office is still in a bit of

Re: column choices for certain data

See my remarks interspersed below. Rhino - Original Message - From: "Andy B" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 28, 2004 5:09 PM Subject: Re: column choices for certain data > Hi... > > Thanks for the info/help here. No problem; that's what the list is

Sub queries

Hi there, I have Mysql 4.1 on my development machine, I have been trying to test out if I am going to be able to do this. What I would like to do is return a one to many resultset but without the duplicated results in the first query. Hows is this going to be possible ? I would like to get all

Re: Live in Puget Sound?

Hey come n visit Dhaka + Learn( free) MySQL, have a holiday too.!!! Bill wrote: I am looking for someone that uses mysql and lives in the Puget Sound area. I am willing to pay someone for a little personalized help in getting started with the basics. I know very little about databases, but know I

Re: many-to-many query

- Original Message - From: "Emily Lena Jones" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 28, 2004 4:05 PM Subject: many-to-many query > Hi, I'm totally new at this so have no idea whether I'm asking for something > easy or quite difficult. > > I am working in My

Re: column choices for certain data

Hi... Thanks for the info/help here. I understand everything up to the part where it talks about referencing more than 1 table to each other and the foreign keys and all that stuff... basically I got lost. Not because you explained it wrong but because I haven't got the foggiest clue what keys/

Re: Innodb log file

Check out this section in the manual on innodb log files. http://dev.mysql.com/doc/mysql/en/Adding_and_removing.html -Eric On Thu, 28 Oct 2004 15:47:27 -0500, Oropeza Querejeta, Alejandro <[EMAIL PROTECTED]> wrote: > Hi, > > How can i increase the size of the log file and log buffer size? > >

Re: strange difference in creating views (mysql 5.0.1)

I suspect that you actually have two records in address_association that don't match up with a record in address. Yes, either a data mismatch or data duplication would be suspected in a case like this. Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Elim Qiu" <[EMAIL PROTEC

Fw: column choices for certain data

Oops, I meant to copy the list on this reply too. Rhino - Original Message - From: "Rhino" <[EMAIL PROTECTED]> To: "Andy B" <[EMAIL PROTECTED]> Sent: Thursday, October 28, 2004 4:00 PM Subject: Re: column choices for certain data > > - Original Message - > From: "Andy B" <[EMA

Re: A DB Design issue

Your system sounds more like BNF (Backus-Naur Form) expression evaluator than a regular expression evaluator. Both are similar in that you can specify sequences of things (letters or words or symbols) to appear in certain orders and in certain quantities. Once a BNF or regex expression is parse

many-to-many query

http://dev.mysql.com/doc/mysql/en/JOIN.html -Original Message- From: Emily Lena Jones [mailto:[EMAIL PROTECTED] Sent: Thursday, October 28, 2004 1:05 PM To: [EMAIL PROTECTED] Subject: many-to-many query Hi, I'm totally new at this so have no idea whether I'm asking for something easy or

Innodb log file

Hi, How can i increase the size of the log file and log buffer size? i tried to change it on my.cnf file but it return this error message: InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes InnoDB: than specified in the .cnf file 0 67108864 bytes! 041028 0:10:49 Can'

many-to-many query

Hi, I'm totally new at this so have no idea whether I'm asking for something easy or quite difficult. I am working in MySQL 3.23.58/PHP and am trying to construct a rather complex query. I have three tables: resources (containing resid, descr, title, url), topicdir (containing topicid, resid) and

RE: "go back machine"

I'd like to setup an application to store equipment configuration data in a MySql database. The basic setup is that each equipment has a certain number of parameters which may change over time. I'd like to track these changes over time and want to be able to create queries which determine the statu

Re: detailed summary of data, average, min, max

Something like SELECT uid, AVG(number_grade) AS average_grade, SUM(IF(letter_grade = 'A', 1, 0)) AS A_count, SUM(IF(letter_grade = 'B+', 1, 0)) AS B+_count, SUM(IF(letter_grade = 'B', 1, 0)) AS B_count, SUM(IF(letter_grade = 'B-', 1, 0)) AS B-_count,

Re: mysql 4.1.5 source

Aman Raheja wrote: Latest realease is 4.1.7 in 4.1.x but I am looking for 4.1.5 source download. Pointers will be helpful. Thanks Aman http://downloads.mysql.com/archives.php?p=mysql-4.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.

strange difference in creating views (mysql 5.0.1)

I'm trying to create a view from two tables address and address_association. So I did the following and expect they are the same: CREATE VIEW associated_address AS select t0.association_id AS association_id, t0.property_dict AS property_dict, t0.type_id AS type_id, t0.owner_id AS owner_id, t0.own

detailed summary of data, average, min, max

Hi, I have a table of grades like this: title, section, instructor, letter_grade, number_grade, uid With data that would look like this: English, 1, Smith, B, 88, 1 English, 1, Smith, B, 86, 1 English, 1, Smith, B+, 89, 1 Math, 1, Jones, A, 95, 2 Math, 1, Jones, B, 85, 2 Math, 2, Smith, C, 75, 3 Ma

RE: Mysqldump very slow

Hi Stefan, Sorry for not giving complete details it a very small database around 12 Gb data. But on my other servers which are low in configuration i am getting dump very fast for me it is taking nearly 5 Hrs to compleate dump Thanks Anil DBA -Original Message- From: Stefan Kuhn [mailto

Re: A DB Design issue

Heh, I don't think you're being dense. I can barely understand what I meant. I'll try to clarify I bit more. What I have is a sequence of entities (for this example the entities will be letters). I'm trying to use MySQL to hold the possible combinations of entities. The unique entities in a s

Re: Corrupted relay log

On 10/28/2004 8:07 AM, gerald_clark <[EMAIL PROTECTED]> wrote: > > > Paul Fierro wrote: > >> One of my slaves stopped running due to a corrupted relay log. The error >> file shows: >> >> Error writing file 'dbs2.log' (errno: 28) >> Error in Log_event::read_log_event(): 'read error', data_len:

mysqld no longer starts after update 4.0 -> 4.1

Hi! I searched near and far but could not find the slightest hint about what is causing my MySQL problems. I have a couple of servers running 3.23 and 4.0x just perfect but after updating one machine to 4.1, I can no longer start mysqld. Here is the error message: ==

Re: ulimit problem

Hi. Thank you! It looks like you've found a bug: http://bugs.mysql.com/bug.php?id=6309 Seems, you have myisamchk compiled without debug support. See: http://dev.mysql.com/doc/mysql/en/Compiling_for_debugging.html http://dev.mysql.com/doc/mysql/en/MyODBC_Unix_debugging_options.html

column choices for certain data

Hi... I have a db that I'm writing. It's for a business directory and one of the fields/columns in the table needs to have a list of business types in it (i.e. retail, auto, computer and so on). Since there may be more than one category that a business fits under I was wondering if "SET" is the

Error making mysql-4.1.5-gamma

I choosed to use mysql-4.1.5-gamma due to the UTF-8 support but failing to compile in on Solaris 8 (Sparc) Earlier I got problem with not finiding gCC and I created a symbolic link to the gcc in the /usr/local/bin and the compilation went on fine till I hit the error below. mkdir .libs gCC -O -

Re: Ho do I backup

On Thu, 28 Oct 2004 12:24:02 +0100, Barry Zimmerman <[EMAIL PROTECTED]> wrote: > > I have tried the following: > > mysqldump -u admin -p --databases yabbse > yabbsebackup.sql > > It seemed to work, but where can I find the yabbsebackup.sql file? Not very > experienced with backing up. Barry, T

Live in Puget Sound?

I am looking for someone that uses mysql and lives in the Puget Sound area. I am willing to pay someone for a little personalized help in getting started with the basics. I know very little about databases, but know I need to have the capability on my web site for many reasons. I would like this

Re: phpMyAdmin and MySQL 4.1

> i struggled w/ this for a while, before learning > that even though i had > mysql 4.1 installed, php4 was being compiled w/ it's > own built-in mysql > libraries, which are pre-4.1, hence the error. > compiling php5 will > solve the problem, as it's included mysql libraries > are apparently

Re: mysql docs

At 10:57 -0400 10/28/04, Victor Medina wrote: OKI! =) is there any place where i can get some info about them? The example engine is just a stub for developers to see how to get started writing a storage engine. If you use ENGINE=EXAMPLE, the table is created, but you can't actually store anything

Re: Ho do I backup

On Thursday 28 October 2004 08:22 am, Rhino wrote: > - Original Message - > From: "Barry Zimmerman" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, October 28, 2004 7:24 AM > Subject: Ho do I backup > > > Hi there, > > > > I am a novice with mysql on the terminal side using

logs

Hi!!! How can i specify the location of the log files in the my.cnf file? (general, error, and bin log) Best Regards Vic -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql docs

OKI! =) is there any place where i can get some info about them? On Thu, 2004-10-28 at 09:47, Paul DuBois wrote: > At 9:32 -0400 10/28/04, Victor Medina wrote: > >Hi all!!! > > > >in what part of the documentation can i find references to this > >configure options: > > > > --with-example-storage

Re: Mysqldump very slow

You won't get any reasonable answers like this. How big is your db? How long does mysqldump actually take? If you tell this, people can tell you if this is like expected or too slow. Good answers depend on good questions. But a hint: You can't expect mysqldump to run in fractions of seconds. Dep

Re: A DB Design issue

Maybe I am just being dense this morning but I am confused why you think that your nodes are different things depending on how many children they have (nodes, groups, entities, ahhh!)... If you have two sets of hierarchies that share the same nodes, you may want to build two trees rath

Re: Subqueries and JOIN

I believe this will work as you want: select h1.* FROM hist h1 LEFT JOIN hist h2 on h1.tel = h2.tel and h2.date_h < '20041027' where h1.date_h = '20041027' and h2.tel is null; This query should return all of the rows from the hist table where the tel value appears for the date yo

Re: mysql docs

At 9:32 -0400 10/28/04, Victor Medina wrote: Hi all!!! in what part of the documentation can i find references to this configure options: --with-example-storage-engine Enable the Example Storage Engine --with-archive-storage-engine Enable the A

mysql docs

Hi all!!! in what part of the documentation can i find references to this configure options: --with-example-storage-engine Enable the Example Storage Engine --with-archive-storage-engine Enable the Archive Storage Engine --with-csv-stor

Re: Ho do I backup

- Original Message - From: "Barry Zimmerman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 28, 2004 7:24 AM Subject: Ho do I backup > Hi there, > > I am a novice with mysql on the terminal side using shell. > > Basically I need to back up a database and have it sav

Re: Corrupted relay log

Paul Fierro wrote: One of my slaves stopped running due to a corrupted relay log. The error file shows: Error writing file 'dbs2.log' (errno: 28) Error in Log_event::read_log_event(): 'read error', data_len: 160, event_type: 2 $ perror 28 Error code 28: No space left on device You are out of

Error message

If I attempt to insert a record that has a duplicate key on a unique index, I get an error message of the form: ERROR 1062: Duplicate entry '1' for key 2 I'd like to get a little more information so as to provide the user with a meaningful message. Specifically: what index is "Key 2"? Is there

Re: ulimit problem

That failed with an err27 as well. How do I set the debug flag on myisamchk ? --debug=/tmp/debug doesn't work. JS. Hi. Sounds OK, but don't forget to make a backup. "J S" <[EMAIL PROTECTED]> wrote: > Thanks for your reply Gleb. I tried running with --safe-recover instead of > -qr but that cause

Re: query stopped working

After I ran some database updates last night, it seems to be working OK again today. Not sure what happened! Thanks anyway. JS. Hi. Uncommon situation. Please tell me, what OS do you use, MySQL version and how was it compiled? Is there any clues at the end of .err file? "J S" <[EMAIL PROTECTED]>

Re: phpMyAdmin and MySQL 4.1

On Oct 27, 2004, at 10.26, Schalk Neethling wrote: Greetings After installing the new release of MySQL ( i.e. MySQL 4.1), I know get the following error from phpMyAdmin when using any of the auth types: Error #1251 - Client does not support authentication protocol requested by server; consider

Mysqldump very slow

mysqldump running very slow. what might be the reason Server details === Dell RAM : 4 GB Innodb_buffer_pool_size : 1000MB i am using --quick option in mysqldump Thanks Anil DBA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http:

Re: Select with an IF statements

[snip] That's up to you of course. Personally, I think some things are better handled by the database and some are better handled by the programming language. Things like conditional logic tend to be best handled by the programming language in my view. Your mileage may vary ;-) [/snip] AT the risk

Re: bug or feature, <> 'blah' does NOT work with null records

From: "Harald Fuchs" <[EMAIL PROTECTED]> > In article <[EMAIL PROTECTED]>, > "Jigal van Hemert" <[EMAIL PROTECTED]> writes: > > > Fortunately there is function COALESCE() that will return the first argument > > that is not NULL. In case of NULL values you can use a default value for an > > expres

Re: bug or feature, <> 'blah' does NOT work with null records

In article <[EMAIL PROTECTED]>, "Jigal van Hemert" <[EMAIL PROTECTED]> writes: > NULL is meant to indicate that the value is unknown. If a value is unknown > it can be anything. > So, in the example `col` <> 'blah', col can be anything, including 'blah'. > If you take that into consideration the o

Ho do I backup

Hi there, I am a novice with mysql on the terminal side using shell. Basically I need to back up a database and have it saved locally from my server. I have tried using phpmyadmin but it fails as I think the data is too large. I have tried the following: mysqldump -u admin -p --databases yabbse

Mysql Sysem files and packages

Hi, I am doing a dbconversion form oracle to mysql. I would like to know the equivivalents in mysql for 1) Parameter file like init.ora in oracle 2) system package like diutil in oracle Thanks, Narasimha Confidentiality Notice The information contained in this electronic message and a

Re: query stopped working

Hi. Uncommon situation. Please tell me, what OS do you use, MySQL version and how was it compiled? Is there any clues at the end of .err file? "J S" <[EMAIL PROTECTED]> wrote: > Hi, > > I have this query which used to work really fast but now it just seems to > lock up the tab

Re: Should I change the MySQL client library

Of course, it is good to upgrade to much more stable version. Karam Chand <[EMAIL PROTECTED]> wrote: > Hello, > > MySQL has released 4.1.7 > > http://lists.mysql.com/announce/226 > > As you can see there have been some bugfixes in > libmysqlclient. I am using libmysql.dll provided

Re: run mysql service in Linux

Hi. Look at permissions on /var/lib/mysql (ls -l /var/lib/mysql). And, btw, it's not /var/liv, but /var/lib. MySQL should have ability to read this directory. See INSTALL-BINARY in the distribution directory and follow instructions in it exactly. Don't forget about mysql_install_db!

Re: INSERT... SET - SQL standard?

Frederic Wenzel wrote: Is the INSERT ... SET syntax (http://dev.mysql.com/doc/mysql/en/INSERT.html) MySQL specific or does it belong to a SQL (89, 92...?) standard? http://dev.mysql.com/doc/mysql/en/Extensions_to_ANSI.html In general usefull: http://developer.mimer.com/validator/index.htm Friedhelm

Re: bug or feature, <> 'blah' does NOT work with null records

From: "Harald Fuchs" <[EMAIL PROTECTED]> > Yes, of course. "NULL <> 'blah'" returns NULL, and that's perfectly > standards-conformant. Furthermore, it's quite logical. NULL is meant to indicate that the value is unknown. If a value is unknown it can be anything. So, in the example `col` <> 'bla

INSERT... SET - SQL standard?

Is the INSERT ... SET syntax (http://dev.mysql.com/doc/mysql/en/INSERT.html) MySQL specific or does it belong to a SQL (89, 92...?) standard? Thanks in advance Fred -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROT

Re: bug or feature, <> 'blah' does NOT work with null records

In article <[EMAIL PROTECTED]>, matt_lists <[EMAIL PROTECTED]> writes: > I cant tell if this is a bug or a feature. > Select from table where col <> 'blah' > I use this all the time with other databases, works great, gives me > everything that's not "blah" If those "other databases" return also