Replication Failure (or Bug?): Cannot Connect, but Should?

[Leonard Megliola]

Hello,

I have been attempting to get replication working for a week now and am 
having little luck. I have followed the instructions in the documentation 
but get the following errors in the error log on the slave server:

020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is not 
allowed to connect to this MySQL server(0), retry in 0 sec
020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is not 
allowed to connect to this MySQL server(0), retry in 0 sec
020325 0:32:22 Slave thread: error connecting to master:Host 'www1' is not 
allowed to connect to this MySQL server(0), retry in 0 sec
020325 0:32:24 Slave thread: error connecting to master:Can't connect to 
MySQL server on '0' (11)(107), retry in 0 sec
020325 0:32:24 Slave thread: error connecting to master:Can't connect to 
MySQL server on '0' (11)(107), retry in 0 sec
020325 0:32:24 Slave thread: error connecting to master:Can't connect to 
MySQL server on '0' (11)(107), retry in 0 sec

Here are the relevant lines from my configuration files

Master my.cnf:
[mysqld]
socket=/var/lib/mysql/mysql.sock
log-bin
server-id=1

Slave my.cnf:
[mysqld]
socket=/var/lib/mysql/mysql.sock
master-host=10.0.0.10
master-user=repl
master-password=password
master-connect-retry=10
master-port=3306
server-id=2

I created the repl account on the master and have tried giving it FILE 
privileges and ALL PRIVILEGES on '%', '10.0.0.10' and the hostname of the 
slave server.

The thing that stands out most for me about the error messages is that it 
says "Can't connect to MySQL server on '0'" when I have clearly entered the 
IP address, and that it says retrying in 0 seconds when I made the timeout 
10 seconds.

The MySQL version on the master server is 3.23.35 and the slave version is 
at 3.23.32.

Any help would be greatly appreciated.

Thanks,

Leonard

P.S. sql query


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

eplication-bin.log binary corrupt ? help me !!!

[Dicky Wahyu Purnomo]

mozart:/usr/local/mysql/data# mysqlbinlog 
/app/backup-replication/austria_replication.031
ERROR: Bad magic number;  The file is probably not a MySQL binary log

the beginning of this file is corupt ... how can i use/fix it ?

thx

-- 
C is quirky, flawed, and an enormous success
-- Dennis M. Ritchie

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Impact of Free ORACLE

[Robert Cross]

"Ron Jamison" <[EMAIL PROTECTED]> wrote:
>I'd be hardpressed to find a better, more stable database (MySQL) with the
wonderful
>support that comes from the whole community.
Couldn't agree more. It's a shame that Microsoft, Oracle, IBM's support for
their DB's
isn't as good, (and inexpensive!!) as MySQL's.

>Oracle will continue to be slowly abandoned as the decision makers choose
open
>source and low (no) cost over proprietary and stupendous costs.
And if you truely believe that, would you be interested in this bridge I've
got for
sale ;-) ?!  The commercial databases will always have the the advantages
of better image to the damned bean-counters and a better feature set or
app support, (If you've standardised on M$ tools for building then -
surprise, surprise
- it's easier if you're using SQLServer as the backend). Don't
misunderstand me -
MySQL is great, (in fact the last place I used it, I couldn't have used
SQLServer,
Oracle, DB2 - the technical requirements meant that it had to be either
MySQL or PostgreSQL).

>I for one will be glad to see those inflated price tags go.
Hear, hear - mind you with Larry E's guys it'd be nice to get a consistent
price, (three
different prices for the same piece of software in the space of 30 days!!)

Bob Cross.
(mysql query database table)



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
This message is confidential.  It may also be privileged or
protected by other legal rules.  It is not an offer 
or acceptance of an offer, nor shall it form any part
of a legally binding contract.  If you have received this
communication in error, please let us know by reply then
destroy it.  You should not use, print, copy the message or
disclose its contents to anyone.

E-mail is subject to possible data corruption, is not
secure, and its content does not necessarily represent the
opinion of this Company.  No representation or warranty is
made as to the accuracy or completeness of the information
and no liability is accepted for any loss arising from
its use.

This e-mail and any attachments are not guaranteed to be
free from so-called computer viruses. You should check for 
viruses before down-loading it to your computer equipment. 
This Company has no control over other websites to which there
may be hypertext links and no liability is accepted in relation
to those sites.

This Company randomly monitors its e-mail system (including 
incoming e-mails) for operational purposes.

Scottish & Newcastle plc
Registered in Scotland, Registered Number 16288
Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Compiling mysql on HP-UX

[Stephane JEAN BAPTISTE]

I want to install my sql on an HP-UX 10.20. 
I made ./configure with the options for HP-UX 10.20, as on the officiel
site and I had no problem.
But when I do "make", I have this error : why ?


gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -I./../include -I./.. -I..
-D__STDC_EXT__  -O3 -DDBUG_OFF -DHPUX -I/opt/dce/include -fpic
-DHAVE_BROKEN_SNPRINTF -DSIGNALS_DONT_BREAK_READ
-DDO_NOT_REMOVE_THREAD_WRAPPERS -DHPUX -DSIGNAL_WITH_VIO_CLOSE -c
rltty.c
: warning: "__STDC_EXT__" redefined
: warning: this is the location of the previous definition

rltty.c: In function `set_tty_settings':
rltty.c:231: `TIOCSETN' undeclared (first use in this function)
rltty.c:231: (Each undeclared identifier is reported only once
rltty.c:231: for each function it appears in.)
rltty.c: In function `prepare_terminal_settings':
rltty.c:286: `CBREAK' undeclared (first use in this function)
*** Error exit code 1

Stop.


What do I have to do ?

Thank you

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL C API documentation

[Konstantin Osipov]

* Michael Widenius <[EMAIL PROTECTED]> [02/03/26 12:41]:

> Konstantin> class Cursor
> Konstantin> {
> Konstantin>Cursor(MYSQL_RES *res):_res(res) {}
> Konstantin>bool fetch() { return mysql_fetch_row(_res); }
> Konstantin>Row row() { return Row(_res->current_row); }
> Konstantin>~Cursor() { 
> Konstantin> while (!mysql_eof(_res) && mysql_fetch_row(_res))
> Konstantin> ;
> Konstantin> mysql_free_result(_res);
> Konstantin>}
> Konstantin> };
> Konstantin> In this code snippet I have to problems. 
> Konstantin> First, that I can't simply return to user current row without 
> Konstantin> moving the cursor to next row: there is no C API function like 
> Konstantin> mysql_current_row(). 
> Konstantin> Nevertheless, MYSQL_RES always stores current row in member field 
> Konstantin> 'current_row', so I have to use this undocumented feature 
> Konstantin> (I can have my own current_row, but why should I?)

> I couple of comments about the above:
> 
> - The code above would be safer against the future if you in the class
>   cursor stored the value from mysql_fetch_row and returned this in your 'row'
>   function, instead of relying on mysql->current_row.

I've realised eventually that You have reasons not to provide access for
mysql_res->current_row, and I do store my own copy of current_row in Cursor.

> In the ~function, you don't have to call mysql_fetch_row().
> mysql_free_result() will do this for you.

