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

LOAD INDEX INTO CACHE doesn't!

Hi :)  I'm having trouble using "LOAD INDEX INTO CACHE".  It isn't loading any index blocks! I am using 4.1.7-standard, for pc-linux on i686 on a redhat box. mysqladmin debug reports this, before a LOAD INDEX:   Key caches:   default   Buffer_size:    2147483648   Block_size:   1024   Di

Should I change the MySQL client library

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 with 4.1.1 in my app. Do I need to upgrade it to the one provided with 4.1.7? Regards, Karam _

Re: LOAD DATA LOCAL INFILE

Richard Whitney wrote: Hi! Can someone point me in the right direction? I have this that works in v.4x: $sql = "LOAD DATA LOCAL INFILE '$file' REPLACE INTO TABLE `members` FIELDS TERMINATED BY '\\t' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '' LINES TERMINATED BY '\\r\\n'"; When I try it using 3.2

run mysql service in Linux

dear All Master of Mysql, I'm new in Mysql, and I'd just move to mysql Linux version..!and i have problem to activate the service. I have installed Mysql linux ver. with this Command >tar-zxvf mysql-standard-4.0.21-pc-linux-i686.tar when i try to Configure >./configure ,there is a note that i

A DB Design issue

Hi all, I'm designing a small database, it's essentially a tree-structure. I'm probably going to use a Modified Preorder Tree Traversal (On a side note, how is it different than an Unmodified Preorder Tree Traversal?). Each node will have children etc, and those will have children, etc. But I

RE: LOAD DATA LOCAL INFILE

Hi Richard, Try looking at mysqlimport instead. I'm only taking a punt that it works with that version but the manual doesn't say anything about it being since a certain version. It works as at 3.23.58 so hopefully it may do for .55 Regards David Logan Database Administrator HP Managed Service

RE: Determining if query will work

Well that wasn't a very nice thing to say. On Mon, 2004-10-25 at 11:56, none none wrote: > Like so many other people.. > > No one puts any collective thought into what they are doing.. > > Instead of moving on and trying to finish the rest yourself, you rely > on someone else to finish it for yo

LOAD DATA LOCAL INFILE

Hi! Can someone point me in the right direction? I have this that works in v.4x: $sql = "LOAD DATA LOCAL INFILE '$file' REPLACE INTO TABLE `members` FIELDS TERMINATED BY '\\t' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '' LINES TERMINATED BY '\\r\\n'"; When I try it using 3.23.55 I get the foll

RE: Determining if query will work

Like so many other people.. No one puts any collective thought into what they are doing.. Instead of moving on and trying to finish the rest yourself, you rely on someone else to finish it for you. -Original Message- From: Eve Atley [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 20

Subqueries and JOIN

Can I execute this query in a single JOIN statement? select * from hist where date_h = '20041027' and tel not in (select distinct tel from hist where date_h < '20041027') I know I could do it using a temporary table, but I wonder if there's a way to do it direc

Re: Select with an IF statements

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 ;-) After all, just because so

Perfomance: UNION vs. # of SELECT

Hello Listpeople, I need to output headline and link information from an 'articles' table. Each article belongs to one and only one 'section'. I will probably need a different number of articles from each section. I'm wondering about performance, in very general terms, of a few different strategie

Re: Best way to access field name in C

Hey have you checked thi shttp://www.geocities.com/jahan.geo/mysql_c_by_example.html? Matthew Boehm wrote: What is the best way to access a specific field in C? Its really easy in PHP... PHP --- $res = mysql_real_query($mysql,"SELECT col1, col2 FROM table"); while($row = mysql_fetch_row($res)

query stopped working

Hi, I have this query which used to work really fast but now it just seems to lock up the tables. I tried running it with EXPLAIN but it just hangs at the command prompt. I also tried adding the USE INDEX directives but still no luck. I've run myisamchk -m on both tables involved and no errors w

Re: Select with an IF statements

