MySQL install problems on OSX 10.4

I've just installed MySQL 4 4.1.12_1 +server using darwinports but I can't seem to get past this error. After installing it tells me that it cold not resolve my IP. Mattys-iMac-G5:/opt/local/bin matty$ sudo -u mysql ./mysql_install_db Password: WARNING: The host 'Mattys-iMac-G5' could not be looke

Re: Timezone query similiar to pgsql

In the last episode (Sep 10), Terence said: > Does MySQL have something similiar to > > SELECT TIMESTAMP '2001-02-16 20:38:40' AT TIME ZONE 'Canada/Pacific'; > > I need to handle the timestamp in the database. Previous posts and some > googling suggests it should be in the PHP layer which is not

Timezone query similiar to pgsql

Hi List, Does MySQL have something similiar to SELECT TIMESTAMP '2001-02-16 20:38:40' AT TIME ZONE 'Canada/Pacific'; I need to handle the timestamp in the database. Previous posts and some googling suggests it should be in the PHP layer which is not an option for me. My users come from vario

Re: Simple Count Query

Oops, that should be: select count(distinct fld1, fld2) from yourtable where fld4 = 'am'; That version of the query is tested and works with your data; it returns the fact that there are 5 combinations of fld1 and fld2 for all the rows where fld4 is 'am'. Rhino - Original Message - Fro

Re: Simple Count Query

I think you want this or something similar: select count(distinct fld2) from yourtable where fld4 = 'am'; N.B. I have not tested this solution. Rhino - Original Message - From: "Ed Reed" <[EMAIL PROTECTED]> To: Sent: Friday, September 09, 2005 6:08 PM Subject: Simple Count Query I

Simple Count Query

I know this has to be a simple query but its really kickin' my butt. I have the table below where fld1 is the year, fld2 is a number, fld 3 is a subnumber, and fld4 is the user. I need to know the count of all the records for user am without the sub number getting in the way. For example, the f

stop loading when error

when using the loading command load data local infile '/home/kzhou/xxxy.data' into table mytable; it will run to completion, after a long time, then telling me that 90% of the rows are skipped. load data local infile '/home/kzhou/RUN_BLAST/pep2genome_ost9901.tbn.tab' into table peptidetblne

Re: Data import problems