But, according to MYSQL C API documentation, 8.4.2, 
(http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#C_API_function_overview)
I have to do this:

"An advantage of mysql_use_result() is that (...)
(...)
Furthermore, you must retrieve all the rows even if you determine in
mid-retrieval that you've found the information you were looking for."

> Anyway, it would still be nice if you could send your questions to
> [EMAIL PROTECTED] instead of directly to me;  I do get +300 emails
> per day and I simple don't have time to answer all questions direct to
> me :(

Sorry && thank you. 

-- 
 WBW, Konstantin Osipov
 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

getting files into BLOBs and some more

[Tomas Sanchez Romani]

Hi!


I'm thinking of creating a quite simple filemanager, using mysql/php, for a
groupware-suite.

My first approach was to just create a directory-tree on the webserver and
let my app mirror that, then I realised that I needed some privilege-system
and thus mysql.



How do I insert files inte BLOBs?



Maybe it would be better to still use a 'real' directory tree and just keep
track of the privileges with mysql? I don't know. pointers, please


regards, tomas

ps. this is my first post on this mailinglist, if you find this kind of
post/post-formatting unacceptable let me know (in private) and I'll change
the style.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.338 / Virus Database: 189 - Release Date: 2002-03-14


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

grant tables failed

[Michael Widenius]

Hi!

> "vi" == vi nan <[EMAIL PROTECTED]> writes:

vi> Dear all,

vi> I can't install mysql on my computer (HP_UX model 715, 10.20) it occured memory 
fault install grant tables failed 

vi> pleased help on Attachments 

vi> chamnan.v

The problem is probably that your CPU is not compatible with the one
we have used to build HP-UX binaries.

To solve this, please download the MySQL source and compile it
according to the instructions in the MySQL manual.

Regards,
Monty

-- 
For technical support contracts, goto https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, CTO
/_/  /_/\_, /___/\___\_\___/   Helsinki, Finland
   <___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Trapping for no user input in a query

[Kim Kohen]

G'day Ron, all

> Tailor your query to the request of your user(s).
> if ($param1)
> $sql .= "(ad_copy) against ('$param1')";
> if ($param1 && $param2)
€
Thank you for your reply.  If at all possible though, I'd like to do it from
the mysql side rather than the php side of things.

Is there such a thing as a wildcard character that can be used with a
fulltext index that will return all rows?

cheers

kim


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Report to Recipient(s)

[ININOTES/INI]

Incident Information:-

Originator:[EMAIL PROTECTED]
Recipients:[EMAIL PROTECTED]
Subject:  mysql Digest 26 Mar 2002 10:26:12 - Issue 1817

Message from [EMAIL PROTECTED] was quarantined because it
contained banned content.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: getting files into BLOBs and some more

[Philip Semanchuk]

> 
> How do I insert files inte BLOBs?
> 

Tomas,
I use this PHP function to insert ASCII files into BLOBs. I think it would
also work for binary files but I have not tested it. Please note that there
are other (perhaps better) ways to insert into BLOBs but this works for me.

Good luck,
Philip

-- code starts here -- 
function RecordFile($pathname, $filename) {
  $filesize = filesize($pathname . "/" . $filename);
  
  $fp = fopen($pathname . "/" . $filename, "r");
  $content = fread($fp, $filesize);
  fclose($fp);

  $content = addslashes($content); 
  $filename = addslashes($filename); 
  $pathname = addslashes($pathname);
  
  $s = "insert into files (path, name, size, content) values (";
  $s = $s . "'" . $pathname . "', ";
  $s = $s . "'" . $filename . "', ";
  $s = $s . "'" . $filesize . "', ";
  $s = $s . "'" . $content . "'";
  $s = $s . ")";
  
  if (mysql_query($s) == false) {  
lprint("Query failed: " . $s);
lprint(mysql_error());
  }
}

-- code ends here -- 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Coldfusion,Mysql,Myodbc

[[EMAIL PROTECTED]]

Hi there .
I am new to Mysql.I have to access mysql from coldfusion..and we dont get
myODBC as binary for solaris 6 ot 8. so we have to compile them...and i am
not able to compile the myODBC bit...its giving compilation problem..Any
suggetions from you guys.
I need it asap..kindly help..
Thanks
Srini


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

First Question

[Dennis Peyerl]

Hi I am new to the list

My boss told me I have three days of time to develop a php-website that 
is capable to handle SQL-Requests into a database.

Problem is I don't have any experiences.

Now I have startet with compiling Apache with PHP support and installing 
the MySQL package which comes with SUSE 7.3.

I logged into MySQL with ./usr/local/mysql/mysql
but I don't know how to start. I got a manual which starts when I have 
already some tables. But I don't have a database yet.
How do I create.

Thank you in advance and I am very sorry about these kind of questions, 
but I will get better.

dcp


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

HELP - List Admin Please READ

[Hoo Kok Mun]

Hi Administrator,

MySQL List admin, please help to remove my address from this list.
[EMAIL PROTECTED]

I have been receiving multiple of the same emails since a few weeks back.
I have removed myself from the list but I am still receiving them.

I have check my email settings and nothing out of the ordinary.
I am receiving all my other emails fine without duplication.

I reckon it is the problem on the list.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Coldfusion,Mysql,Myodbc

[andy thomas]

On Tue, 26 Mar 2002, [EMAIL PROTECTED] wrote:

>
>
>
> Hi there .
> I am new to Mysql.I have to access mysql from coldfusion..and we dont get
> myODBC as binary for solaris 6 ot 8. so we have to compile them...and i am
> not able to compile the myODBC bit...its giving compilation problem..Any
> suggetions from you guys.

ColdFusion 4.5.1 and later ship with the Merant ODBC drivers for MySQL
and you should be using these. Note that the cfodbc45.so driver shipped
with ColdFusion Enterprise Server 5.0 (which lives in ../coldfusion/lib)
is broken and you can download a fixed version from Macromedia's web site.

Andy


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Coldfusion,Mysql,Myodbc

[Xavier Prelat]

Even if you are using the CFServer 5.0 you will not be able to edit any
MySQL DSN with the ColdFusion DSN web admin tool. First install the MySQL
ODBC on your server, then create any DSN you need using the ODBC Sources
tool (administrator tool on Win 2000).
Once you created the DSN you want, the CF let you manage the DSN through the
web admin interface!

hopt it helps.
Xavier

Xavier Prelat
Chief Technical Officer
WEBCENTRIC
25 rue de Ponthieu
75008 PARIS - FRANCE
http://www.wcentric.com


-Message d'origine-
De : andy thomas [mailto:[EMAIL PROTECTED]]
Envoye : mardi 26 mars 2002 13:14
A : [EMAIL PROTECTED]
Cc : [EMAIL PROTECTED]; [EMAIL PROTECTED]
Objet : Re: Coldfusion,Mysql,Myodbc




On Tue, 26 Mar 2002, [EMAIL PROTECTED] wrote:

>
>
>
> Hi there .
> I am new to Mysql.I have to access mysql from coldfusion..and we dont get
> myODBC as binary for solaris 6 ot 8. so we have to compile them...and i am
> not able to compile the myODBC bit...its giving compilation problem..Any
> suggetions from you guys.

ColdFusion 4.5.1 and later ship with the Merant ODBC drivers for MySQL
and you should be using these. Note that the cfodbc45.so driver shipped
with ColdFusion Enterprise Server 5.0 (which lives in ../coldfusion/lib)
is broken and you can download a fixed version from Macromedia's web site.

Andy


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Segmentation fault in MySQL database on Solaris2.8 for Intel.

[Prachi]

Hi,

After following the procedure on the web site for installing the MySQL
database on Solaris machine we encountered Segmentation fault (during the
Configuring mySQL for your machine step).

Please help me with this.

Regards,
Prachi.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Coldfusion,Mysql,Myodbc

[andy thomas]

On Tue, 26 Mar 2002, Xavier Prelat wrote:

> Even if you are using the CFServer 5.0 you will not be able to edit any
> MySQL DSN with the ColdFusion DSN web admin tool. First install the MySQL
> ODBC on your server, then create any DSN you need using the ODBC Sources
> tool (administrator tool on Win 2000).
> Once you created the DSN you want, the CF let you manage the DSN through the
> web admin interface!

Hmmm, that is odd. We have had no problem editing MySQL DSN's with the
Merant drivers, although where you are asked for the MySQL server's
hostname (and the MySQL server is on the same system as Cold Fusion), you
must give the full hostname, not just "localhost". If you use 'localhost'
it will work initially but if you need to restart cfserver for any reason,
then it will not be able to verify the DSN again, unless you have used the
full Internet address of teh MySQL server.

Andy

> -Message d'origine-
> De : andy thomas [mailto:[EMAIL PROTECTED]]
> Envoye : mardi 26 mars 2002 13:14
> A : [EMAIL PROTECTED]
> Cc : [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Objet : Re: Coldfusion,Mysql,Myodbc
>
>
>
>
> On Tue, 26 Mar 2002, [EMAIL PROTECTED] wrote:
>
> >
> >
> >
> > Hi there .
> > I am new to Mysql.I have to access mysql from coldfusion..and we dont get
> > myODBC as binary for solaris 6 ot 8. so we have to compile them...and i am
> > not able to compile the myODBC bit...its giving compilation problem..Any
> > suggetions from you guys.
>
> ColdFusion 4.5.1 and later ship with the Merant ODBC drivers for MySQL
> and you should be using these. Note that the cfodbc45.so driver shipped
> with ColdFusion Enterprise Server 5.0 (which lives in ../coldfusion/lib)
> is broken and you can download a fixed version from Macromedia's web site.
>
> Andy
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysql/php on Win2000

[jake williamson 28]

i've got IIS (so i can do ASP), apache, php, mysql and darwin streaming
server all running on a w2k box that i use for web dev.

i've set the services to start manually and depending on what i'm doing for
the day i'll start them up individually.

all works, it's fast and rarely give me hassle - redhat on the overhand has
been a nightmare to set up but then again, i'm only starting out on it...

the main thing is windows offers so many other web technologies (plugin 'n
stuff) that i need it!

bloody microsoft!

cheers,

jake

on 25/3/02 18:33, Andrew Hazen at [EMAIL PROTECTED] wrote:

> Hi, if you think that IIS and Apache are going to have problems
> co-habitating then, yes, please tell me which services to kill.  On the
> other hand, I'm not using IIS for anything else, maybe I should try to
> uninstall it before installing Apache???
> 
> Thanks.
> 
> Andrew Hazen


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Re: MySQL replication

[Patrick Ouellet]

Thanx Shawn

I also realised that you can use

SHOW MASTER STATUS and SHOW SLAVE STATUS

both will tell you where they are now.

MASTER will tell you the size on the bin-log
SLAVE will tell you where it is in the bin-log

sql query
-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Patrick Ouellet - Techniciens Specialiste
[EMAIL PROTECTED]
Recherche & Developpement
Les Entreprises Microtec inc.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
"First they ignore you. Then they laugh at you.
Then they fight you. Then you win."
-Mohandas Gandhi
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
All source code included (if any ) is
copyright Microtec Technologies Inc. 2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Multiple Search

[Egor Egorov]

delz,
Tuesday, March 26, 2002, 5:15:51 AM, you wrote:

d> How do i perform multiple search in mysql. For example I have a database
d> running in a computer shop and I want to search for Monitors specifically
d> purchased  from 03/01/2002 to 03/31/2002. Can any one help me?

SELECT * FROM your_table WHERE date>'2002-03-01' AND
date<'2002-03-31';

d> Regards,
d> Delz





-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

eplication-bin.log binary corrupt ? help me !!!

[Egor Egorov]

Dicky,
Wednesday, March 27, 2002, 12:45:20 AM, you wrote:

DWP> mozart:/usr/local/mysql/data# mysqlbinlog 
/app/backup-replication/austria_replication.031
DWP> ERROR: Bad magic number;  The file is probably not a MySQL binary log

DWP> the beginning of this file is corupt ... how can i use/fix it ?

The file is coruppted and you can probably restore it creating a new
one.

DWP> thx





-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

First Question

[Victoria Reznichenko]

Dennis,
Tuesday, March 26, 2002, 2:12:43 PM, you wrote:

DP> My boss told me I have three days of time to develop a php-website that 
DP> is capable to handle SQL-Requests into a database.

DP> Problem is I don't have any experiences.

DP> Now I have startet with compiling Apache with PHP support and installing 
DP> the MySQL package which comes with SUSE 7.3.

DP> I logged into MySQL with ./usr/local/mysql/mysql
DP> but I don't know how to start. I got a manual which starts when I have 
DP> already some tables. But I don't have a database yet.
DP> How do I create.

DP> Thank you in advance and I am very sorry about these kind of questions, 
DP> but I will get better.

To start MySQL server you should run safe_mysqld &
You can read more about starting MySQL server at:
http://www.mysql.com/doc/A/u/Automatic_start.html

If you have MySQL server running you can create databases. You can use
CREATE DATABASE statement or mysqladmin utility. You can read about
CREATE DATABASE at:
   http://www.mysql.com/doc/C/R/CREATE_DATABASE.html
About mysqladmin at:
   http://www.mysql.com/doc/m/y/mysqladmin.html

Info about MySQL privilege system will also be useful for you, look
at:
   http://www.mysql.com/doc/P/r/Privileges_options.html
   http://www.mysql.com/doc/P/r/Privileges.html
   http://www.mysql.com/doc/G/R/GRANT.html
   http://www.mysql.com/doc/D/e/Default_privileges.html
   
DP> dcp




-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL privileges

[Victoria Reznichenko]

Felik,
Tuesday, March 26, 2002, 10:11:31 AM, you wrote:

FH> In MySQL, pls tell me which privileges should I grant
FH> to every
FH> user so they can change their password?

They should have grant privilege but it's not right way giving
access to MySQL privilege tables.
You can read more about MySQL privileges at:
http://www.mysql.com/doc/P/r/Privileges_provided.html

FH> thanks
FH> Felik




-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysqlhotcopy

[Martin Waite]

On Tue, 2002-03-26 at 07:24, Hans Kind wrote:
> Dear Martin,
> 
> I tried that option, but it returns a errono 24:
> 
> ../bin/mysqlhotcopy -u username -p password --flushlog --allowold 
> --regexp='.*' /d1/terminal-a/mysql/
> 'mail' is an empty database
> 'opt' is an empty database
> 'oveas' is an empty database
> DBD::mysql::db do failed: Can't find file: 
> './alternat/nuke_bannerfinish.frm' (errno: 24) at ../bin/mysqlhotcopy line 434.
> 
> It creates the directories, but doesn't backup any of the tables.
> 
> In the archives I found similar reports, but it was mentioned the problem 
> was fixed!.
> 
> Not sure how this errono 24 (Error code  24:  Too many open files) relates 
> to this problem.
> 
[snip]

Maybe there are too many open files.

How many tables are there in the set of databases you're
trying to back up ?   I think the error is being thrown when 
attempting to lock all the tables before the copy.  I don't know
how mysql locks tables, but if it use flock (or equivalent) 
that may open one or more files per table.  If you have several 
thousand tables - that may exceed you OS limits.

What gets displayed when you run mysqlhotcopy with the 
'--debug' ( and maybe the '--dryrun' ) flags ?

regards,
Martin



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Enforcing Column Types

[Tino Didriksen]

Question about the CHAR to VARCHAR conversion of:
http://www.mysql.com/doc/S/i/Silent_column_changes.html

Now, I can see the logic in changing most CHAR to VARCHAR if they are long
and variable sized.
I have a column that is VARCHAR(32). I use it to store MD5 hash values. MD5
hashes are always 32 byte.
In other words, that's 1 byte wasted because it's VARCHAR.

With 2500 entries and more on the way, that's at least 2500 byte wasted.

Is there no way to enforce a column type around the silent changes?

-- Tino Didriksen
http://projectjj.dk/


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysql.server

[Gerald Clark]

All init.d  daemons take one of  two options. These are "start" and "stop".
Init supplies the correct option when changiing run levels.
Where the daemon resides varies among versions of  UNIX/Linux.

[EMAIL PROTECTED] wrote:

>>Description:
>>
>regarding mysql.server daemon
>
>>How-To-Repeat:
>>
>I can't seem to find the mysql_daemon_user syntax, per your installation direction 
>via the web
>
>>Fix:
>>
>None
>



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL C API documentation

[Sinisa Milivojevic]

Konstantin Osipov writes:
> * Michael Widenius <[EMAIL PROTECTED]> [02/03/26 12:41]:
> 
> 
> But, according to MYSQL C API documentation, 8.4.2, 
> 
>(http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#C_API_function_overview)
> I have to do this:
> 
> "An advantage of mysql_use_result() is that (...)
> (...)
> Furthermore, you must retrieve all the rows even if you determine in
> mid-retrieval that you've found the information you were looking for."
> 
> Sorry && thank you. 
> 
> -- 
>  WBW, Konstantin Osipov
>  

A small clarification.

Monty has commented  of your  calling mysql_fetch_row() in  Cursor
destructor.

As he said, you do not have to do that, as mysql_free_result   will
clear the remaining rows in the result set from the server. That is
all. 

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Enforcing Column Types

[Keith C. Ivey]

On 26 Mar 2002, at 15:23, Tino Didriksen wrote:

> I have a column that is VARCHAR(32). I use it to store MD5 hash values. MD5
> hashes are always 32 byte.  In other words, that's 1 byte wasted because 
> it's VARCHAR. 
> 
> With 2500 entries and more on the way, that's at least 2500 byte wasted.
> 
> Is there no way to enforce a column type around the silent changes?

It's a reasonable question, but if you're so worried about space that 
2500 bytes is important, why aren't you packing the MD5 values into a 
binary format and avoiding the waste of 16 bytes per record that's 
required to store them as strings of 0-9A-F?

[Filter fodder: SQL, query]

-- 
Keith C. Ivey <[EMAIL PROTECTED]>
Washington, DC

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Boolean Fulltext in 4.0.2 bug

[Sergei Golubchik]

Hi!

On Mar 22, Alexander Belyaev wrote:
> Hi,
> 
> I know, many fulltext bugs fixed last two weeks, thanks!
> But this nice mysql4 feature are critical for us, we plan to use it in many
> projects... and we test it again and again... :)
> 
> My  test case:
> http://www.graphit.ru/fulltext402.tar.gz
> test.res - output from 4.0.2 cloned 2002-03-21.
> 
> With best wishes,
> Alexander
> 
> > Hmm, there were bugs quite similar to this one fixed recently.
> > Can you create a test case ?

Sorry for delay :(
Bug was fixed 2002-03-22.
You may pull to get a bugfix.

Regards,
Sergei

-- 
MySQL Development Team
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
   <___/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Enforcing Column Types

[Paul DuBois]

At 15:23 +0100 3/26/02, Tino Didriksen wrote:
>Question about the CHAR to VARCHAR conversion of:
>http://www.mysql.com/doc/S/i/Silent_column_changes.html
>
>Now, I can see the logic in changing most CHAR to VARCHAR if they are long
>and variable sized.
>I have a column that is VARCHAR(32). I use it to store MD5 hash values. MD5
>hashes are always 32 byte.
>In other words, that's 1 byte wasted because it's VARCHAR.
>
>With 2500 entries and more on the way, that's at least 2500 byte wasted.
>
>Is there no way to enforce a column type around the silent changes?

No.  It makes no sense to do so.

>-- Tino Didriksen
>http://projectjj.dk/


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Enforcing Column Types

[Roger Baklund]

* Paul DuBois
> At 15:23 +0100 3/26/02, Tino Didriksen wrote:
> >Question about the CHAR to VARCHAR conversion of:
> >http://www.mysql.com/doc/S/i/Silent_column_changes.html
> >
> >Now, I can see the logic in changing most CHAR to VARCHAR if
> they are long
> >and variable sized.
> >I have a column that is VARCHAR(32). I use it to store MD5 hash
> values. MD5
> >hashes are always 32 byte.
> >In other words, that's 1 byte wasted because it's VARCHAR.
> >
> >With 2500 entries and more on the way, that's at least 2500 byte wasted.
> >
> >Is there no way to enforce a column type around the silent changes?
>
> No.  It makes no sense to do so.

well... even if 2500 bytes is insignificant, I think his question makes
sense...

The only way I know to enforce CHAR is to make sure all other columns in the
table are of fixed size types... ie not *TEXT, *BLOB or VARCHAR.

--
Roger
query


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Enforcing Column Types

[Paul DuBois]

At 16:55 +0100 3/26/02, Roger Baklund wrote:
>* Paul DuBois
>>  At 15:23 +0100 3/26/02, Tino Didriksen wrote:
>>  >Question about the CHAR to VARCHAR conversion of:
>>  >http://www.mysql.com/doc/S/i/Silent_column_changes.html
>>  >
>>  >Now, I can see the logic in changing most CHAR to VARCHAR if
>>  they are long
>>  >and variable sized.
>>  >I have a column that is VARCHAR(32). I use it to store MD5 hash
>>  values. MD5
>>  >hashes are always 32 byte.
>>  >In other words, that's 1 byte wasted because it's VARCHAR.
>>  >
>>  >With 2500 entries and more on the way, that's at least 2500 byte wasted.
>>  >
>>  >Is there no way to enforce a column type around the silent changes?
>>
>>  No.  It makes no sense to do so.
>
>well... even if 2500 bytes is insignificant, I think his question makes
>sense...
>
>The only way I know to enforce CHAR is to make sure all other columns in the
>table are of fixed size types... ie not *TEXT, *BLOB or VARCHAR.

That's why it doesn't make sense to have just a single column be CHAR.
As soon as a table has even one other variable-length column, the entire
table becomes a variable-length-row table and any advantages of having
fixed-length rows are lost.  Even in the case that a column might always
have 32 bytes, the single-byte advantage that you might get from using a
CHAR are presumably offset by savings in the other variable-length columns.
If the latter is not true, then those columns should be changed to fix-length
types anyway.



>
>--
>Roger
>query


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

SELECT w/LIKE on Swedish character ö finds ], why?

[Philip Semanchuk]

Hi everyone,
I am having a little trouble with searching for Swedish characters. When I
SELECT using LIKE I get matches that I do not expect. I have created a
simple test case that is entirely reproduced below. To summarize, I insert
one row into a single-column table that contains the right square bracket
character (ASCII 0x5d). When I search for the Swedish letter ö (ISO-8859-1
0xf6) I find the row containing the right bracket.

We're running RedHat 7.2 with nothing fancy added in as we're Linux novices
and just playing around with the system to see how it works. MySQL -V
produces this:
mysql  Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)

Here's my test:

mysql> create database swedish_character_test;
Query OK, 1 row affected (0.00 sec)

mysql> use swedish_character_test;
Database changed
mysql> create table simple (name varchar(255) NOT NULL);
Query OK, 0 rows affected (0.00 sec)

mysql> insert into simple (name) values (']');
Query OK, 1 row affected (0.00 sec)

mysql> select name from simple where name like '%ö%';
+--+
| name |
+--+
| ]|
+--+
1 row in set (0.00 sec)


I'd appreciate any help understanding why ö = ] in this case.

Thanks in advance,
Philip

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: SELECT w/LIKE on Swedish character ö finds ], why?