Hi Rhino, I don't think that answer solves the problem. I do use a programming language, and doing a query like this means I can make use of the database engine and not add overhead to my application. Cheers, Luke Venediger. On Wed, 27 Oct 2004 17:26:56 -0400, Rhino <[EMAIL PROTECTED]> wrote: >

Re: Select with an IF statements

Thanks Paul! Luke Venediger. On Wed, 27 Oct 2004 16:17:51 -0500, Paul DuBois <[EMAIL PROTECTED]> wrote: > At 22:58 +0200 10/27/04, Luke Venediger wrote: > >Hi, > > > >I'm trying to do the following: > > > >SELECT > > IF((ProductStatus IS NOT NULL), "Available", "Not Available") as > >ProductSt

Re: mysql 4.1.5 source

Hi. Look at http://downloads.mysql.com/archives.php?p=mysql-4.1&v=4.1.5 >Aman Raheja <[EMAIL PROTECTED]> 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 > -- For technical support contracts,

Re: mysqldump error

Hi. See http://dev.mysql.com/doc/mysql/en/LOAD_DATA_LOCAL.html and upgrade to the latest stable release. Michael Ragsdale <[EMAIL PROTECTED]> wrote: > Running MySQL 4.0.12-NT on a Windows 2k Pro Server. > > When I attempt to execute mysqldump.exe, I get the following error: > > mys

Re: mysql 3.23 store large data

Hi. Use LONGBLOB. Jerry Swanson <[EMAIL PROTECTED]> wrote: > What type I should use in MySQL 3.23.58 to store large data file? > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __

Re: Select with an IF statements

- Original Message - From: "Luke Venediger" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 27, 2004 4:58 PM Subject: Select with an IF statements > Hi, > > I'm trying to do the following: > > SELECT > IF((ProductStatus IS NOT NULL), "Available", "Not Available")

Corrupted relay log

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 Error reading relay log event: slave SQL thread aborted because of I/O error Slave: Could

Re: Select with an IF statements

At 22:58 +0200 10/27/04, Luke Venediger wrote: Hi, I'm trying to do the following: SELECT IF((ProductStatus IS NOT NULL), "Available", "Not Available") as ProductStatus FROM tb_Product WHERE ProductName = "MyProduct"; It works fine if the ProductName "MyProduct" works, and returns "Availabl

Select with an IF statements

Hi, I'm trying to do the following: SELECT IF((ProductStatus IS NOT NULL), "Available", "Not Available") as ProductStatus FROM tb_Product WHERE ProductName = "MyProduct"; It works fine if the ProductName "MyProduct" works, and returns "Available". However, if the product name doesn't work

Re: mysqldump error

At 15:47 -0400 10/27/04, Michael Ragsdale wrote: Running MySQL 4.0.12-NT on a Windows 2k Pro Server. When I attempt to execute mysqldump.exe, I get the following error: mysqldump: ERROR: unknown variable 'local-infile=1' I tried using --force and it didn't help. Showing the variables, I get local-i

RE: what is wrong woth this statement?

Thanks for all of the advice everybody. I'm actually a lot more comfortable with perl than ANT so I think I'll use that. ANT does seem pretty cool though, I'll need to buckle down and learn it at some point. -Original Message- From: Rhino [mailto:[EMAIL PROTECTED] Sent: Wednesday, Octob

Re: what is wrong woth this statement?

Have you considered doing what you want to do in Ant? I haven't done exactly what you want to do but Ant supports properties and conditions. I could imagine an Ant task that determines if the desired record exists, then another task that does an insert is executed only if the record doesn't exist.

RE: what is wrong woth this statement?

You are right about your PRIMARY KEY and UNIQUE keys being able to protect most of your data. MySQL has an optional switch for INSERT, UPDATE, and ALTER TABLE statements just for some of the situations you described. It's "IGNORE" and I can vouch that it works well. http://dev.mysql.com/doc/mys

RE: what is wrong woth this statement?