Perhaps you mean 'sed'. Filipe Tomita wrote: tks for reply but i dont have acces to original database... the dump file not generated from me.. Someone tell me about "SAD" command to replace table name to correct name but i dont find anything about it. On 9/9/05, [EMAIL PROTECTED] <[EMAIL PR

Re: Data import problems

tks for reply but i dont have acces to original database... the dump file not generated from me.. Someone tell me about "SAD" command to replace table name to correct name but i dont find anything about it. On 9/9/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > Filipe Tomita <[EMAIL

Re: Data import problems

Filipe Tomita <[EMAIL PROTECTED]> wrote on 09/09/2005 04:37:01 PM: > Hi people, > > I having problems to import a dump generated via mysql dump in mysql > 4.0.20slackware version to a mysql > 4.1.14. > The dump generated with other table name (Insert into temp, temp2 , temp3) > in 20 sql large

Data import problems

Hi people, I having problems to import a dump generated via mysql dump in mysql 4.0.20slackware version to a mysql 4.1.14. The dump generated with other table name (Insert into temp, temp2 , temp3) in 20 sql large (420mb.) sql files. I tried LOAD DATA INFILE but data not inserted correctly, some

Re: HTML in MySQL?

Use addslashes($htmlCode) and execute query normally. > ?> > []´s Tomita On 9/9/05, Vladimir B. Tsarkov <[EMAIL PROTECTED]> wrote: > > Hello! > > > Be careful here Vladimir, the (\n) are not 'null' characters; but > newline > > characters. > > Agree, I was wrong. > > > And i would highly

Re: HTML in MySQL?

Vladimir B. Tsarkov wrote: Hello! Be careful here Vladimir, the (\n) are not 'null' characters; but newline characters. Agree, I was wrong. And i would highly recommend *not* replacing them with tags as you write them into the database. This is asking for trouble on so many

Re: HTML in MySQL?

Hello! > Be careful here Vladimir, the (\n) are not 'null' characters; but newline > characters. Agree, I was wrong. > And i would highly recommend *not* replacing them with > tags as you write them into the database. This is asking for trouble on > so many levels. > > The database will cop

Re: MySQL 4.0.26 has been released

Hi! Remo Tex wrote: ...and when MySQL-shared-compat-4.0.26-0.i386.rpm will be released? rpm (and some older tools) complains :( There is only: Dynamic client libraries (including 3.23.x libraries)4.0.25-0482.1K It has been built by now, and it is on its way propagating to the

default my.cnf vs huge.cnf nearly same performance with sql-bench/run-all-tests

infact .. the default debian config (some of these are just explicit defaults but this is what debian provides): [mysqld] user= mysql pid-file= /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port= 3306 basedir = /usr datadir

Re: Help with SQL Command

Hello. >..e, but I am manually entering it in. Use mysql command line client. You may pass SQL statements as the command line options or execute them from the file (i.e mysql -e "sql_statement" or mysql < sql_file). See: http://dev.mysql.com/doc/mysql/en/mysql.html Eric Mynes

Re: `gmake test` probs Solaris9 for M. 4.1.4.

On Fri, 9 Sep 2005, Joerg Bruehe wrote: Michael, you beat me in replying, and saved me from typing the analysis - thanks! Michael Stassen wrote: [[...]] The test suite is broken. Well, I would not put it that way - a diplomatic wording is: "The tool to run the test suite does not run as

Re: Total newb at performance tuning mysql

One of our engineers first installed MySQL on one of our Sun boxes which was doing nothing more than MySQL... It seems we also put it on the server and turned it on... it behaved very badly. Essentially when we started to investigate MySQL and find out if we could use it we discovered that

Re: row level replication in 5.1

Kenji HIROHAMA <[EMAIL PROTECTED]> wrote on 09/08/2005 08:54:58 PM: > Hi, > Does somebody point me out where I should refer to understand what is > "row level replication" implemented in 5.1? > > I should have read the source comments in the source tree, but the bk > port is closed at my environm

How to save graphs in a table?

I would like to save graphs in a mysql data base. The table definition I have set up is: CREATE TABLE `GRAPHS` ( `graphid` int(11) NOT NULL auto_increment, `graphic` blob, `f_time_stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`graphid`) ) ENGINE=

Re: `gmake test` probs Solaris9 for M. 4.1.4.

Michael, you beat me in replying, and saved me from typing the analysis - thanks! Michael Stassen wrote: [[...]] The test suite is broken. Well, I would not put it that way - a diplomatic wording is: "The tool to run the test suite does not run as it should." I understand that the effect f

Re: `gmake test` probs Solaris9 for M. 4.1.4.

On Fri, 9 Sep 2005, Michael Stassen wrote: Hugh, I get the same thing on Mac OS X 10.3.9. My thinking was that rather than replying with an unhelpful "Me too", I would do some digging and then reply with what I found. I realize now that left you hanging (sorry), so I'll report what I've f

Re: `gmake test` probs Solaris9 for M. 4.1.4.

Hugh, I get the same thing on Mac OS X 10.3.9. My thinking was that rather than replying with an unhelpful "Me too", I would do some digging and then reply with what I found. I realize now that left you hanging (sorry), so I'll report what I've found so far. The test suite is broken. The

Replication started but not running

Hey all, Just brought up a new RH EL3 server and updated MySQL to ver 4.1.13-standard I'm trying to get replication from an older server running version Server version 4.0.16-standard-log Replication on the slave system seems to start ok but then just sites there with "connecting to master" mys

RE: HTML in MySQL?

Amen. Translating user input into HTML is great until you need to read the data *out*, and someone decides the output should be formatted as RTF or PDF or text. Best to store it as you got it, IMO. > -Original Message- > From: Alan Williamson [mailto:[EMAIL PROTECTED] > Sent: Friday, Se

RE: HTML in MySQL?

> If you use textarea field of a form, it produces "null" characters (\n) in the > end of every string. I recommed to replace them with "" tags before > writing into the database. It'll help to avoid output problems. Use > preg_replace(); for it. Be careful here Vladimir, the (\n) are not 'nul

Help with SQL Command

Greetings all, I am knew to the the world of SQL and am interested in putting data into a database that I have created. The data will be in the form of a tab delimited text file that will generated several times a day with different data. What I would like to do is use the LOAD LOCAL DATA INFIL

Re: Optimizing query "WHERE date>0"

"Devananda" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Dan Baker wrote: >> "Eric Bergen" <[EMAIL PROTECTED]> wrote in message >> news:[EMAIL PROTECTED] >> >>>When you add that index are more than 30% of the rows in the table >>>DateTimeNext>1126215680? >> >> >> There are curre

Re: Delayed UPDATE execution?

Okay, I asked the web host guys and this is what they said: "Hi Jenifer, we only use single instances of MySQL so the master/slave replication issue would not be possible. As far as I know, the only way a delayed update could occur would be if you had multiple updates queued behind a slow upd

Re: `gmake test` probs Solaris9 for M. 4.1.4.

I've see no reply to this and I checked the archives, so please excuse my resubmitting it. Maybe I shouldn't be using 4.1.14 but 4.0.x? Thank you, Hugh On Wed, 7 Sep 2005, Hugh Sasse wrote: Attempts to do make test prior to installation, to check that I'm installing something wo

Re: HTML in MySQL?

Hello, Clint! > I'm trying to design a Database that would hold HTML sites in the DB itself > and use PHP to call for the HTML file - which would be populated with > Content from another table in MySQL. I was told I could put HTML into > MySQL... so my main question would be: "is this possible?

MySQL db size using "show table status"

Hi, I am trying to compute the MySQL db size using "show table status" command. It gives me the size of .MYD and .MIY files, but not .frm which is typically 12k (using 4.1.9 version of MySQL) Qus 1. is there any way to deterministically compute the value of .frm file Qus 2. Is there any other way

Re: Delayed UPDATE execution?

Hello. >So now my question... is it possible that MySQL didn't execute that first >UPDATE query on >that first page until after the rest of the process completed? >... >- Every page has UPDATEs, INSERTs, or DELETE commands so I'm wondering >whether the

Re: MySQL 4.0.26 has been released

...and when MySQL-shared-compat-4.0.26-0.i386.rpm will be released? rpm (and some older tools) complains :( There is only: Dynamic client libraries (including 3.23.x libraries)4.0.25-0482.1K Joerg Bruehe wrote: Hi, MySQL 4.0.26, a new version of the popular Open Source/

Re: Total newb at performance tuning mysql

Scott Haneda wrote: Unless I am totally off base here, the mysql docs tell very little in regards to how to performance tune mysql. So far I have found this article to help: But it still leaves me with a ton of questio

Delivery failed

The original message was received at Fri, 9 Sep 2005 15:00:22 +0800 from chosun.com [77.253.195.244] - The following addresses had permanent fatal errors - - Transcript of session follows - ... while talking to host 147.168.60.215: 550 5.1.2 ... Host unknown (Name server: host n