[savaidis]

I have the same problem with Greeks, it is a bug of MySQL.
Try:
1) Create the fields of the table with BINARY option.
2) Use LIKE with BINARY option (slower)
BINARY doesn't make the uppercase convertion.

Makis


> -Original Message-
> From: Philip Semanchuk [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 26, 2002 6:45 PM
> To: '[EMAIL PROTECTED]'
> Subject: SELECT w/LIKE on Swedish character ö finds ], why?
>
>
> Hi everyone,
> I am having a little trouble with searching for Swedish characters. When I
> SELECT using LIKE I get matches that I do not expect. I have created a
> simple test case that is entirely reproduced below. To summarize, I insert
> one row into a single-column table that contains the right square bracket
> character (ASCII 0x5d). When I search for the Swedish letter ö (ISO-8859-1
> 0xf6) I find the row containing the right bracket.
>
> We're running RedHat 7.2 with nothing fancy added in as we're
> Linux novices
> and just playing around with the system to see how it works. MySQL -V
> produces this:
> mysql  Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)
>
> Here's my test:
>
> mysql> create database swedish_character_test;
> Query OK, 1 row affected (0.00 sec)
>
> mysql> use swedish_character_test;
> Database changed
> mysql> create table simple (name varchar(255) NOT NULL);
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> insert into simple (name) values (']');
> Query OK, 1 row affected (0.00 sec)
>
> mysql> select name from simple where name like '%ö%';
> +--+
> | name |
> +--+
> | ]|
> +--+
> 1 row in set (0.00 sec)
>
>
> I'd appreciate any help understanding why ö = ] in this case.
>
> Thanks in advance,
> Philip
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Impact of Free ORACLE

[Jonathan Hilgeman]

Geez, get a grip. You should've counted on the predictable, endless sarcasm
that came as a reply to something that would've been pretty big news, NOT on
only 1 or 2 people pointing out that you're wrong. Most critics here think
that they will be the first or only person to reply, or believe their
sarcasm needs to be heard. 

But this goes as a lesson to everyone - double-check, triple-check, and so
on, before you blurt out something that you heard, even it was from reliable
sources. And if those reliable sources turn out to be wrong, you'd better
begin wondering whether you should listen to them again. This also applies
to the people who just discredited his story without taking the time to do
their own quick research on it, as I'm sure many of you did.

Finally, to everyone who reads this: with such a post, there WILL be someone
out there that responds to it, and you should only need to add your response
after time goes by and either nobody responds to it, or a few people respond
with the wrong answer. Otherwise, you're just going to fill up the list with
sarcastic posts that do nothing but tick off the recipient.

- J

P.S. Try not to curse; it's a bad habit.

-Original Message-
From: MadProfessor [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002 8:11 PM
To: [EMAIL PROTECTED]; 'Charles McGrotty'
Cc: [EMAIL PROTECTED]
Subject: RE: Impact of Free ORACLE


Ok, Ok, KIDZ, I get it. I had just heard from a rather reliable pair of
sources that the oracle system was free, so I thought I'd ask you cats
if you had any thoughts Now I get endless buillshit sarcasm, instead
of the simple 1 or 2 people pointing out that I'm wrong. The rest of you
guys who thought you were being original by giving me shit as if we were
on slashdot need to realize there's no call for all that. I was trying
to find out more about how everyone felt. I still run MySQL on my
servers, and while I was interested in how Oracle works, I wasn't about
to switch, so don't feel like you need to be questioning my geekiness,
nor my interest in free software or open source. End fucking rant, have
a nice day.

VJ MadProfessor


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: SELECT w/LIKE on Swedish character ö finds ], why?

[James Housley]

Philip Semanchuk wrote:
> 
> Hi everyone,
> I am having a little trouble with searching for Swedish characters. When I
> SELECT using LIKE I get matches that I do not expect. I have created a
> simple test case that is entirely reproduced below. To summarize, I insert
> one row into a single-column table that contains the right square bracket
> character (ASCII 0x5d). When I search for the Swedish letter ö (ISO-8859-1
> 0xf6) I find the row containing the right bracket.
> 
> We're running RedHat 7.2 with nothing fancy added in as we're Linux novices
> and just playing around with the system to see how it works. MySQL -V
> produces this:
> mysql  Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)
> 
> Here's my test:
> 
> mysql> create database swedish_character_test;
> Query OK, 1 row affected (0.00 sec)
> 
> mysql> use swedish_character_test;
> Database changed
> mysql> create table simple (name varchar(255) NOT NULL);
> Query OK, 0 rows affected (0.00 sec)
> 
> mysql> insert into simple (name) values (']');
> Query OK, 1 row affected (0.00 sec)
> 
> mysql> select name from simple where name like '%ö%';
> +--+
> | name |
> +--+
> | ]|
> +--+
> 1 row in set (0.00 sec)
> 
> I'd appreciate any help understanding why ö = ] in this case.
> 

If I were to take a wild guess I would say that the lower 7 bits of ö
and ] match.  Which would mean that this isn't really text, ie 7-bit
ASCII, but really BINARY data.  Which means either you need "create
table simple (name varchar(255) BINARY NOT NULL);" or "create table
simple (name tinyblob NOT NULL);"

Give thoses a try.

Jim
-- 
/"\   ASCII Ribbon Campaign  .
\ / - NO HTML/RTF in e-mail  .
 X  - NO Word docs in e-mail .
/ \ -
[EMAIL PROTECTED]  http://www.FreeBSD.org The Power to Serve
[EMAIL PROTECTED]  http://www.TheHousleys.net
[EMAIL PROTECTED]  http://www.SimTel.Net
-
Progress (n) : What led from smart users in front of dumb terminals to
dumb users in front of smart terminals.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: SELECT w/LIKE on Swedish character ö finds ], why?

[Philip Semanchuk]

THanks Makis, is this bug documented anywhere?

> -Original Message-
> From: savaidis [mailto:[EMAIL PROTECTED]]
> Sent: den 26 mars 2002 18:04
> To: Philip Semanchuk; [EMAIL PROTECTED]
> Subject: RE: SELECT w/LIKE on Swedish character ö finds ], why?
> 
> 
> I have the same problem with Greeks, it is a bug of MySQL.
> Try:
> 1) Create the fields of the table with BINARY option.
> 2) Use LIKE with BINARY option (slower)
> BINARY doesn't make the uppercase convertion.
> 
> Makis
> 
> 
> > -Original Message-


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: SELECT w/LIKE on Swedish character ö finds ], why?

[Philip Semanchuk]

> If I were to take a wild guess I would say that the lower 7 bits of ö
> and ] match.  Which would mean that this isn't really text, ie 7-bit
> ASCII, but really BINARY data.  Which means either you need "create
> table simple (name varchar(255) BINARY NOT NULL);" or "create table
> simple (name tinyblob NOT NULL);"

Jim,
Thanks for the suggestion, but I already checked that and got no joy -- 

ö = 0xf6 = 0110
] = 0x5d = 01011101

Philip

> -Original Message-
> From: James Housley [mailto:[EMAIL PROTECTED]]
> Sent: den 26 mars 2002 18:06
> To: Philip Semanchuk
> Cc: '[EMAIL PROTECTED]'
> Subject: Re: SELECT w/LIKE on Swedish character ö finds ], why?
> 
> 
> Philip Semanchuk wrote:
> > 
> > Hi everyone,
> > I am having a little trouble with searching for Swedish 
> characters. When I
> > SELECT using LIKE I get matches that I do not expect. I 
> have created a
> > simple test case that is entirely reproduced below. To 
> summarize, I insert
> > one row into a single-column table that contains the right 
> square bracket
> > character (ASCII 0x5d). When I search for the Swedish 
> letter ö (ISO-8859-1
> > 0xf6) I find the row containing the right bracket.
> > 
> > We're running RedHat 7.2 with nothing fancy added in as 
> we're Linux novices
> > and just playing around with the system to see how it 
> works. MySQL -V
> > produces this:
> > mysql  Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)
> > 
> > Here's my test:
> > 
> > mysql> create database swedish_character_test;
> > Query OK, 1 row affected (0.00 sec)
> > 
> > mysql> use swedish_character_test;
> > Database changed
> > mysql> create table simple (name varchar(255) NOT NULL);
> > Query OK, 0 rows affected (0.00 sec)
> > 
> > mysql> insert into simple (name) values (']');
> > Query OK, 1 row affected (0.00 sec)
> > 
> > mysql> select name from simple where name like '%ö%';
> > +--+
> > | name |
> > +--+
> > | ]|
> > +--+
> > 1 row in set (0.00 sec)
> > 
> > I'd appreciate any help understanding why ö = ] in this case.
> > 
> 
> If I were to take a wild guess I would say that the lower 7 bits of ö
> and ] match.  Which would mean that this isn't really text, ie 7-bit
> ASCII, but really BINARY data.  Which means either you need "create
> table simple (name varchar(255) BINARY NOT NULL);" or "create table
> simple (name tinyblob NOT NULL);"
> 
> Give thoses a try.
> 
> Jim
> -- 
> /"\   ASCII Ribbon Campaign  .
> \ / - NO HTML/RTF in e-mail  .
>  X  - NO Word docs in e-mail .
> / \ -
> [EMAIL PROTECTED]  http://www.FreeBSD.org The Power to Serve
> [EMAIL PROTECTED]  http://www.TheHousleys.net
> [EMAIL PROTECTED]  http://www.SimTel.Net
> -
> Progress (n) : What led from smart users in front of dumb terminals to
> dumb users in front of smart terminals.
> 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Importing Tables Data into MySQL from Access

[Thomas Edison Jr.]

Hi,

I'm looking to Import complete MS Access Table with
Data into a MySQL Database. How can i do that?
Especially if i have to do it for a site on the
internet...

Thanks,
T. Edison Jr.


__
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

ERROR 2002: Can't connect to local MySQL server through socket'/tmp/mysql.sock' (2)

[Mike Yrabedra]

What would cause this error to occur all of a sudden?

ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)

Server: Mac OS X 10.1.3






> -
> Before posting, please check:
>  http://www.mysql.com/manual.php   (the manual)
>  http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 

-- 
Mike Yrabedra
[EMAIL PROTECTED]
http://www.macsurfshop.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Importing Tables Data into MySQL from Access

[Thomas Edison Jr.]

I actually tried this just a few moments ago and it
worked! But thanks!

T. Edison jr.


--- Andrew Hazen <[EMAIL PROTECTED]> wrote:
> Print out a "documentation" of the Access database. 
> Use phpMyAdmin
> interface to build the same table structures in
> MySql.
> 
> Export Access tables as comma separated values
> files.
> 
> Use phpMyAdmin to insert text files into each table.
> 
> 
> Voila!
> 
> Andrew Hazen
> -Original Message-
> From: Thomas Edison Jr.
> [mailto:[EMAIL PROTECTED]] 
> Sent: Tuesday, March 26, 2002 12:52 PM
> To: [EMAIL PROTECTED]
> Subject: Importing Tables Data into MySQL from
> Access
> 
> Hi,
> 
> I'm looking to Import complete MS Access Table with
> Data into a MySQL Database. How can i do that?
> Especially if i have to do it for a site on the
> internet...
> 
> Thanks,
> T. Edison Jr.
> 
> 
> __
> Do You Yahoo!?
> Yahoo! Movies - coverage of the 74th Academy Awards®
> http://movies.yahoo.com/
> 
>
-
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list
> archive)
> 
> To request this thread, e-mail
> <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
>
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
> 


=
Rahul S. Johari (Director)
**
Abraxas Technologies Inc.
Homepage : http://www.abraxastech.com
Email : [EMAIL PROTECTED]
Tel : 91-4546512/4522124
***

__
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mySQL System config ... jumbo db size

[Jon Shoberg]

Any suggestions on how to pull off the following ...

I'd like to setup a box to function primarily as a database server.
Secondary functions will be running some java applications, basic apache web
server.  My intent is to use mySQL as the db behind a small web search
engine. I'll certainly be giving its full text indexing a good workout.
>From a hardware standpoint I'll probably use a raid setup of a few hundred
GB.  IDE storage space is getting cheaper now days.  I'm mostly concerned
about file system limitations from the OS angle and mySQL's table size
limitations  and how everything comes together in one system 

This is primarily a research interest, nothing major.  Any thoughts or
comments would certainly be appreciated.


Thanks
jon


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Single DB trying to replicate to itself?

[Jonathan Wilzig]

RH 7.2.
mysql-3.23.44

I have a single server running mysql. I have added one database I use. For
some unknown reason, it appears that mysql is trying to replicate to
something, failing and causing mysql to stop responding almost daily.
/etc/my.cnf has no reference to any master/slave or replication options. I
am thoroughly confused. Any help would be appreciated. My hostname.err log
is filled with lines like this (about 1 per minute)


020326 10:18:58  Slave thread: error connecting to master: Unknown MySQL
Server Host '' (4) (107), retry in 60 sec

Thanks in advance.

-
Jonathan Wilzig
Wireless Services Corp.
[EMAIL PROTECTED]



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

[colin o]

Same thing happens to me, 