Thanks Shawn. Basically, our deployment mechanism involves applying sql change scripts as part of the build process. I created this simple shell script: host="$1" user="$2" pwd="$3" mysql -u$user -p$pwd -h$host -f sinu_com <<_EOF_ #Put the scripts to execute here: \. z_worklog_alt

Re: mysql 4.1.5 source

Thanks a ton ! Aman Raheja Nate Blanchard wrote: http://downloads.mysql.com/archives.php -Original Message- From: Aman Raheja [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 3:47 PM To: mysql Subject: mysql 4.1.5 source Latest realease is 4.1.7 in 4.1.x but I am looking for 4.

mysqldump error

Running MySQL 4.0.12-NT on a Windows 2k Pro Server. When I attempt to execute mysqldump.exe, I get the following error: mysqldump: ERROR: unknown variable 'local-infile=1' I tried using --force and it didn't help. Showing the variables, I get local-infile to be TRUE. I looked in my.ini and found

Re: what is wrong woth this statement?

Josh, You cannot do this in mysql, as there is no such construct. Perhaps you've been misled by the title of section 13.2, "Control Flow Functions" . Despite the name, mysql has no control flow functions. What it has are functions

mysql 4.1.5 source

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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: deadlock caused by odbc and transaction handling

Robert, - Original Message - From: ""Bagyinszki Róbert"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Tuesday, October 26, 2004 12:46 PM Subject: deadlock caused by odbc and transaction handling --_=_NextPart_001_01C4BB40.B000D6DB Content-Type: text/plain; charset="i

RE: what is wrong woth this statement?

Nearly all of the T-SQL style procedural statements (IF... BEGIN... END, WHILE...WEND, cursors, etc.) are not currently available in MySQL. Procedural scripts , like the one you propose, will be available in Stored Procedures (new to MySQL 5.0+). I haven't tested that version yet, so I can't

RE: what is wrong woth this statement?

Thanks, but I tried that and it doesn't seem to work any better than an "if" statement. Have you tried it? Maybe I am doing something wrong. If you could post some working code that would be awesome. -Original Message- From: sol beach [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27

RE: what is wrong woth this statement?

