SELECT data FROM two tables into outfile

Hello list: Need some help with the following query: mysql> SELECT header.date_in,header.pid,header.status,body.body_data from header,body where header.date_in='1170705152' and body.date_in=header.date_in and header.pid='26878' and body.pid=header.pid into outfile '/tmp/mysql/117070515226878'

encrypt() call on Win32

While I found some information on this subject: http://groups.google.com/groups?q=mysql+win32+encrypt&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=be3g14%24ulu%241%40FreeBSD.csie.NCTU.edu.tw&rnum=1 I can't make much sense of it. Is there a *clear* way to have encrypt() call working on mySQL running on Wi

last_insert_id() query

Hi, I have a big problem with last_insert_id() query. I am adding records to a table with about half a million records in it. The insert takes well under a second. I then call last_insert_id as I need to make a link to another table. The last_insert_id takes around 2 minutes!!! Yes *minutes*

Error message

Hi, In my mysql .err file I get a lot of the following error... "Aborted connection 121031 to db: ..connection details... (Got an error reading communication packets)" What does this mean, and is it bad, and what do I do about it? Any help appreciated. Howard -

Explanation of error message

Hi, In my mysql .err file I get a lot of the following error... "Aborted connection 121031 to db: ..connection details... (Got an error reading communication packets)" What does this mean, and is it bad, and what do I do about it? Any help appreciated. Howard -

Re: MySQL Server Installation Problem

Sounds as though you haven't got Perl installed, or more particularly the DBI modules for MySql. If you on Linux, almost certainly to be found on your Linux CDs. HM Suresh R. Soni writes: > Hi All, > > I am getting following error msg when I try to install > MySQL using rpm -i My* > >

Mystery files

Hi, I my mysql server database directory (that is the directory that holds the .err and .pid files) so strange files have apeared. They look line -bin.001 -bin.002 etc -bin.index Some of them are huge! They seem like binary files, but are full readable SQL commands that could be f

Re: Table RAID

Hi, Thanks I DID read the documentation. BUT there documentation gives no information about how to choose values for these settings. There are no clues at all. What are good values, and/or what is the effect on performance etc. of the values? Howard Egor Egorov writes: > mysql, >

Re: Optimization And Memory Size

You have written the following: I have a mysql database table that is currently 1.5G in size with well over a million records. It is running on a twin pentium 3 1G processor machine with SuSE Linux version 1.4. Recently inserts have become VERY slow (several seconds). As I am adding around

Re: Table RAID

I have a very large mysql table (1.5G) and so will need to implement the table RAID option soon. How do I pick the CHUNKSIZE and number of chunks values? Howard - Before posting, please check: http://www.mysql.com/ma