i just use bin/safe_mysqld --user=root &
to start to server so that i can use mysql.
I don't know exactly why it happens though. 
Possibly permissions??

Colin

--- Mike Yrabedra <[EMAIL PROTECTED]> wrote:
> 
> What would cause this error to occur all of a
> sudden?
> 
> ERROR 2002: Can't connect to local MySQL server
> through socket
> '/tmp/mysql.sock' (2)
> 
> Server: Mac OS X 10.1.3
> 
> 
> 
> 
> 
> 
> >
>
-
> > Before posting, please check:
> >  http://www.mysql.com/manual.php   (the manual)
> >  http://lists.mysql.com/   (the list
> archive)
> > 
> > To request this thread, e-mail
> <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> >
>
<[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
> > 
> 
> -- 
> Mike Yrabedra
> [EMAIL PROTECTED]
> http://www.macsurfshop.com
> 
> 
>
-
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list
> archive)
> 
> To request this thread, e-mail
> <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
>
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
> 


__
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Trapping for no user input in a query

[Ron Jamison]

Kim,

See the Pattern Matching section of the manual at:
  http://www.mysql.com/doc/P/a/Pattern_matching.html

A "_" matches any single character, while a "%" acts as a wildcard
match.

-Original Message-
From: Kim Kohen [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, March 26, 2002 2:36 AM
To: <[EMAIL PROTECTED]>
Subject: Re: Trapping for no user input in a query


G'day Ron, all

> Tailor your query to the request of your user(s).
> if ($param1)
> $sql .= "(ad_copy) against ('$param1')";
> if ($param1 && $param2)
ˆ
Thank you for your reply.  If at all possible though, I'd like to do it
from the mysql side rather than the php side of things.

Is there such a thing as a wildcard character that can be used with a
fulltext index that will return all rows?

cheers

kim



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Adding a Column to an existing table

[Ulrik Witschass]

Hi, I'm new to this list, hopefully, I can contribute some wisdom :)

At the moment, I have to update a large database to be multi-company-ready,
so I basically have to add a Column "Company_ID" to nearly each table.

What would be the easiest way to do this?

I already thought about running a "SELECT *" Query for each table, saving
the result in an Array (in PHP, btw, it's a webapplication), dropping the
table, creating the new table and looping through the data to insert the
data again. Problem is, that this puts a heavy task on the server, I tried
it on a local "crash"-server, and even with carefully planned setting and
unsetting of the arrays, it eats up the RAM since the arrays just get damn
big. And since I have to remote control the server and it is important that
the server is online nearly 24/7, I risk to crash the server without having
the physical option to reboot it until the next morning...a few hundred
kilometres away from my workplace...

Now I am looking into two things:

1) is there some kind of "MODIFY" query I can run???

2) or is it possible to dumb the database, drop it, create the new structure
and then write the dumb back in with some options that it ignores the
"CREATE TABLE" queries and that it doesn't check if the count of the values
matches the count of the columns? (error I get when I try to do it at the
moment).

3) another way...

As you can see, I am not THAT experienced with MySQL, so any help is greatly
appreciated!!!

Ulrik


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Adding a Column to an existing table

[Andrew Hazen]

How are you determining the value to put in the Company_Id field? You
can use phpMyAdmin to easily add a column with a default/no null setting
to your tables to get you started. (It uses a MODIFY command I believe).

If you have the logic for determining the values of Company_ID, you
could do as you have suggested, but in multiple runs using LIMIT, or by
specifying incrementing ranges of the primary key for each table, so
that you don't blow out your RAM. Takes longer, but shouldn't crash your
server.

Andrew Hazen

-Original Message-
From: Ulrik Witschass [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, March 26, 2002 3:33 PM
To: [EMAIL PROTECTED]
Subject: Adding a Column to an existing table

Hi, I'm new to this list, hopefully, I can contribute some wisdom :)

At the moment, I have to update a large database to be
multi-company-ready,
so I basically have to add a Column "Company_ID" to nearly each table.

What would be the easiest way to do this?

I already thought about running a "SELECT *" Query for each table,
saving
the result in an Array (in PHP, btw, it's a webapplication), dropping
the
table, creating the new table and looping through the data to insert the
data again. Problem is, that this puts a heavy task on the server, I
tried
it on a local "crash"-server, and even with carefully planned setting
and
unsetting of the arrays, it eats up the RAM since the arrays just get
damn
big. And since I have to remote control the server and it is important
that
the server is online nearly 24/7, I risk to crash the server without
having
the physical option to reboot it until the next morning...a few hundred
kilometres away from my workplace...

Now I am looking into two things:

1) is there some kind of "MODIFY" query I can run???

2) or is it possible to dumb the database, drop it, create the new
structure
and then write the dumb back in with some options that it ignores the
"CREATE TABLE" queries and that it doesn't check if the count of the
values
matches the count of the columns? (error I get when I try to do it at
the
moment).

3) another way...

As you can see, I am not THAT experienced with MySQL, so any help is
greatly
appreciated!!!

Ulrik


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Adding a Column to an existing table

[Brad Visscher]

Run the following for each table:

ALTER TABLE tableName ADD COLUMN Company_ID INT UNSIGNED NULL;

Hope this helps.



Ulrik Witschass wrote:

>Hi, I'm new to this list, hopefully, I can contribute some wisdom :)
>
>At the moment, I have to update a large database to be multi-company-ready,
>so I basically have to add a Column "Company_ID" to nearly each table.
>
>What would be the easiest way to do this?
>
>I already thought about running a "SELECT *" Query for each table, saving
>the result in an Array (in PHP, btw, it's a webapplication), dropping the
>table, creating the new table and looping through the data to insert the
>data again. Problem is, that this puts a heavy task on the server, I tried
>it on a local "crash"-server, and even with carefully planned setting and
>unsetting of the arrays, it eats up the RAM since the arrays just get damn
>big. And since I have to remote control the server and it is important that
>the server is online nearly 24/7, I risk to crash the server without having
>the physical option to reboot it until the next morning...a few hundred
>kilometres away from my workplace...
>
>Now I am looking into two things:
>
>1) is there some kind of "MODIFY" query I can run???
>
>2) or is it possible to dumb the database, drop it, create the new structure
>and then write the dumb back in with some options that it ignores the
>"CREATE TABLE" queries and that it doesn't check if the count of the values
>matches the count of the columns? (error I get when I try to do it at the
>moment).
>
>3) another way...
>
>As you can see, I am not THAT experienced with MySQL, so any help is greatly
>appreciated!!!
>
>Ulrik
>
>
>-
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: ERROR 2002: Can't connect to local MySQL server through socket'/tmp/mysql.sock' (2)

[andy thomas]

On Tue, 26 Mar 2002, colin o wrote:

> Same thing happens to me,
>
> i just use bin/safe_mysqld --user=root &
> to start to server so that i can use mysql.
> I don't know exactly why it happens though.
> Possibly permissions??

It is better to run mysqld as a non-root user, such as mysql.

> --- Mike Yrabedra <[EMAIL PROTECTED]> wrote:
> >
> > What would cause this error to occur all of a
> > sudden?
> >
> > ERROR 2002: Can't connect to local MySQL server
> > through socket
> > '/tmp/mysql.sock' (2)

Is the socket? It should show up in a directory listing of /tmp - if it
isn't there then mysqld isn't running.

Andy


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

$basedir

[Jörn Meyburg]

SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: root
To: [EMAIL PROTECTED]
Subject: mysql doesn't find symbolically linked directory
>Description:
mysqld_safe doesn't find symbolically linked directory, see following error
message and directory list from /usr/local
020324 14:38:06 mysqld started
/usr/local/mysql/bin/mysqld: Fatal error: Can't find messagefile
'mysql-max-4.0.1-alpha-pc-linux-gnu-686/share/mysql/english/errmsg.sys'
020324 14:38:06 Aborting
lrwxrwxrwx 1 root mysql 39 Mar 24 11:53 mysql ->
mysql-max-4.0.1-alpha-pc-linux-gnu-i686
drwxrwxr-x 13 mysql mysql 516 Dec 23 16:45
mysql-max-4.0.1-alpha-pc-linux-gnu-i686
drwxr-xr-x 2 root root 35 Jan 18 2001 share
>How-To-Repeat: See local fix
>Fix: In mysql.server script set $basedir=/usr/local/mysql-VERSION-OS
directory. If basedir=/usr/local/mysql error reproduceable.
>Submitter-Id: [EMAIL PROTECTED]
>Originator: root
>Organization:
Joern Meyburg System Software Beratung
Kocherstrasse 7
D-45219 Essen
Germany
>MySQL support: none
>Synopsis: $basedir
>Severity: non-critical
>Priority: low
>Category: mysql
>Class: sw-bug | doc-bug
>Release: mysql-4.0.1-alpha-max (Official MySQL-max binary)
>Environment:
Pentium III 1.0 Ghz 256 MB memory, 20GB HD
System: Linux medion 2.4.14 #4 SMP Fri Jan 25 19:45:34 CET 2002 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.2/specs
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc'
CXXFLAGS='-O3 -mpentium -felide-constructors' LDFLAGS='-static'
LIBC:
lrwxrwxrwx 1 root root 13 Oct 28 14:20 /lib/libc.so.4 -> libc.so.4.7.6
-rwxr-xr-x 1 root root 634880 Apr 29 1996 /lib/libc.so.4.7.6
-rwxr-xr-x 1 root root 1382179 Jan 19 2001 /lib/libc.so.6
-rw-r--r-- 1 root root 2585872 Jan 19 2001 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Jan 19 2001 /usr/lib/libc.so
-rw-r--r-- 1 root root 851660 Jan 19 2001 /usr/lib/libc-client.a
lrwxrwxrwx 1 root root 19 Oct 28 14:26 /usr/lib/libc-client.so ->
libc-client.so.2000
-rwxr-xr-x 1 root root 714876 Jan 19 2001 /usr/lib/libc-client.so.2000
Configure command: ./configure --prefix=/usr/local/mysql
'--with-comment=Official MySQL-max
binary' --with-extra-charsets=complex --with-server-suffix=-max --enable-thr
ead-safe-client --enable-assembler --with-mysqld-ldflags=-all-static --with-
client-ldflags=-all-static --disable-shared --with-berkeley-db --with-innodb



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Adding a Column to an existing table

[Steven Gearhart]

The easiest way to add a column is to get somebody else to do it.

Seriously, Use the "ALTER TABLE TableName ADD COLUMN Company_id INT UNSIGNED
NULL" command.
This syntax may be found in the MySQL manual in 6.5.4
http://www.mysql.com/doc/A/L/ALTER_TABLE.html ,or page 428 if you have
downloaded the "pdf" version.

I hope I have been of help. - Steve G.


-Original Message-
From: Ulrik Witschass [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 3:33 PM
To: [EMAIL PROTECTED]
Subject: Adding a Column to an existing table


Hi, I'm new to this list, hopefully, I can contribute some wisdom :)

At the moment, I have to update a large database to be multi-company-ready,
so I basically have to add a Column "Company_ID" to nearly each table.

What would be the easiest way to do this?

I already thought about running a "SELECT *" Query for each table, saving
the result in an Array (in PHP, btw, it's a webapplication), dropping the
table, creating the new table and looping through the data to insert the
data again. Problem is, that this puts a heavy task on the server, I tried
it on a local "crash"-server, and even with carefully planned setting and
unsetting of the arrays, it eats up the RAM since the arrays just get damn
big. And since I have to remote control the server and it is important that
the server is online nearly 24/7, I risk to crash the server without having
the physical option to reboot it until the next morning...a few hundred
kilometres away from my workplace...

Now I am looking into two things:

1) is there some kind of "MODIFY" query I can run???

2) or is it possible to dumb the database, drop it, create the new structure
and then write the dumb back in with some options that it ignores the
"CREATE TABLE" queries and that it doesn't check if the count of the values
matches the count of the columns? (error I get when I try to do it at the
moment).

3) another way...

As you can see, I am not THAT experienced with MySQL, so any help is greatly
appreciated!!!

Ulrik


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

phpMyAdmin issue + looking for php/mysql websites

[catriona grisewood]

when i try to create a database i get the message

 "The specified CGI application misbehaved by not
returning a complete set of HTTP headers. The headers
it did return are:"

I dont think i set up mySQL properly maybe ?

Any ideas?

ps

does anywone know of a brilliant website for learning
php and mysql apart from the official websites ?


__
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: SELECT w/LIKE on Swedish character ö finds ], why?

[Ken Menzel]

Hi Philip,
  before running your test next time try this:

vi /etc/my.cnf

insert into this file:

[mysqld]
default-character-set  = swe7

then stop mysql (mysqladmin shutdown)

and restart (safe_mysqld&)

then try your test again.  It worked fine for me.

Ken


> Philip Semanchuk wrote:
> >
> > Hi everyone,
> > I am having a little trouble with searching for Swedish
characters. When I
> > SELECT using LIKE I get matches that I do not expect. I have
created a
> > simple test case that is entirely reproduced below. To summarize,
I insert
> > one row into a single-column table that contains the right square
bracket
> > character (ASCII 0x5d). When I search for the Swedish letter ö
(ISO-8859-1
> > 0xf6) I find the row containing the right bracket.
> >
> > We're running RedHat 7.2 with nothing fancy added in as we're
Linux novices
> > and just playing around with the system to see how it works.
MySQL -V
> > produces this:
> > mysql  Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)
> >
> > Here's my test:
> >
> > mysql> create database swedish_character_test;
> > Query OK, 1 row affected (0.00 sec)
> >
> > mysql> use swedish_character_test;
> > Database changed
> > mysql> create table simple (name varchar(255) NOT NULL);
> > Query OK, 0 rows affected (0.00 sec)
> >
> > mysql> insert into simple (name) values (']');
> > Query OK, 1 row affected (0.00 sec)
> >
> > mysql> select name from simple where name like '%ö%';
> > +--+
> > | name |
> > +--+
> > | ]|
> > +--+
> > 1 row in set (0.00 sec)
> >
> > I'd appreciate any help understanding why ö = ] in this case.



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: phpMyAdmin issue + looking for php/mysql websites

[Andreas Frøsting]

>  "The specified CGI application misbehaved by not
> returning a complete set of HTTP headers. The headers
> it did return are:"

Looks like you're running phpMyAdmin on a machine with Windows and PHP
in CGI-mode?
I don't recall if it's PHP in CGI-mode on Windows that in general
doesn't work with the header()-function or if it's only IIS.

The solution is to install PHP as non-cgi... Don't know how that is done
as I'm using FreeBSD, but know you know whats wrong :)