Sorry, I don't think I was very clear. I'm asking a more generic question about control flow expressions. I want to run a sql statement but only if a certain condition is met, namely if a particular record exists in a table. I want to do it all in a single mysql statement, like so: If ([record exi

Re: Replication Issue

Randy Johnson wrote: Here is the url sorry: http://dev.mysql.com/doc/mysql/en/Replication_Compatibility.html Does this table say that mysql 3.23.33 and up is not compatible to replicate to a mysql 5.0 slave? Yes Friedhelm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Re: Simple SQL Question

Good one. I don't know how I missed this either! Thanks! "gerald_clark" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > What about > select distinct a.region, a.city > from mytable a , mytable b > where a.region=b.region and a.city <> b.city > > Jay Blanchard wrote: > > >[snip] >

Re: Simple SQL Question

[snip] What about select distinct a.region, a.city from mytable a , mytable b where a.region=b.region and a.city <> b.city [/snip] Crud! Standing too close to the forest and forgot about a self join... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Simple SQL Question

What about select distinct a.region, a.city from mytable a , mytable b where a.region=b.region and a.city <> b.city Jay Blanchard wrote: [snip] Anybody? I have a simple problem and I'm just wondering the BEST query to solve it. I want to return all the rows of a table whose foreign key

RE: Replication Issue

Here is the url sorry: http://dev.mysql.com/doc/mysql/en/Replication_Compatibility.html -Original Message- From: Randy Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 2:07 PM To: [EMAIL PROTECTED] Subject: RE: Replication Issue Does this table say that mysql 3.23.3

RE: Replication Issue

Does this table say that mysql 3.23.33 and up is not compatible to replicate to a mysql 5.0 slave? Thanks! Randy -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 12:21 PM To: [EMAIL PROTECTED] Subject: Re: Replication Issue "Randy Johnso

Re: Simple SQL Question

[snip] Anybody? > > I have a simple problem and I'm just wondering the BEST query to solve it. > > I want to return all the rows of a table whose foreign key value exists > more > > than once in that table. IE... > > > > MyTable > > Region(foreign key)City > > EastB

RE: Replication Issue

Here is what is in the error log: looks awful How do I determine if slave is running correctly. I though show Slave status \G did this... 041026 0:19:44 Slave I/O thread killed while reading event 041026 0:19:44 Slave I/O thread exiting, read up to log 'www-bin.001', position 5685 041

Re: Replication Issue

"Randy Johnson" <[EMAIL PROTECTED]> wrote: > I have mysql master and mysql slave on same machine running separately. > I have master and slave setup. > I was able to do the LOAD DATA FROM MASTER; > > to get the data but the data does not replicate after that. =20 > > Looking at the info

mysql 3.23 store large data

What type I should use in MySQL 3.23.58 to store large data file? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Simple SQL Question

Anybody? ""Jeff Burgoon"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Sorry, I forgot to mention I am using version 4.0.20a (no subqueries > supported) > > ""Jeff Burgoon"" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > I have a simple problem and I'm just wond

Re: phpMyAdmin and MySQL 4.1

Hi. See: http://www.phpmyadmin.net/documentation/#faqmysqlversions Regards. Schalk Neethling <[EMAIL PROTECTED]> 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: >

Re: Yet another question on DECMIAL precision

Hi. Thank you for the message, I've sent your report to docs team. > 5) I'm sucking data from Oracle into MySQL using Perl and > would like to propose a behavior change for DECIMAL ... >7) The article > http://www.ixora.com.au/notes/number_representation.htm?number=3.14159265358987

Re: phpMyAdmin and MySQL 4.1

Op woensdag 27 oktober 2004 16:52, schreef [EMAIL PROTECTED]: I had the same problem on my Linux suse 9.1 box. I was using a mysql client/server that came with my distro. Got the same error as you trying to connect with phpmyadmin, while I was sure to have installed the proper client (4.1) via

Re: html links inside varchar and text fields

Hi. When you output field data inside html pages, browser can interpret the tags inside fields (hackers usually use such things). Try to use htmlentities() and htmlspecialchars() to escape all '<' and '>' chars in data. Regards. "leegold" <[EMAIL PROTECTED]> wrote: > I have to put

Replication Issue

I have mysql master and mysql slave on same machine running separately. I have master and slave setup. I was able to do the LOAD DATA FROM MASTER; to get the data but the data does not replicate after that. Looking at the info below can you tell why replication is not taking place. Can I pro

Re: html links inside varchar and text fields

Just put the href into the database. When you output it to html in PHP wrap it wth the rest. $href=$sql->data['href']; echo "The Link\n"; leegold wrote: I have to put html links inside varchar and text fields. They have to be (somehow) fulltext searchable (of course a substring, %keyword% search,

Re: Querying on subsets of one-to-many and many-to-many

If the query is applied to a duplicates free set of data and making nolinks > 0, it does indeed deliver the expected results. Since the counters are not reused, they can even be used textually in the HAVING clause which doesn't add any extra columns to the final result set. Two things through. Fir

Re: phpMyAdmin and MySQL 4.1

You need to get caught up on your reading. The password hash changed as of 4.1 and this behavior is well documented. Start here: http://dev.mysql.com/doc/mysql/en/Problems.html and if you have more questions read this http://dev.mysql.com/doc/mysql/en/Password_hashing.html What it boils down t

html links inside varchar and text fields

I have to put html links inside varchar and text fields. They have to be (somehow) fulltext searchable (of course a substring, %keyword% search, would pick them up - I realize that) and they have to render as clickable links when I output the fields via PHP. How would I do this? Is this more of a P

Re: Full-Text Search

1. The manual says there is and it gives an example, but I haven't been able to get it to work and neither have other people on this list. If you look at the "planned" improvements of MySQL, a few of the major items have to do with full text searching. On Oct 26, 2004, at 7:39 PM, Jalil Feghhi

phpMyAdmin and MySQL 4.1

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 upgrading MySQL client. I get this whether I am usi

Where is 4.1.7 max 32 bit binary for Solaris?

Is there any plan to release a 32-bit binary 4.1.7 MySQL max for Solaris 9 and Solaris 8? I see all the other binaries for Solaris for everything - any reason to exclude the 32 bit? Thx, R

Re: help with proper conditions and indexes needed

I'm really sorry wasting your time but... but - at first I read all materials I found [including this chapter you suggested] I can't correct interpret these explains I described - I've tried to change the order in where clause, making different indexes but see no changes and no correction so I thi

Re: help with proper conditions and indexes needed

I really hate to do this to you but if I tried to answer your questions I would be copying from the book anyway. There is a section in the manual that deals specifically with query optimization. It covers index creation and usage, when an order by will and won't use and index and a bunch of ot

Re: Yet another question on DECMIAL precision

"Lawrence K. Hixson" wrote: > 4) This has been fixed in MySQL server 4.1, but why wasn't > this caveat explicitly WELL DOCUMENTED in the documentation > so developers could avoid this land mine along with the > additional gotcha under Windows? Could someone please > revise the documentation to mak

Re: Help with query

Shawn, Thank you very for your answer. Actually, I thought that a main SELECT couldn´t be filtered by the WHERE clause refered to a field in a LEFT JOIN. Now, looking better in the JOIN documentation I see this issue. Thank´s, Ronan This is a very FAQ: SELECT t1.* FROM TABLE_1 t1 LE

Re: Help with query

This is a very FAQ: SELECT t1.* FROM TABLE_1 t1 LEFT JOIN TABLE_2 t2 ON t1.id = t2.table1_id WHERE t2.id is null Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Ronan Lucio" <[EMAIL PROTECTED]> wrote on 10/27/2004 10:12:42 AM: > Hi, > > I have two tables: > > TAB

Re: Monkeys and Banannas (UPDATE .. JOIN .. SET .. GROUP)

Yes, good keys are crucial but I try to avoid them when demonstrating temp tables (I think it blurs the issue). All you need to do to have keys on a temp table is to either add the KEY() definitions to your CREATE TEMPORARY TABLE statements like this: CREATE TEMPORARY TABLE tmpCount1(KEY(name))

Yet another question on DECMIAL precision

Dear MySQL Support List: Way back in early 2003 two questions and answers appeared on this list and bug list RE: DECIMAL precision. See both at http://lists.mysql.com/mysql/141268 and http://bugs.mysql.com/bug.php?id=559 1) Did anyone else notice that the 'INSERT INTO' value DID NOT MATCH the 'S

help with proper conditions and indexes needed

hi again, I have question like that: SELECT /*! SQL_BUFFER_RESULT */ DISTINCT branza.branzaid, branza.branzanazwa FROM branza, klientbranza, klientwojewodztwo WHERE branza.branzaid = klientbranza.branzaid AND klientbranza.klientid = klientwojewodztwo.klientid AND wojewodztwoid =9 ORDER BY bsort A

Re: Help with query

SELECT `TABLE_1`.* FROM `TABLE_1` JOIN `TABLE_2` USING (`id`) WHERE `TABLE_2`.`id` IS NULL Asuming that the "reference" is the id field... Regards, Jigal. - Original Message - From: "Ronan Lucio" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 27, 2004 3:12 PM Subject

Help with query

Hi, I have two tables: TABLE_1 === - id - name TABLE_2 === - id - table1_id - name How could I make a select on table_1 that returns me only the rows that don´t have any reference in table_2? Any help would be appreciated. Thank´s, Ronan -- MySQL General Mailing List For list arch

Re: ulimit problem

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 caused some other processes running on the box to hang and > coredump so I had to kill it off. > > I'll try runn

Re: mysql and innoDB

Egor Egorov <[EMAIL PROTECTED]> wrote: > "Stefan Gnann" <[EMAIL PROTECTED]> wrote: > >> I have a mysql database 4.0.15 on a suse linux 9.x system running. > > First, upgrade to .20 version officially built by MySQL AB (http://dev.mysql.com/). > RPM version is easy to install and run. O

Re: mysql browser

Hi. MySQL Query Browser is a graphical tool designed to help constructing and executing queries. "Andy B" <[EMAIL PROTECTED]> wrote: > Hi. > I was wondering how you can edit/change tables and data inside a table with > mysql query browser. I run mysql 5.0.0 on windows xp sp2. It says in

Re: ulimit problem

Thanks for your reply Gleb. I tried running with --safe-recover instead of -qr but that caused some other processes running on the box to hang and coredump so I had to kill it off. I'll try running: myisamchk -qr --tmpdir=/proxydb/mysql/tmp -O sort=16M -O key=16M -O read=1M -O write=1M --sort-i

mysql browser

Hi. I was wondering how you can edit/change tables and data inside a table with mysql query browser. I run mysql 5.0.0 on windows xp sp2. It says in the help that you can edit/change tables and data inside tables if there is enough identifiable information inside the table. What does that mean a

proper index creating

hi, I have some question about indexes more... in this example we have table just like this: table_tbl tableid int [primary key] tablefield1 tablefield2 ... tablefieldx tablefieldsort1 int tablefieldsort2 varchar(32) there are lots of questions containing order by clause like: select t.* from

mysql & tomcat

Hi All, we are using mysql and tomcat ... when i try to access the other system's data the programs throw "javax.servlet.ServletException: Server configuration denies access to data source " exceptionwhere as when i access the databse on the same system(ie., localhost) then it does not throw

Re: ERROR 123 when reading table

Hi. Try to upgrade to the latest version (use official binaries from MySQL). Unreal HSHH <[EMAIL PROTECTED]> wrote: > Sometimes, mysql client got this error, > mysql error: Record has changed since last read in table 'table' > > And I checked from mysql error log, > 041023 8:28:06 Got error 12

Re: LOAD DATA LOCAL: The used command is not allowed with this MySQL version

Hi. See http://dev.mysql.com/doc/mysql/en/LOAD_DATA_LOCAL.html "Martin Rytz" <[EMAIL PROTECTED]> wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ _

Re: select from table hangs?

Hi. Try to upgrade to the latest release (use official binaries from MySQL). Kristina Clair <[EMAIL PROTECTED]> wrote: > Hello, > > I am having a problem with a mysql (myisam) table that I've never had > before, and I'm completely stumped! > > I am using mysql version 4.0.13. > > myisamchk -e

LOAD DATA LOCAL: The used command is not allowed with this MySQL version

Hi mysql-community! I have a problem with mysql 3.23.49a: If I try to use the statement 'LOAD DATA LOCAL INFILE '/storage/hosting/uxclients/www.xxx.ch/transfer/golfclub.csv' INTO TABLE test' mysql replys: 'The used command is not allowed with this MySQL version'. Why this error-message? Wa

Re: "Data Truncated" warning about join, not insert?

Sorry I forgot to include table-defs: .. OK, I've got it entirely reproducible now, without giving away any sensitive data. No, the column-lengths are the same. But doing this has shown me that it's something to do with the partial key on the 'email' column in the 'user' table. If you remove it,

Re: ulimit problem

Hi. Usually myisamchk doesn't have the suid bit set, and it seems to be ran as root. See http://dev.mysql.com/doc/mysql/en/Table_maintenance.html Especially http://dev.mysql.com/doc/mysql/en/myisamchk_memory.html "J S" <[EMAIL PROTECTED]> wrote: > Hi, > > I've run myisampack to compress

Re: Outputting Data

Hi Christopher You need the FROM MembersData directly after the SELECT and before outputting. HTH Steve Christopher Chamber wrote: I have a query: $QRY = "SELECT * FROM MembersData"; --> Executes fine, no problems. I have another though: $DataSet3 = "SELECT * INTO OUTFILE '/www/Export/DataSet3.cs