> I dont think i set up mySQL properly maybe ?

The problem is not related to MySQL.

:wq
//andreas
http://phpwizard.dk/ (in Danish only)


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Query causes Mysql to shut down

[Richard Prangnell]

Dear sirs,

I have a situation on my local Windows development platform that is causing
the mysql daemon to shut down. I cannot recreate the problem on the web
server, which is Linux.

The error message (on Windows) is:

MYSQLD-OPT caused an invalid page fault in
module MYSQLD-OPT.EXE at 017f:00460912.
Registers:
EAX= CS=017f EIP=00460912 EFLGS=00010206
EBX=018bf5fc SS=0187 ESP=018bf578 EBP=0003
ECX=0003 DS=0187 ESI= FS=5527
EDX=0003 ES=0187 EDI=018bf60f GS=
Bytes at CS:EIP:
f3 a4 01 6b 04 5f 5e 5d 33 c0 5b c2 08 00 53 55
Stack dump:
00a1c189 018bf5fc  00a1c162 00420801  0003 
01446c20  00a1c9a4 00a1c1bc bff7b9c5 00a1c18c 0028 004be901

The query that seems to be 'tender' is:

SELECT advert_id, uid, uname, teaser, bodytext,
  DATE_FORMAT(upload_date, '%d %b %y'), cat_id,
  DATE_FORMAT(expiry_date, '%d %b %y'), expiry_flag
  FROM mod_adverts
  WHERE cat_id = $cat_id
  AND expiry_flag = 0
  OR cat_id = $cat_id
AND expiry_flag = 1
AND expiry_date > 'datetime(now())'
  ORDER BY advert_id DESC

Now for details of my setup:

Hardware: CyrixInstead Cyrix MII (266Mhz) 80Mb RAM
OS: Microsoft Windows 98 Series II 4.10. A
Web Server: Apache 1.3.20 (Win32) PHP/4.0.6
MySQL: WinMySQLAdmin Ver 1.3

If it is my SQL query that is not quite right, I would have thought that I
would have received a different kind of error message - one that doesn't
choke the server?

Any help with this would be most welcome.

Yours sincerely


Richard Prangnell

www.praggers.com



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysql password

[Norman Zhang]

Hi,

I have a table with username and password. The password is encrypted using
mySQL's password function. But when I try to perform a match using PHP,
e.g.,

$query = "select count(*) from auth
 where usrname='$logname' and usrpass=password('$logpass')";

$result = mysql_query($query) or exit ("Cannot run query.");

$count = mysql_result($result, 0, 0);

if ($count > 0)
{
  echo "Success";
  die();
}
else
{
  echo "Unsuccess";
  die();
}

I always get "Unsuccess". It seems password() does not give the same result.
Would someone please point out what I am doing wrong here?

Regards,
Norman



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: query help

[Chuck Barnett]

- Original Message -
From: <[EMAIL PROTECTED]>
To: "Chuck Barnett" <[EMAIL PROTECTED]>
Sent: Tuesday, March 26, 2002 2:09 PM
Subject: Re: query help


> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
>
> If you just reply to this message, and include the entire text of it in
the
> reply, your reply will go through. However, you should
> first review the text of the message to make sure it has something to do
> with MySQL. Just typing the word MySQL once will be sufficient, for
example.
>
> You have written the following:
>
> Hi, I have a db field that holds the first and last name of a person.  Is
> there a way to sort by the last name in that field?
> The whole reason for this is to populate a select box sorted by last name.
>
> I don't want to go back and create a separate field if I don't have to.
>
> Thanks,
> Chuck
>
>
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: phpMyAdmin issue + looking for php/mysql websites

[Hathaway, Scott L]

I use PHP (cgi) with IIS and phpMyAdmin.  The problem with the header
function is just that a couple of the .inc files with phpMyAdmin need to
have the extra lines after the ?> deleted.  But, that message says that the
headers have already been sent out.  The error below usually means a 404
error if you are using a template.  If not, it usually means that you have
forgotten something like a curly brace or a script ending.

Post your code and it will be easier to help.

Scott

-Original Message-
From: Andreas Frøsting [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 2:27 PM
To: 'catriona grisewood'; [EMAIL PROTECTED]
Subject: RE: phpMyAdmin issue + looking for php/mysql websites


>  "The specified CGI application misbehaved by not
> returning a complete set of HTTP headers. The headers
> it did return are:"

Looks like you're running phpMyAdmin on a machine with Windows and PHP
in CGI-mode?
I don't recall if it's PHP in CGI-mode on Windows that in general
doesn't work with the header()-function or if it's only IIS.

The solution is to install PHP as non-cgi... Don't know how that is done
as I'm using FreeBSD, but know you know whats wrong :)

> I dont think i set up mySQL properly maybe ?

The problem is not related to MySQL.

:wq
//andreas
http://phpwizard.dk/ (in Danish only)


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

load data infile question

[Harpreet Kaur]

I want to transfer data from a table in sql server to mysql. I use
C:\>   BCP dbname.dbo.tblname out tblname.txt -S srvrname -U sa –P sapwd -c
-t \t -r \n
to write the data to a text file and then use
load data infile ‘/var/www/html/tblname.txt'  into table tblname;

It works fine for all the tables except this one table which has
description field with several lines. It assumes each line as a seperate
field rather then one field and so create errors.

Please help.

Regards Harpreet


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

[Newbie] MATCH and INDEX question (using a JOIN in a MATCHstatement)

[Dan Tappin]

This is a follow-up to a MySQL keyword text search question I had answer a
few days ago.

I have table 'main' which has two INT columns 'maincat' and 'subcat' which
hold an index number from to other tables maincat and subcat.  These table
each hold descriptive names ('name') for each of the main categories and sub
categories.

I have no problem using MATCH to search the various fields of 'main' using
an INDEX.  The problem is I want to create a search across the related
'name' fields of the other two tables.

Here is what I have so far:

select main.id, description, maincat.name, subcat.name from main LEFT JOIN
clients ON forsale.clientid=clients.id WHERE MATCH (description) AGAINST
('keywords')

This works but I can only MATCH in the columns of 'main'.

Now my first thought was to try this:

select main.id, description, maincat.name, subcat.name from main LEFT JOIN
clients ON forsale.clientid=clients.id WHERE MATCH (description,
maincat.name, subcat.name) AGAINST ('keywords')

Which results in an error.

Can anyone tell me if I can do this using MATCH?

Thanks,

Dan


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: phpMyAdmin issue + looking for php/mysql websites

[catriona grisewood]

Im not sure what way php is installed as it was
already installed on the server here. How i got this
message exactly was
when i opened up MyphpMyAdmin after just installing
it. I go to create a new datbase and thats when the
error page comes up. Could it be i dont have the
config file setup correctly ? or maybe MySQL isnt
configured correctly ?

i dont know if that helps ?

Thanks for any help
--- "Hathaway, Scott L" <[EMAIL PROTECTED]>
wrote:
> I use PHP (cgi) with IIS and phpMyAdmin.  The
> problem with the header
> function is just that a couple of the .inc files
> with phpMyAdmin need to
> have the extra lines after the ?> deleted.  But,
> that message says that the
> headers have already been sent out.  The error below
> usually means a 404
> error if you are using a template.  If not, it
> usually means that you have
> forgotten something like a curly brace or a script
> ending.
> 
> Post your code and it will be easier to help.
> 
> Scott
> 
> -Original Message-
> From: Andreas Frøsting [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 26, 2002 2:27 PM
> To: 'catriona grisewood'; [EMAIL PROTECTED]
> Subject: RE: phpMyAdmin issue + looking for
> php/mysql websites
> 
> 
> >  "The specified CGI application misbehaved by not
> > returning a complete set of HTTP headers. The
> headers
> > it did return are:"
> 
> Looks like you're running phpMyAdmin on a machine
> with Windows and PHP
> in CGI-mode?
> I don't recall if it's PHP in CGI-mode on Windows
> that in general
> doesn't work with the header()-function or if it's
> only IIS.
> 
> The solution is to install PHP as non-cgi... Don't
> know how that is done
> as I'm using FreeBSD, but know you know whats wrong
> :)
> 
> > I dont think i set up mySQL properly maybe ?
> 
> The problem is not related to MySQL.
> 
> :wq
> //andreas
> http://phpwizard.dk/ (in Danish only)
> 
> 
>
-
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list
> archive)
> 
> To request this thread, e-mail
> <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
>
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php


__
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Impact of Free ORACLE

[Francesca Shiekh]

At 02:20 AM 3/26/2002 +, [EMAIL PROTECTED] wrote:
>Here is what the MadProfessor needs to do:
>
>1. Contact you local Oracle Marketing Rep. He will set
>you straight on licensing and pricing.
>
>2. Go read the Oracle9iAS Data Sheet. Notice that they
>use Apache and throw in couple of their own candy
>wrappers called "mods".
>
>Oracle9iAS does not include the Oracle Database. And oh
>yes, Wireless & Personalization enablement is not
>included. That is extra!
>
>I think the CD ROM is free! Tongue in cheek.

Usually there is a media charge so I don't think the CD ROM is free either! ;o)


>John Wubbel
>John Wubbel Consulting
> > Being a Oracle Database Admin myself, I have to say that MySQL is far
> > better, it is just as fast when configured right, just as flexiable when
> > the scripting is done right and the real icing on the cake is it is
> > HONESTLY, TRUTHFULLY, TOTALLY FREE!
> >
> > If I could I would make the place where I work switch over, I am a great
> > lover of Open Source, forget ASP, IIS, and all the other Micro$oft
> > gimmics that are opperable on one platform, these are just cheap stunt
> > marketing tools. Granted Oracle is available on multiple platforms. But
> > take it from me, once you have had a serious look at Oracle and you find
> > you have to set memory allocation after memory allocation for every
> > little piece of the DB, you soon lose the desire to set up additional
> > databases.
> >
> > As I said, I do this for a living, and if the MySQL market was as big
> > (moneywise) I would leave the Oracle realm in a heart beat.
> >
> > Besides, I recently read an article on a benchmark test of several of
> > the top leading databases conducted by Zif Davis, you know that large
> > computer magazine corp, those guys do not bow down to M$, Oracle or any
> > of the other big names, they report the facts as they find them,
> > regardless of the name.
> >
> > Read more about this here:
> > http://www.eweek.com/article/0,3658,s=708&a=23115,00.asp
> >
> > So to be honest, I (again let me point out that I KNOW what I am talking
> > about) see little or NO danger for MySQL v's Oracle, and as I just read
> > in a email sent to this list, Oracle chances is pricing repeatedly one
> > moment it was per seat, then it was per processing power of the system
> > and the story goes on.
> >
> > Oracle is NOT, nor will it be FREE any time soon, and I am talking
> > YEARS!
> >
> > Regards,
> >
> >
> > -
> >
> > Charles McGrotty
> > Intelliweb Technologies,
> >
> > You know you want IT?
> > Visit Intelliweb Technologies for
> > all your hosting requirements.
> >
> > http://www.intelliwebtech.com
> >
> >
> >
> >
> > -Original Message-
> > From: Francesca Shiekh [mailto:[EMAIL PROTECTED]]
> > Sent: 25 March 2002 18:56
> > To: MadProfessor; 'Richard Forgo'; [EMAIL PROTECTED]
> > Subject: RE: Impact of Free ORACLE
> >
> >
> > At 05:29 PM 3/25/2002 -0600, MadProfessor wrote:
> > >Here's a couple I've dug up:
> > >
> > >http://biz.yahoo.com/prnews/020117/sfth035_1.html
> > >http://www.devx.com/judgingjava/articles/javaone/report2.asp (Flat out
> > >SAYS ORACLE IS FREE!)
> >
> > I took a quick look at this site and I don't see anything that says the
> > database is free...
> > I can find Oracle 9iAS downloadable for free... that's the Application
> > Server, you then need the Database to go with it...
> >
> > Moreover, I wouldn't trust using it for production... Oracle has a
> > history
> > of changing the pricing on people and claiming that you have to pay more
> >
> > money if you want to continue using their product because the licensing
> > changed...
> >
> > They may give it to you free this year, next year you'll find yourself
> > with
> > a large bill!
> >
> > Just read these:
> > http://www.idg.net.nz/pressroom.nsf/UNID/8DCAE02D7BD89FD6CC256B8100822FB
> > 0!opendocument
> > http://www.newsbytes.com/news/02/175426.html
> > http://www.crmdaily.com/perl/story/16852.html
> > http://news.com.com/2100-1001-864135.html
> >
> > There are many more...
> >
> > I think MySql is here to stay even if Larry should decide to give it all
> >
> > away for free... database, applications etc. There are always the
> > consulting and support fees, and anyone who worked with Oracle Apps
> > knows
> > you can't do a damn thing without support! ..And if you want to take
> > less
> > than 5 years to implement the system you better have consultants on
> > board
> > and a staff of 2 people per module in house!
> >
> > $0.02 as someone else put it...
> >
> > Francesca
> >
> >
> > >And of course, let's not forget
> > >http://www.oracle.com (Just go to downloads, register your info and try
> >
> > >downloading ANYTHING)
> > >
> > >
> > >I PROMISE YOU, oh non believers, that you'll believe me after you read
> > >those articles, and then try downloading 9i from Oracle. You don't even
> >
> > >have to download it, just start it and watch it go! Cheers,
> > >VJ MPZ
> > >-Original Message-
>

RE: phpMyAdmin issue + looking for php/mysql websites

[catriona grisewood]

when im connecting to an online MySQL server do i just
put in the server name ie 'orac'in the config file or
do i need to put in its ip address etc with it ?
--- "Hathaway, Scott L" <[EMAIL PROTECTED]>
wrote:
> I use PHP (cgi) with IIS and phpMyAdmin.  The
> problem with the header
> function is just that a couple of the .inc files
> with phpMyAdmin need to
> have the extra lines after the ?> deleted.  But,
> that message says that the
> headers have already been sent out.  The error below
> usually means a 404
> error if you are using a template.  If not, it
> usually means that you have
> forgotten something like a curly brace or a script
> ending.
> 
> Post your code and it will be easier to help.
> 
> Scott
> 
> -Original Message-
> From: Andreas Frøsting [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 26, 2002 2:27 PM
> To: 'catriona grisewood'; [EMAIL PROTECTED]
> Subject: RE: phpMyAdmin issue + looking for
> php/mysql websites
> 
> 
> >  "The specified CGI application misbehaved by not
> > returning a complete set of HTTP headers. The
> headers
> > it did return are:"
> 
> Looks like you're running phpMyAdmin on a machine
> with Windows and PHP
> in CGI-mode?
> I don't recall if it's PHP in CGI-mode on Windows
> that in general
> doesn't work with the header()-function or if it's
> only IIS.
> 
> The solution is to install PHP as non-cgi... Don't
> know how that is done
> as I'm using FreeBSD, but know you know whats wrong
> :)
> 
> > I dont think i set up mySQL properly maybe ?
> 
> The problem is not related to MySQL.
> 
> :wq
> //andreas
> http://phpwizard.dk/ (in Danish only)
> 
> 
>
-
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list
> archive)
> 
> To request this thread, e-mail
> <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
>
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php


__
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: query help

[Christopher Thompson]

[For the spam-bot:  Go away, you annoying little beast.  You know I'm not 
posting spam so stop querying me about it and let's get back to the topic at 
hand; sql]

On Sunday 03 February 2002 1:27 pm, Chuck Barnett wrote:
> > Hi, I have a db field that holds the first and last name of a person.  Is
> > there a way to sort by the last name in that field?
> > The whole reason for this is to populate a select box sorted by last
> > name.
> >
> > I don't want to go back and create a separate field if I don't have to.

Your database is denormalised and this is what is causing the problem.  You 
could probably do this through string manipulation but it is almost always 
going to be a better idea to do this on the client side.  Additionally, 
consider that you may not be able to handle names like 'von Neuman' and the 
like.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Query causes Mysql to shut down

[Miguel Angel Solorzano]

At 20:36 26/03/02 +, Richard Prangnell wrote:
Hi!

Please, Can you send me a test case ? Including the create table
statement, some rows for to insert and the queries.

Regards,
Miguel
>Dear sirs,
>
>I have a situation on my local Windows development platform that is causing
>the mysql daemon to shut down. I cannot recreate the problem on the web
>server, which is Linux.
>
>The error message (on Windows) is:
>
>MYSQLD-OPT caused an invalid page fault in
>module MYSQLD-OPT.EXE at 017f:00460912.
>Registers:
>EAX= CS=017f EIP=00460912 EFLGS=00010206
>EBX=018bf5fc SS=0187 ESP=018bf578 EBP=0003
>ECX=0003 DS=0187 ESI= FS=5527
>EDX=0003 ES=0187 EDI=018bf60f GS=
>Bytes at CS:EIP:
>f3 a4 01 6b 04 5f 5e 5d 33 c0 5b c2 08 00 53 55
>Stack dump:
>00a1c189 018bf5fc  00a1c162 00420801  0003 
>01446c20  00a1c9a4 00a1c1bc bff7b9c5 00a1c18c 0028 004be901
>
>The query that seems to be 'tender' is:
>
> SELECT advert_id, uid, uname, teaser, bodytext,
>   DATE_FORMAT(upload_date, '%d %b %y'), cat_id,
>   DATE_FORMAT(expiry_date, '%d %b %y'), expiry_flag
>   FROM mod_adverts
>   WHERE cat_id = $cat_id
>   AND expiry_flag = 0
>   OR cat_id = $cat_id
> AND expiry_flag = 1
> AND expiry_date > 'datetime(now())'
>   ORDER BY advert_id DESC
>
>Now for details of my setup:
>
>Hardware: CyrixInstead Cyrix MII (266Mhz) 80Mb RAM
>OS: Microsoft Windows 98 Series II 4.10. A
>Web Server: Apache 1.3.20 (Win32) PHP/4.0.6
>MySQL: WinMySQLAdmin Ver 1.3
>
>If it is my SQL query that is not quite right, I would have thought that I
>would have received a different kind of error message - one that doesn't
>choke the server?
>
>Any help with this would be most welcome.
>
>Yours sincerely
>
>
>Richard Prangnell
>
>www.praggers.com
>
>
>
>-
>Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-- 
For technical support contracts, goto https://order.mysql.com/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Miguel A. Solórzano <[EMAIL PROTECTED]>
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Mogi das Cruzes - São Paulo, Brazil
<___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: phpMyAdmin issue + looking for php/mysql websites

[Todd Williamsen]

Is there a reason why you are using IIS?  

I would disable IIS and run apache.  That's what I did, IIS is way to
difficult and unstable to install PHP as CGI or ISAPI

Apache is easy to set up with PHP.  Download Apache and run PHP from
there.  Make sure you disable ALL the IIS services

-Original Message-
From: catriona grisewood [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, March 26, 2002 2:45 PM
To: Hathaway, Scott L; 'Andreas_Frxsting'; [EMAIL PROTECTED]
Subject: RE: phpMyAdmin issue + looking for php/mysql websites


Im not sure what way php is installed as it was
already installed on the server here. How i got this
message exactly was
when i opened up MyphpMyAdmin after just installing
it. I go to create a new datbase and thats when the
error page comes up. Could it be i dont have the
config file setup correctly ? or maybe MySQL isnt
configured correctly ?

i dont know if that helps ?

Thanks for any help
--- "Hathaway, Scott L" <[EMAIL PROTECTED]>
wrote:
> I use PHP (cgi) with IIS and phpMyAdmin.  The
> problem with the header
> function is just that a couple of the .inc files
> with phpMyAdmin need to
> have the extra lines after the ?> deleted.  But,
> that message says that the
> headers have already been sent out.  The error below
> usually means a 404
> error if you are using a template.  If not, it
> usually means that you have
> forgotten something like a curly brace or a script
> ending.
> 
> Post your code and it will be easier to help.
> 
> Scott
> 
> -Original Message-
> From: Andreas Frosting [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 26, 2002 2:27 PM
> To: 'catriona grisewood'; [EMAIL PROTECTED]
> Subject: RE: phpMyAdmin issue + looking for
> php/mysql websites
> 
> 
> >  "The specified CGI application misbehaved by not
> > returning a complete set of HTTP headers. The
> headers
> > it did return are:"
> 
> Looks like you're running phpMyAdmin on a machine
> with Windows and PHP
> in CGI-mode?
> I don't recall if it's PHP in CGI-mode on Windows
> that in general
> doesn't work with the header()-function or if it's
> only IIS.
> 
> The solution is to install PHP as non-cgi... Don't
> know how that is done
> as I'm using FreeBSD, but know you know whats wrong
> :)
> 
> > I dont think i set up mySQL properly maybe ?
> 
> The problem is not related to MySQL.
> 
> :wq
> //andreas
> http://phpwizard.dk/ (in Danish only)
> 
> 
>
-
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list
> archive)
> 
> To request this thread, e-mail
> <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
>
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php


__
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy AwardsR
http://movies.yahoo.com/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

FW: RE: phpMyAdmin issue + looking for php/mysql websites

[Andreas Frøsting]

> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
> 
> sql,query

Gaah..

> Hi,
> 
> > I use PHP (cgi) with IIS and phpMyAdmin.  The
> > problem with the header
> > function is just that a couple of the .inc files
> > with phpMyAdmin need to
> > have the extra lines after the ?> deleted.
> 
> If that was the case, phpMyAdmin wouldn't be working with any other
> webserver... Well, it does!
> PHP's behavior regarding headers and data sent before the 
> headers itself
> is the same on all platforms.
> 
> > But,
> > that message says that the
> > headers have already been sent out.
> 
> I've never worked with IIS, but that's a Microsoft-style error message
> if that's true.
> 
> > The error below
> > usually means a 404
> > error if you are using a template.  If not, it
> > usually means that you have
> > forgotten something like a curly brace or a script
> > ending.
> 
> If it was a 404 the server would say so.
> If it's a script error php would say something like "Parse error...
> blahblah" :)
> 
> :wq
> //andreas


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: phpMyAdmin issue + looking for php/mysql websites

[Todd Williamsen]

Read the documentation.  Where is the mySQL database located?  Is it on
the web server or on another machine?  If its on another machine then
you put in the IP address.  If its on the same machine as the Web
Server, then put in localhost

Get it?

-Original Message-
From: catriona grisewood [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, March 26, 2002 2:55 PM
To: Hathaway, Scott L; 'Andreas_Frxsting'; [EMAIL PROTECTED]
Subject: RE: phpMyAdmin issue + looking for php/mysql websites


when im connecting to an online MySQL server do i just
put in the server name ie 'orac'in the config file or
do i need to put in its ip address etc with it ?
--- "Hathaway, Scott L" <[EMAIL PROTECTED]>
wrote:
> I use PHP (cgi) with IIS and phpMyAdmin.  The
> problem with the header
> function is just that a couple of the .inc files
> with phpMyAdmin need to
> have the extra lines after the ?> deleted.  But,
> that message says that the
> headers have already been sent out.  The error below
> usually means a 404
> error if you are using a template.  If not, it
> usually means that you have
> forgotten something like a curly brace or a script
> ending.
> 
> Post your code and it will be easier to help.
> 
> Scott
> 
> -Original Message-
> From: Andreas Frosting [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 26, 2002 2:27 PM
> To: 'catriona grisewood'; [EMAIL PROTECTED]
> Subject: RE: phpMyAdmin issue + looking for
> php/mysql websites
> 
> 
> >  "The specified CGI application misbehaved by not
> > returning a complete set of HTTP headers. The
> headers
> > it did return are:"
> 
> Looks like you're running phpMyAdmin on a machine
> with Windows and PHP
> in CGI-mode?
> I don't recall if it's PHP in CGI-mode on Windows
> that in general
> doesn't work with the header()-function or if it's
> only IIS.
> 
> The solution is to install PHP as non-cgi... Don't
> know how that is done
> as I'm using FreeBSD, but know you know whats wrong
> :)
> 
> > I dont think i set up mySQL properly maybe ?
> 
> The problem is not related to MySQL.
> 
> :wq
> //andreas
> http://phpwizard.dk/ (in Danish only)
> 
> 
>
-
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list
> archive)
> 
> To request this thread, e-mail
> <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
>
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php


__
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy AwardsR
http://movies.yahoo.com/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Report to Recipient(s)

[ININOTES/INI]

Incident Information:-

Originator:[EMAIL PROTECTED]
Recipients:[EMAIL PROTECTED]
Subject:  mysql Digest 26 Mar 2002 21:04:43 - Issue 1818

Message from [EMAIL PROTECTED] was quarantined because it
contained banned content.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Integrating MySQL with Flash or LiveMotion via Lasso

[Cathy Cunningham (Blue World Lasso Evangelist)]

For those of you looking for assistance with building Web-based 
front-ends to MySQL using Macromedia Flash or Adobe LiveMotion, you 
may be interested in two tutorials authored by Jordan Chilcott (an 
independent Web developer) that were made available today.

Details are available at 
.

Enjoy!

CC
-- 

-
Cathy Cunningham   [EMAIL PROTECTED]
Lasso Evangelist
Blue World Communications, Inc.   http://www.blueworld.com/
-

Lasso Studio is "the easiest way to create a database-driven Web site"
- Macworld Magazine

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

BCP

[Harpreet Kaur]

I am using
C:\>   BCP dbname.dbo.tblname out tblname.txt -S srvrname -U sa –P sapwd -c 
-t \t -r \n

to create a text file from a sqlserver table . Th text file shows a tab 
after every field except the last field. How can i get it to put a tab even 
after the last field.

Help is appreciated,

regards, Harpreet

_
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

[OT] Re: BCP

[Christopher Thompson]

On Tuesday 26 March 2002 2:56 pm, Harpreet Kaur wrote:
> I am using
> C:\>   BCP dbname.dbo.tblname out tblname.txt -S srvrname -U sa –P sapwd -c
> -t \t -r \n
>
> to create a text file from a sqlserver table . Th text file shows a tab
> after every field except the last field. How can i get it to put a tab even
> after the last field.

This does not seem to be relevant to MySQL.

The best way of doing this would be to use perl.  Should be a fairly simple 
perl script, just replace all \n with \t\n

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysqlgui crash caused by infinite loop

[peters]

>Description:
mysqlgui crash caused by infinite loop in
mysql_read_default_options because strcend
never returns 0
>How-To-Repeat:

>Fix:

--- libmysql/libmysql.c.origThu Feb 14 18:30:17 2002
+++ libmysql/libmysql.c Tue Mar 19 15:52:49 2002
@@ -712,7 +712,7 @@ static void mysql_read_default_options(s
  *end=0;   /* Remove '=' */
}
/* Change all '_' in variable name to '-' */
-   for (end= *option ; (end= strcend(end,'_')) ; )
+   for (end= *option ; (end= strcend(end,'_')) && *end; )
  *end= '-';
switch (find_type(*option+2,&option_types,2)) {
case 1: /* port */

--- libmysql_r/libmysql.c.orig  Thu Feb 14 18:30:17 2002
+++ libmysql_r/libmysql.c   Tue Mar 26 22:52:17 2002
@@ -712,7 +712,7 @@ static void mysql_read_default_options(s
  *end=0;   /* Remove '=' */
}
/* Change all '_' in variable name to '-' */
-   for (end= *option ; (end= strcend(end,'_')) ; )
+   for (end= *option ; (end= strcend(end,'_')) && *end; )
  *end= '-';
switch (find_type(*option+2,&option_types,2)) {
case 1: /* port */

>Submitter-Id:  
>Originator:Peter Strömberg
>Organization:
 
>MySQL support: none
>Synopsis:  mysqlgui crash caused by infinite loop
>Severity:  serious
>Priority:  
>Category:  mysql
>Class: sw-bug
>Release:   mysql-3.23.49 (OpenBSD port: mysql-server-3.23.49)
>Server: /usr/local/bin/mysqladmin  Ver 8.23 Distrib 3.23.49, for unknown-openbsd3.1 
>on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version  3.23.49-log
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /var/run/mysql/mysql.sock
Uptime: 7 hours 48 min 23 sec

Threads: 1  Questions: 1  Slow queries: 0  Opens: 6  Flush tables: 1  Open tables: 0 
Queries per second avg: 0.000
>Environment:

System: OpenBSD wilfried.no-ip.org 3.1 GENERIC#3 i386


Some paths:  /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-unknown-openbsd3.1/2.95.3/specs
gcc version 2.95.3 20010125 (prerelease)
Compilation info: CC='cc'  CFLAGS='-O2 -pipe '  CXX='cc'  CXXFLAGS='-O2 -pipe  
-felide-constructors -fno-exceptions -fno-rtti'  LDFLAGS=''
LIBC: 
-r--r--r--  1 root  bin  732610 Mar 23 15:16 /usr/lib/libc.a
-r--r--r--  1 root  bin  598961 Mar 23 15:16 /usr/lib/libc.so.28.3
Configure command: ./configure  --enable-shared --enable-static 
--localstatedir=/var/mysql --with-innodb '--with-comment=OpenBSD port: 
mysql-server-3.23.49' --with-libwrap=/usr --with-mysqld-user=mysql 
--with-unix-socket-path=/var/run/mysql/mysql.sock --without-perl --without-debug 
--without-readline --without-bench --without-mit-threads --without-gemini 
--without-berkeley-db --prefix=/usr/local --sysconfdir=/etc


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

binary expansion?

[adam nelson]

It's been a while since I've done this, does anybody remember:


If I have 2 tables:

tblPerson (
iPersonID int
szPersonDesc varchar
iPersonType int
)

tblPersonType (
iPersonType int
szPersonType varchar
)

iPersonType = iPersonType (foreign key between the 2 tables)

iPersonType is a list in the form of 1,2,4,8,16,32,64

so, let's suppose that szPersonType for 8 is lawyer and szPerson type
for 2 is redhead

a value of iPersonType of 10 would mean redhead lawyer.

I'd like a query that looks for lawyers (ie. iPerson type is any number
from 8 to 15 or 16+8=32 or 16+8+4=28 or  16+8+1=29 or 16+8+4+2=30 or
32+8=40 or 32+8+4=44 ,etc. up to the max(iPersonType))





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RSA encrypted strings - what data type?

[Steven Hajducko]

Hi,

I'm new to the list and I joined because I couldn't figure out the
answer to this problem.

I'm trying to take a string ( In this case, a password ), and encrypt it
with RSA encryption via the perl module, Crypt::RSA.  Later on, I want
to be able to pull the encrypted string back out and decrypt it.

One of three things happens when I do this however.

1) Everything works fine.
2) I cannot insert the encrypted string.
3) The encrypted string is inserted, but incorrectly and will not
decrypt.

I tried using a blob or medium blob for the datatype, but neither will
work 100% of the time.  Has anyone done this before with a Mysql db and
if so, how? What sort of datatype do you use for the field that will
contain the encrypted string?  Did you use a different type of
encryption method? ( Keep in mind that I cannot use a one way encryption
scheme for this. )

Thanks,

Steve



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: binary expansion?

[Rodney Broom]

From: adam nelson <[EMAIL PROTECTED]>

> It's been a while since I've done this, does anybody remember:
> I'd like a query that looks for lawyers...

Have you thought about using an unsigned int and doing bitwise math?

---
Rodney Broom
Programmer: Desert.Net

sql



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: binary expansion?

[Christopher Thompson]

On Tuesday 26 March 2002 3:30 pm, adam nelson wrote:
> It's been a while since I've done this, does anybody remember:
>
>
> If I have 2 tables:
>
> tblPerson (
> iPersonID int
> szPersonDesc varchar
> iPersonType int
> )
>
> tblPersonType (
> iPersonType int
> szPersonType varchar
> )
>
> iPersonType = iPersonType (foreign key between the 2 tables)
>
> iPersonType is a list in the form of 1,2,4,8,16,32,64
>
> so, let's suppose that szPersonType for 8 is lawyer and szPerson type
> for 2 is redhead
>
> a value of iPersonType of 10 would mean redhead lawyer.
>
> I'd like a query that looks for lawyers (ie. iPerson type is any number
> from 8 to 15 or 16+8=32 or 16+8+4=28 or  16+8+1=29 or 16+8+4+2=30 or
> 32+8=40 or 32+8+4=44 ,etc. up to the max(iPersonType))

Use AND.  I forget the SQL syntax for it but in C, you'd do:

if (iPersonType & 8) {
// yes
} else {
// no
}

Note that this is different from the && operator.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: RSA encrypted strings - what data type?

[Christopher Thompson]

On Tuesday 26 March 2002 3:26 pm, Steven Hajducko wrote:
>
> I'm trying to take a string ( In this case, a password ), and encrypt it
> with RSA encryption via the perl module, Crypt::RSA.  Later on, I want
> to be able to pull the encrypted string back out and decrypt it.

Note that if you do this, you must hard-code the key somewhere (unless you 
are prompting the user for it) which means you are simply obfuscating the 
data, not actually encrypting it.

> One of three things happens when I do this however.
>
> 1) Everything works fine.
> 2) I cannot insert the encrypted string.
> 3) The encrypted string is inserted, but incorrectly and will not
> decrypt.
>
> I tried using a blob or medium blob for the datatype, but neither will
> work 100% of the time.  Has anyone done this before with a Mysql db and
> if so, how? What sort of datatype do you use for the field that will
> contain the encrypted string?  Did you use a different type of
> encryption method? ( Keep in mind that I cannot use a one way encryption
> scheme for this. )

You need a blob.  Are you sure you are storing the data as binary?  
Alternatively, it is probably of fixed size and so you could just store the 
resulting chunk of data as a series of 8 bit values.

Note that if you do not need to be able to recover the password, just verify 
whether the password a user typed is correct, you CAN and, in fact, SHOULD 
use a one-way hash instead of an encryption.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

question about converting isam to myisam tables (shotcut!)

[Henry Hank]

Hello all,

  I'm in the process of building a new mysql db server box to migrate a
database off an existing web server.  The webserver is running mysql 3.22.29,
and the new box is running 3.23.  The two biggest tables are about 20 million
records and the data and index files are each just over 1GB, and each have a
primary key and three or four non-unique indexes. 

 I've copied the data files from the old box to the new, but when I use the
ALTER TABLE...TYPE=MYISAM, it takes forever since it is rebuilding the indexes
by keycache.  So this is what I'm doing instead, and I'm asking if there are
any problems associated with this approach:

- the existing ISAM Table is called TBL_ISAM
- Create a new/empty myisam table with no indexes named TBL_FLAT
- Create a new/empty myisam table with all indexes named TBL_INDX

mysql> insert into TBL_FLAT select * from TBL_ISAM;  (runs very quickly - not
updating any indexes)
mysql> flush tables;

the in the OS shell (linux) do the following:

$ cp TBL_INDX.frm TBL_FLAT.frm
$ cp TNL_INDX.MYI TBL_FLAT.MYI

then to rebuild all the indexes via sorting, use myisamchk:

$ myisamchk -r -q TBL_FLAT  

I'm left with a fully populated and indexed TBL_FLAT table, which seems to work
perfectly as the original converted ISAM table.

An in addition, I did first try "myisamchk -r -k0" to disable the indexes and
do the insert into the TBL_INDX table, but mysql still insists on building the
primary key via the keycache - and it takes way too long.  My method allows me
to populate the data file with no indexes, and then fool mysql into rebuilding
all the indexes at once via sorting.

Does anyone think there are any risks/problems with this approach?

Thanks in advance!
 -Hank




__
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: RSA encrypted strings - what data type?

[Steven Hajducko]

On Tue, 2002-03-26 at 14:35, Christopher Thompson wrote:
> On Tuesday 26 March 2002 3:26 pm, Steven Hajducko wrote:
> >
> > I'm trying to take a string ( In this case, a password ), and encrypt it
> > with RSA encryption via the perl module, Crypt::RSA.  Later on, I want
> > to be able to pull the encrypted string back out and decrypt it.
> 
> Note that if you do this, you must hard-code the key somewhere (unless you 
> are prompting the user for it) which means you are simply obfuscating the 
> data, not actually encrypting it.

The user has to specify this.  There are 2 ( sets of ) keys.  One goes
to each department.  The scripts require the specification of the key or
the location of the key.

> 
> > One of three things happens when I do this however.
> >
> > 1) Everything works fine.
> > 2) I cannot insert the encrypted string.
> > 3) The encrypted string is inserted, but incorrectly and will not
> > decrypt.
> >
> > I tried using a blob or medium blob for the datatype, but neither will
> > work 100% of the time.  Has anyone done this before with a Mysql db and
> > if so, how? What sort of datatype do you use for the field that will
> > contain the encrypted string?  Did you use a different type of
> > encryption method? ( Keep in mind that I cannot use a one way encryption
> > scheme for this. )
> 
> You need a blob.  Are you sure you are storing the data as binary?  
> Alternatively, it is probably of fixed size and so you could just store the 
> resulting chunk of data as a series of 8 bit values.

That's what I figured.  I'm probably trying to store the data
incorrectly.  I guess this is where I'll start looking.

> 
> Note that if you do not need to be able to recover the password, just verify 
> whether the password a user typed is correct, you CAN and, in fact, SHOULD 
> use a one-way hash instead of an encryption.

As I said, I can't use one way :)  The passwords need to be recovered,
not verified.



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Report to Recipient(s)

[William R. Mussatto]

On Tue, 26 Mar 2002 [EMAIL PROTECTED] wrote:

> Date: Tue, 26 Mar 2002 16:39:05 -0500
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Subject: Report to Recipient(s)
> 
> Incident Information:-
> 
> Originator:[EMAIL PROTECTED]
> Recipients:[EMAIL PROTECTED]
> Subject:  mysql Digest 26 Mar 2002 21:04:43 - Issue 1818
> 
> Message from [EMAIL PROTECTED] was quarantined because it
> contained banned content.

I'm sorry, but I couldn't help it...This strikes me as something 
Microsoft would say. ;-) 

Sincerely,

William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Adding a Column to an existing table

[BD]

At 02:32 PM 3/26/2002, you wrote:
>Hi, I'm new to this list, hopefully, I can contribute some wisdom :)
>
>At the moment, I have to update a large database to be multi-company-ready,
>so I basically have to add a Column "Company_ID" to nearly each table.
>
>What would be the easiest way to do this?
>
>I already thought about running a "SELECT *" Query for each table, saving
>the result in an Array (in PHP, btw, it's a webapplication), dropping the
>table, creating the new table and looping through the data to insert the
>data again. Problem is, that this puts a heavy task on the server, I tried
>it on a local "crash"-server, and even with carefully planned setting and
>unsetting of the arrays, it eats up the RAM since the arrays just get damn
>big. And since I have to remote control the server and it is important that
>the server is online nearly 24/7, I risk to crash the server without having
>the physical option to reboot it until the next morning...a few hundred
>kilometres away from my workplace...

Yikes! :(
I don't think you want to do it this way. Unless your car has plenty of gas 
and you can outrun your boss's car. ;-)


>Now I am looking into two things:
>
>1) is there some kind of "MODIFY" query I can run???

"ALTER TABLE tablename ADD columnname  ...". See 
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#ALTER_TABLE. 



>2) or is it possible to dumb the database, drop it, create the new structure
>and then write the dumb back in with some options that it ignores the
>"CREATE TABLE" queries and that it doesn't check if the count of the values
>matches the count of the columns? (error I get when I try to do it at the
>moment).

Too complicated.


>3) another way...
>
>As you can see, I am not THAT experienced with MySQL, so any help is greatly
>appreciated!!!

If you want to modify a database remotely, try PHPMyAdmin from 
http://www.phpwizard.net/projects/phpMyAdmin/. It's free.

Of course make a backup before you do anything!! See 
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Backup.

You can greatly enhance your confidence with MySQL just by reading the 
manual http://www.mysql.com/documentation/mysql/bychapter/. You can also 
download a PDF version and read it offline. Also Paul Dubois's book "MySQL" 
is quite good and has plenty of examples.

Word to the wise. Never trust a surgeon who operates with a chainsaw. Read 
the manual so you know which tools to use. Yes it may take you a week to 
get through it, but your confidence will grow and you won't be accidentally 
amputating any of your body parts in the process (and neither will your Boss!).

Brent


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: RSA encrypted strings - what data type?

[Lance Uyehara]

> I'm trying to take a string ( In this case, a password ), and encrypt it
> with RSA encryption via the perl module, Crypt::RSA.  Later on, I want
> to be able to pull the encrypted string back out and decrypt it.
>
> One of three things happens when I do this however.
>
> 1) Everything works fine.
> 2) I cannot insert the encrypted string.
> 3) The encrypted string is inserted, but incorrectly and will not
> decrypt.
>
> I tried using a blob or medium blob for the datatype, but neither will
> work 100% of the time.  Has anyone done this before with a Mysql db and
> if so, how? What sort of datatype do you use for the field that will
> contain the encrypted string?  Did you use a different type of
> encryption method? ( Keep in mind that I cannot use a one way encryption
> scheme for this. )

Store it as a blob if you don't want to mess with it. or if it's easier you
can use Mime::Base64 encode it and store it as text. Then decode it when you
need it. NOTE: encoding it will make it a bigger.

-Lance



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

FW: Access break mode error

[Rutledge, Aaron]

I actually posted this yesterday, but I think it got lost with the whole
Oracle debacle.  If anyone has experienced this your feedback would be
greatlt appreciated.  best regards, Aaron


Occasionally with MyODBC, MySQL and Access I am getting an error when
trying to close a window stating 'This action will reset the current
code in break mode.  Do you want to stop the running code-Yes/No'.  It
becomes impossible to close the window because it wont allow me to
select Yes.  The only way to get out of it is to force Access to
close--something that obviously makes me nervous.  I have a timestamp
column and a primary key--everything should be a current version.  Has
anyone else experienced this or know what the problem is? --Aaron

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: question about converting isam to myisam tables (shotcut!)

[Lopez David E-r9374c]

Hank

Instead of dropping down to OS cp commands, insert the data from
table TBL_FLAT to TBL_INDX.

 INSERT INTO TBL_INDX SELECT * FROM TBL_FLAT;

This will be valid in mysql. The insert will be fast since
only one insert statement. Let the list know if this works
for you. Or if your method is valid as well.

David

-Original Message-
From: Henry Hank [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 3:37 PM
To: [EMAIL PROTECTED]
Subject: question about converting isam to myisam tables (shotcut!)



Hello all,

  I'm in the process of building a new mysql db server box to migrate a
database off an existing web server.  The webserver is running mysql 3.22.29,
and the new box is running 3.23.  The two biggest tables are about 20 million
records and the data and index files are each just over 1GB, and each have a
primary key and three or four non-unique indexes. 

 I've copied the data files from the old box to the new, but when I use the
ALTER TABLE...TYPE=MYISAM, it takes forever since it is rebuilding the indexes
by keycache.  So this is what I'm doing instead, and I'm asking if there are
any problems associated with this approach:

- the existing ISAM Table is called TBL_ISAM
- Create a new/empty myisam table with no indexes named TBL_FLAT
- Create a new/empty myisam table with all indexes named TBL_INDX

mysql> insert into TBL_FLAT select * from TBL_ISAM;  (runs very quickly - not
updating any indexes)
mysql> flush tables;

the in the OS shell (linux) do the following:

$ cp TBL_INDX.frm TBL_FLAT.frm
$ cp TNL_INDX.MYI TBL_FLAT.MYI

then to rebuild all the indexes via sorting, use myisamchk:

$ myisamchk -r -q TBL_FLAT  

I'm left with a fully populated and indexed TBL_FLAT table, which seems to work
perfectly as the original converted ISAM table.

An in addition, I did first try "myisamchk -r -k0" to disable the indexes and
do the insert into the TBL_INDX table, but mysql still insists on building the
primary key via the keycache - and it takes way too long.  My method allows me
to populate the data file with no indexes, and then fool mysql into rebuilding
all the indexes at once via sorting.

Does anyone think there are any risks/problems with this approach?

Thanks in advance!
 -Hank




__
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: RSA encrypted strings - what data type?

[Steven Hajducko]

Well, I screwed around with it.  This is what I got ( just in case
anybody cares.. )

( this is in perl, using the Crypt::RSA module.. )

$password = "screwyou!";

# encrypts the 'password'...
$cyphertext = $rsa->encrypt(Message=>$password, Key=>$pub);

# now convert the RSA encrypted key to binary.
$bin_str = unpack("B*", pack("u*", $cyphertext));

# now reconvert it back to uuencode..
$recypher = unpack("u*",pack("B*", $bin_str));

# then decrypt it.
$plaintext = $rsa->decrypt(Cyphertext=>$recypher, Key=>$priv);

# prints "screwyou!"
print "$plaintext\n";

Mysql has no trouble keeping the binary version.

Thanks for the help guys,

Steve

On Tue, 2002-03-26 at 14:35, Christopher Thompson wrote:
> On Tuesday 26 March 2002 3:26 pm, Steven Hajducko wrote:
> >
> > I'm trying to take a string ( In this case, a password ), and encrypt it
> > with RSA encryption via the perl module, Crypt::RSA.  Later on, I want
> > to be able to pull the encrypted string back out and decrypt it.
> 
> Note that if you do this, you must hard-code the key somewhere (unless you 
> are prompting the user for it) which means you are simply obfuscating the 
> data, not actually encrypting it.
> 
> > One of three things happens when I do this however.
> >
> > 1) Everything works fine.
> > 2) I cannot insert the encrypted string.
> > 3) The encrypted string is inserted, but incorrectly and will not
> > decrypt.
> >
> > I tried using a blob or medium blob for the datatype, but neither will
> > work 100% of the time.  Has anyone done this before with a Mysql db and
> > if so, how? What sort of datatype do you use for the field that will
> > contain the encrypted string?  Did you use a different type of
> > encryption method? ( Keep in mind that I cannot use a one way encryption
> > scheme for this. )
> 
> You need a blob.  Are you sure you are storing the data as binary?  
> Alternatively, it is probably of fixed size and so you could just store the 
> resulting chunk of data as a series of 8 bit values.
> 
> Note that if you do not need to be able to recover the password, just verify 
> whether the password a user typed is correct, you CAN and, in fact, SHOULD 
> use a one-way hash instead of an encryption.
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

phpMyAdmin issue

[CATRIONA GRISEWO0D]

Hi 

I have got phpMyAdmin connecting to my server.
When i open up index i can see on the left hand side my datbase and tables.
And on the right of the page is the welcome page...

Welcome to phpMyAdmin 2.2.5
MySQL 3.23.32 running on 136.201.105.3 as [EMAIL PROTECTED]
phpMyAdmin  
 <<...OLE_Obj...>>  Top of Form 1  <<...OLE_Obj...>> Language:
 <<...OLE_Obj...>>   <<...OLE_Obj...>>  Bottom of Form 1
 <<...OLE_Obj...>>  phpMyAdmin documentation
 <<...OLE_Obj...>>  Official phpMyAdmin Homepage
 <<...OLE_Obj...>>  Sourceforge phpMyAdmin Download Page [ChangeLog]
[CVS] [Lists]   


I seem to be missing the bit where you create a database etc.

Then if I click on my database on the left hand side i get the error:

CGI Error
The specified CGI application misbehaved by not returning a complete set of
HTTP headers. The headers it did return are:



hh

any ideas ?
im sorry
but im a complete beginner here 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: phpMyAdmin issue

[Todd Williamsen]

The problem is PHP and IIS... IIS takes a lot to get it to work... I
think you should ask sourceforge about it, not the mysql mailing list.
This is a PHP issue not a mysql. 



-Original Message-
From: CATRIONA GRISEWO0D [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, March 26, 2002 6:24 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: phpMyAdmin issue


Hi 

I have got phpMyAdmin connecting to my server.
When i open up index i can see on the left hand side my datbase and
tables.
And on the right of the page is the welcome page...

Welcome to phpMyAdmin 2.2.5
MySQL 3.23.32 running on 136.201.105.3 as [EMAIL PROTECTED]
phpMyAdmin  
 <<...OLE_Obj...>>  Top of Form 1  <<...OLE_Obj...>> Language:
 <<...OLE_Obj...>>   <<...OLE_Obj...>>  Bottom of Form 1
 <<...OLE_Obj...>>  phpMyAdmin documentation
 <<...OLE_Obj...>>  Official phpMyAdmin Homepage
 <<...OLE_Obj...>>  Sourceforge phpMyAdmin Download Page [ChangeLog]
[CVS] [Lists]   


I seem to be missing the bit where you create a database etc.

Then if I click on my database on the left hand side i get the error:

CGI Error
The specified CGI application misbehaved by not returning a complete set
of
HTTP headers. The headers it did return are:



hh

any ideas ?
im sorry
but im a complete beginner here 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL client timezone

[Maxim Vysotskiy]

Hello 'mysql,

Does anybody know is this possible to set some particular timezone for
the session? ie: server is in GMT, but application needs time selected
in GMT+3
Is there any universal way ?
Thanx for any hint in advance

-- 
Best regards,
 Maxim  mailto:[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

rdf utf-8 -> to mysql howto

[David yahoo]

Hi all,

My purpose is to transform an rdf utf-8 file into sql for mysql.
Data are both in french/english, in french there are stange caractere that
doesnt render well (çèé...)

What the output had to be ?
Mysql only support latin1 ?

I m lost in all that encodage !

Help me

I dont know how to parametrer the php parser I make.

// create parser
$xp = xml_parser_create("UTF-8");
// set element handler
xml_set_element_handler($xp, "elementBegin", "elementEnd");
xml_set_character_data_handler($xp, "characterData");
xml_parser_set_option($xp, XML_OPTION_CASE_FOLDING, TRUE);
xml_parser_set_option($xp, XML_OPTION_SKIP_WHITE, TRUE);
xml_parser_set_option($xp, XML_OPTION_TARGET_ENCODING, 'UTF-8');

Have I to decode / encode

//if (!($xml = utf8_encode($xml))) {
//echo 'ERROR'."\n";
//}

Thanks for all.


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

PHP, BLOB file, MySql and my web site

[Oladejo, Tokunboh]

Hi All,

Can anyone guide me on how to list the content of mysql table or result of a
query that has a BLOB file in it on my web page. I am listing the result of
the query OK now, but mysql query is listing the name of the graphic
(image1.gif) file instead of the graphic itself. I am working on a real
estate web site that requires the image of the property along with the
details when searched.


Thanx
Toks



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: PHP, BLOB file, MySql and my web site

[Maxim Vysotskiy]

Hello Tokunboh,

I'm not saving any binary data in database, only saves relative (to
webserver root) image paths there, and then just put them to  tag.

Wednesday, March 27, 2002, 3:05:35 AM, you wrote:

OT> Hi All,

OT> Can anyone guide me on how to list the content of mysql table or result of a
OT> query that has a BLOB file in it on my web page. I am listing the result of
OT> the query OK now, but mysql query is listing the name of the graphic
OT> (image1.gif) file instead of the graphic itself. I am working on a real
OT> estate web site that requires the image of the property along with the
OT> details when searched.


OT> Thanx
OT> Toks



OT> -
OT> Before posting, please check:
OT>http://www.mysql.com/manual.php   (the manual)
OT>http://lists.mysql.com/   (the list archive)

OT> To request this thread, e-mail <[EMAIL PROTECTED]>
OT> To unsubscribe, e-mail <[EMAIL PROTECTED]>
OT> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-- 
Best regards,
 Maximmailto:[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

upgrade 3.22 to 3.23 or 4.0 version

[Swapna Vangala]

Hi

I'm trying to upgrade my MySQL 3.22 version to 3.23 or 4.0 version on Linux 
flatform, but I don't know the procedure. Could any one please tell me the 
procedure how to do it. And if I upgrade to the higher version do I lose 
any of my data.

Thanks

Swapna


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Number of connections to mysql server

[Edilson Vasconcelos de Melo Junior]

Hi,

I have a client BD application that access a remote MYSQL server and its job
is 4-7hours long and it should be connected to the server all this time :(
My question is: how many simultaneous connections the mysql server can
handle? And what does happen when this limit is overstepped?

Thank u very much,
Edilson.

Edilson Vasconcelos de Melo Junior
www.jrsoftwares.com.br - Portal JR
[EMAIL PROTECTED]
Fone: (+55)(19)3256-3577
Cel : (+55)(19)9111-5873


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Number of connections to mysql server

[Paul DuBois]

At 22:45 -0300 3/26/02, Edilson Vasconcelos de Melo Junior wrote:
>Hi,
>
>I have a client BD application that access a remote MYSQL server and its job
>is 4-7hours long and it should be connected to the server all this time :(

Why is that a problem?

>My question is: how many simultaneous connections the mysql server can
>handle?

SHOW VARIABLES LIKE 'max\_connections';


>  And what does happen when this limit is overstepped?

The server will refuse connections if they're all used up.

>
>Thank u very much,
>Edilson.
>
>Edilson Vasconcelos de Melo Junior
>www.jrsoftwares.com.br - Portal JR
>[EMAIL PROTECTED]
>Fone: (+55)(19)3256-3577
>Cel : (+55)(19)9111-5873


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: [Newbie] MATCH and INDEX question (using a JOIN in a MATCH statement)

[Paul DuBois]

At 13:43 -0700 3/26/02, Dan Tappin wrote:
>This is a follow-up to a MySQL keyword text search question I had answer a
>few days ago.
>
>I have table 'main' which has two INT columns 'maincat' and 'subcat' which
>hold an index number from to other tables maincat and subcat.  These table
>each hold descriptive names ('name') for each of the main categories and sub
>categories.
>
>I have no problem using MATCH to search the various fields of 'main' using
>an INDEX.  The problem is I want to create a search across the related
>'name' fields of the other two tables.
>
>Here is what I have so far:
>
>select main.id, description, maincat.name, subcat.name from main LEFT JOIN
>clients ON forsale.clientid=clients.id WHERE MATCH (description) AGAINST
>('keywords')
>
>This works but I can only MATCH in the columns of 'main'.
>
>Now my first thought was to try this:
>
>select main.id, description, maincat.name, subcat.name from main LEFT JOIN
>clients ON forsale.clientid=clients.id WHERE MATCH (description,
>maincat.name, subcat.name) AGAINST ('keywords')
>
>Which results in an error.
>
>Can anyone tell me if I can do this using MATCH?

Nope.

The columns named in the MATCH() must match the columns for a FULLTEXT
index, and indexes don't cross tables.

>
>Thanks,
>
>Dan


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Number of connections to mysql server

[Dicky Wahyu Purnomo]

On Tue, 26 Mar 2002 22:45:18 -0300
"Edilson Vasconcelos de Melo Junior" <[EMAIL PROTECTED]> wrote:

> Hi,
> 
> I have a client BD application that access a remote MYSQL server and its job
> is 4-7hours long and it should be connected to the server all this time :(
> My question is: how many simultaneous connections the mysql server can
> handle? And what does happen when this limit is overstepped?
> 

it depends on your Operating System (kernel), and also your my.cnf ... but the most 
important is the kernel.

if it's overlimit, so the server (OS) can't handle or reject new connections. some OS 
become "panic" when it happens.

-- 
Avoid the Gates of Hell.  Use Linux
-- unknown source

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

temporary tables select

[Maxim Vysotskiy]

Hello mysql,

I have strange problem:
I create a temporary table (let's say temp_table) with one bigint(20)
field. And then, when I try

select * from temp_table

in same session - mySQL says that this table doesnot exist..
But I cannot create one more in this session - mySQL says that this
table already exists !

Somebody help please !

-- 
Best regards,
 Maxim  mailto:[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: load data infile question

[Paul DuBois]

At 20:41 + 3/26/02, Harpreet Kaur wrote:
>I want to transfer data from a table in sql server to mysql. I use
>C:\>   BCP dbname.dbo.tblname out tblname.txt -S srvrname -U sa –P sapwd -c
>-t \t -r \n
>to write the data to a text file and then use
>load data infile ‘/var/www/html/tblname.txt'  into table tblname;
>
>It works fine for all the tables except this one table which has
>description field with several lines. It assumes each line as a seperate
>field rather then one field and so create errors.
>
>Please help.

You have set yourself an impossible task.  You have a data file in which
the the line terminator occurs internally to certain field values.  The
terminator is thus ambiguous.

If you can, create the file so that the internal line separator characters
are written using \n or \r or \r\n sequences (whatever your terminator
is, I don't know what BCP is, so I can't tell what your command means).

>
>Regards Harpreet


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Date Interval Grouping

[pietrzyk]

Ok here's what I trying to do. I am trying to design a little browser/ip
tracking page and I need an SQL statement that will allow me to group IPs
that hit the site in 5 minute intervals (well I just want the interval thing
to work cuz I'll prolly want to make this like 30 minutes or a full hour).
The reason I want this kind of grouping is that if a person hits the page
constantly for 5 minutes I don't want that to push other relevant IPs down
the listing. Here's what I have to actually select the data from the
database.

SELECT tblVisitorHits.vIP, tblVisitorHits.vDateTime, tblBrowser.bVersion
FROM tblBrowser
RIGHT JOIN tblVisitorHits ON tblVisitorHits.vBrowser = tblBrowser.bKey
ORDER BY tblVisitorHits.vDateTime DESC, tblBrowser.bVersion ASC
LIMIT 0, 50;

// A simple group by I know will not work. but was wondering if there
// was a way to create a more complex group by that included expressions.

I don't know how one would implement the interval grouping. Any help would
be graciously accepted.

~!


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php