(WWOT) Re: PHP with TTF fonts

2002-02-04 Thread Colin Faber
; To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.c

Re: 1 billion row

2002-02-06 Thread Colin Faber
D]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/

Re: 1 billion row

2002-02-12 Thread Colin Faber
D]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/

Re: Faxing from MySQL

2002-02-18 Thread Colin Faber
ting, 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.

Re: Perl core API

2002-02-18 Thread Colin Faber
AIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.

Re: Perl core API

2002-02-18 Thread Colin Faber
the libmysqld api is part of the 4.x development branch at the moment, I suggest checking that out. If you're interested in the development branch I suggest hopping on to the internals list. Rodney Broom wrote: > > From: Colin Faber <[EMAIL PROTECTED]> > > > With t

Re: INSERT ... SELECT not supported?

2002-03-18 Thread Colin Faber
ists.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 -- Colin Faber (303) 859-1491 fpsn.net, Inc. ---

Re: all databases deneid

2002-03-19 Thread Colin Faber
7;@localhost' to database 'database05' > mysql> use db001; > ERROR 1044: Access denied for user: '@localhost' to database 'db001' > mysql> use db002; > ERROR 1044: Access denied for user: '@localhost' to database 'db002'

Re: MySQL, FreeBSD problem

2002-03-19 Thread Colin Faber
(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 -- Colin Faber (303) 859-1491 fpsn.net, Inc. ---

Re: Adding Columns to table

2002-03-20 Thread Colin Faber
ts > mysql> create table customers (Customer_ID INT NOT NULL PRIMARY KEY AUTO_INCREME > NT, First_Name VARCHAR(20) NOT NULL, LAst_Name VARCHAR(30) NOT NULL, address VAR > CHAR(50), City VARCHAR(20), State VARCHAR(2), Zip VARCHAR(20), E_Mail VARCHAR(20 > ), Age INT); -- C

Re: Error message

2002-03-20 Thread Colin Faber
se 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

Re: Access denied on use mysql;

2002-03-21 Thread Colin Faber
t IRC network. alan4100 wrote: > > mysql > > kathy, > What would happen if you type in > mysql -u root -p > > then type in > use mysql -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Befor

Re: hits

2002-03-28 Thread Colin Faber
l.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: Very large BLOBS in MySQL 4.0.1

2002-03-29 Thread Colin Faber
- > 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 u

PigeonRank™

2002-04-01 Thread Colin Faber
Is it true that mysql is planing to implement google's famous PigeonRank™ system in it's FTS word weighting schema??? *drool* :-) -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please chec

Re: PigeonRank

2002-04-01 Thread Colin Faber
> To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. ---

Re: PERL/SQL, again? - Re: Procedures

2002-04-03 Thread Colin Faber
x: up 54 days, processed 1,508,672,191 queries (319/sec. avg) > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the lis

Re: funny thing with versions

2002-04-03 Thread Colin Faber
//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/u

Re: Load Data Problem

2002-04-03 Thread Colin Faber
) has curly quotes but I > have also tried after converting the file to plain text with the same > results. Any assistance would be greatly appreciated. > > Cheers and thanks > > kim > > - > Before posti

Re: access sql statement

2002-04-03 Thread Colin Faber
o request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. -

Re: access sql statement

2002-04-03 Thread Colin Faber
I agree but this one one of those things which _SHOULD_ have been researched. denonymous wrote: > > From: "Colin Faber" <[EMAIL PROTECTED]> > > > Rw wrote: > > > > > > Is it possible to access a sql statement to mysql database throu

Re: Not null not working??

2002-04-04 Thread Colin Faber
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 -- Colin Faber (303) 859-1491 fpsn.net, In

Re: MySql/Perl installation problem

2002-04-07 Thread Colin Faber
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 -- Colin Faber (303) 859-1491 fpsn.net, Inc.

Re: regarding libmysqlclient and libmysqlclient_r

2002-04-10 Thread Colin Faber
lt;< endl; > delete r; >} > conn1.Close(); > > pthread_mutex_unlock(&lockmutex); > > } > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual)

Re: MySQL counter for HIGH traffic site

2002-04-14 Thread Colin Faber
m/ (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 -- Colin Faber (303) 859-1491 fpsn.net, Inc. -

Re: Poor Manual [Was: Why using filesort here?]

2002-04-21 Thread Colin Faber
- > 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-mai

Re: My Query is TOOOOOOOOOOOO Slow :(

2002-05-03 Thread Colin Faber
gt; > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-

Re: Perl-Mysql manual (.chm version)

2002-05-10 Thread Colin Faber
> > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. ---

Re: mysql uses 99% cpu under freebsd 4.3

2002-05-13 Thread Colin Faber
, 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

Re: Is there MySQL version 4.0.2 ?

2002-05-13 Thread Colin Faber
#x27;^ > -- > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) &g

Re: source code

2002-05-14 Thread Colin Faber
ttp://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: mixed up variables || solution found

2002-05-14 Thread Colin Faber
fault NULL, > > ETPA_membership_expires date default NULL, > > face blob, > > KEY id (id), > > FULLTEXT KEY resid (resid) > > ) TYPE=MyISAM; > > > > > > - > > Before posting, pleas

Re: Is there MySQL version 4.0.2 ?

2002-05-15 Thread Colin Faber
it via "bk pull" and I have used the: > > >cd mysql-4.0 > >bk pull bk://work.mysql.com:7001 > Nothing to pull from bk://work.mysql.com:7001 > > when I have checked my local copy via: > > >bk -r check

Re: mysql error

2002-05-15 Thread Colin Faber
h this MySQL version" > Is that command not availbale in version 3.23.49 if yes what is the > alternate command for it. > Would appreciate any help you can give me. > > Tristan -- Colin Faber (303) 736-5160 fpsn.net, Inc.

Re: empty?

2002-05-15 Thread Colin Faber
t; Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (

Re: Temp Table size?

2002-05-15 Thread Colin Faber
> 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]

Re: Load data command?

2002-05-15 Thread Colin Faber
, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting,

Re: Database's Disappear from phpMyAdmin

2002-05-17 Thread Colin Faber
l.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 unsubscribin

Re: apparent bug

2002-05-18 Thread Colin Faber
CHAR(30) NOT NULL, >Password CHAR(16) NOT NULL, >User_Access_Level_Code TINYINT NOT NULL, >User_SignUp_Date DATE NOT NULL, >Password_ReminderCHAR(64) NOT NULL, > User_Expire_Date DATE NOT NU

Re: apparent bug

2002-05-20 Thread Colin Faber
(AKA) [EMAIL PROTECTED] > > -Original Message- > From: Colin Faber [SMTP:[EMAIL PROTECTED]] > Sent: Saturday, May 18, 2002 3:46 PM > To: [EMAIL PROTECTED] > Cc: '[EMAIL PROTECTED]' > Subject:Re: apparent bug > > Hi, > > this is a f

Re: Demande d'inscription à mysql-france

2002-05-28 Thread Colin Faber
> 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 <

Re: Tab delimited dump?

2002-05-29 Thread Colin Faber
-- > 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?

Re: Get message

2002-06-03 Thread Colin Faber
---- > 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,

Re: MySQL and DBI remote access

2002-06-07 Thread Colin Faber
ease 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]>

Re: license...

2002-06-11 Thread Colin Faber
-- > 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-m

Re: Read-Only MySQL

2002-07-09 Thread Colin Faber
fore 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:

Re: MySQL on a Cobalt RAQ4

2002-07-16 Thread Colin Faber
- > 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 unsubscrib

Re: copy question

2002-07-17 Thread Colin Faber
(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/unsubscrib

Re: Opposite of --skip-networking?

2002-07-17 Thread Colin Faber
;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 -- Colin Faber (303) 736-5160 fpsn.net, Inc.

Re: Bash to remote MySql Server

2002-07-18 Thread Colin Faber
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: h

Re: a newserver would be better than this mailing list

2002-07-30 Thread Colin Faber
are probably more arguments against it ;-) > So my question, why this mailing list, why not a newsserver? See http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&safe=off&group=mailing.database This list is already fed t

For all you people looking for mysql shirts ;-)

2002-08-16 Thread Colin Faber
ry in advance if anyone is offended by this post. FILTER FODDER{ SQL, SELECT, DATABASE } -- Colin Faber (303) 736-5160 fpsn.net, Inc. * Black holes are where God divided by zero. * - Before posting, please check:

More questions about Fulltext searching.

2001-06-26 Thread Colin Faber
Ok, The message set that I noticed this morning sparked my interest in this. Currently I'm developing a search engine that will utilize mysql's fulltext match technology. The problem that i've run into is, I can't seem to find any documentation on how to force an AND search with in MATCH AGAIN

Re: Bug in Like with longblob

2001-06-27 Thread Colin Faber
a blob is by definition case sensitive hence 'Binary Large Object' This is not a bug but by design, If you want a non-Binary field to store large text objects then you should be using the 'TEXT' data type not the 'BLOB' data type. Tobias Eggendorfer wrote: > > Hi, > > I suppose I found a bug

Re: CHECK TABLE

2001-06-30 Thread Colin Faber
Check table didn't exist in 3.22 Werner Stuerenburg wrote: > > Sorry, I don't understand from the manual how to use this > (running MySQL 3.22.32 on RedHat) > > I tried to issue > > CHECK TABLE tbl_name > > as indicated, but get > > mysql> CHECK TABLE sessData; > ERROR 1064: parse error ne

Re: Little problem with gcc

2001-07-09 Thread Colin Faber
This is not a mysql error, Your paths are setup incorrectly or you don't have GCC installed, set the environment variable `CC' to the location of your gcc compiler, CC=something; export CC KFC wrote: > > Hi > > I have some problem with my OS system (DEC 0.4) when I ran commad > > "# CC=g

Re: as seen on national television

2001-07-13 Thread Colin Faber
This has been discussed to death on the freebsd mailing lists, The over all feeling was to add such a system would `break' most of the clients that subscribe and would eliminate the open mailing list we have now, Most list subscribers know that about 10/20 questions a month that come to this l

Re: Manual for sale? (was Re[2]: mysql.org)

2001-07-13 Thread Colin Faber
Michael, Interesting idea but I think it would problematic over all, The mysql manual changes almost everyday (anyone that syncs the bk tree's knows) I would suggest a better solution would be to provide the manual as a localized application (possibly even ported to PalmOS/WindowsCE), Anyone?

Re: problems untarring mysql under solaris

2001-07-15 Thread Colin Faber
Hi, This is a known problem with solaris tar, I suggest you use gnu tar for solaris, This should solve your current problem. You can get a pre-build package of gnu tar at www.sunfreeware.com "[EMAIL PROTECTED]" wrote: > > Hi all: > > I am running solaris 2.5.1 and I am having difficulties u

Re: Problems installing under solaris 2.5.1

2001-07-15 Thread Colin Faber
You need to make sure that the gcc on your box is build on that box, Using a package won't do it, most of them where compiled on greater or lesser hardware versions than you might be running, This in turn causes the compiler it self to think that its running in cross-compile mode and mysql won

Re: Problems installing under solaris 2.5.1 ... Fixed

2001-07-16 Thread Colin Faber
ainly pointed me in the right direction and saved me a LOT of > frustration. > > Best regards > Imran. > > - Original Message - > From: "Colin Faber" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Cc: "[EMAIL PROTECTED]" <[EMAIL PRO

Re: unsuported function

2001-07-18 Thread Colin Faber
Try a PHP mailing list, This is off topic. axel yson wrote: > > Fatal error: Call to unsupported or undefined function mysql() in >/usr/local/share/apache/htdocs/test.php3 on line 13 - Before posting, please check: http:

Re: Is last_insert_id reliable?

2001-07-20 Thread Colin Faber
Adding, For that thread. selecting LAST_INSERT_ID() for a pseudo-foreign keys system is reliable. The only case I can possibly think of, Of this being a problem is when you're dealing with a persistent connection to the database which is shared among multiple applications. Jonothan Farr wrote

Re: subqueries?

2001-07-27 Thread Colin Faber
No that's a 4.1 TODO. Bryan Capitano wrote: > > Do any of the newer versions of MySQL support sub-queries yet? > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql

Re: SUSAN

2001-07-27 Thread Colin Faber
Steve, They're both messages sent from windows machines infected with the SirCam worm, Just discard them. Steve Brazill wrote: > > Here's another one that appears to be a 'carrier' for something devious... > (though I didn't see any attachments) > > How did it get thru the list without any

Re: Storing passwords

2001-07-28 Thread Colin Faber
char(16) or char(32) with PASSWORD() function or your own crypt ;-) Hamid Mukhtar wrote: > > Hi, > Is there any data type for storing passwords in tables so that they cannot > be viewable by anyone. > > - > Before post

Re: Fwd: "This Ad Really Works!!!"

2001-08-01 Thread Colin Faber
Is the filter no longer working? PS database - 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 P

Re: WANTED: Utility to reverse engineer existing database

2001-08-06 Thread Colin Faber
For mysql you can use mysqldump Kevin wrote: > > I need a utility that will probe my existing mysql database, analyze the 90+ > tables and spit out the data definition language (create table, create > index, etc.) needed to recreate the database. Does such a utility exist? > > Kevin > > -

Re: "Got an error reading communication packets"

2001-08-07 Thread Colin Faber
Before posting, please check: http://www.mysql.com/manual.php (the manual) --> http://lists.mysql.com/ (the list archive) DS wrote: > > Anyone seen this in your log file before? > > It's perlscripts on the same host, so before the DBI > routine all the data needed for an inser

Re: ´óǰÖÃÖ÷ÒªÉè¼ÆË¼Ïë

2001-08-22 Thread Colin Faber
Sasha, Are you sure its working? Zusky wrote: >Part 1.1Type: Plain Text (text/plain) >Encoding: quoted-printable > > Name: ´óǰÖÃÖ÷ÒªÉè¼ÆË¼Ïë.doc.com >´óǰÖÃÖ÷ÒªÉè¼ÆË¼Ïë.doc.comType: MS-DOS Application >(application/x-unknown-content

Re: ´óǰÖÃÖ÷ÒªÉè¼ÆË¼Ïë

2001-08-22 Thread Colin Faber
sendmail++ Van wrote: > > Colin Faber wrote: > > > > Sasha, > > > > Are you sure its working? > > > > Zusky wrote: > > > > >Part 1.1Type: Plain Text (text/plain) > > >Encoding: quoted-printable > > &

Re: ???œ???Ÿ??????????

2001-08-22 Thread Colin Faber
Sasha, Hey that works for me. I'm personally not to fond of HTML email any ways ;-) Sasha Pachev wrote: > > On Wednesday 22 August 2001 01:53, Colin Faber wrote: > > Sasha, > > > > Are you sure its working? > > That is a bug in the filter, or rather

Re: password()

2001-08-22 Thread Colin Faber
Are you sure its not the full page ads and embedded ad-spam in cnet articles? "s. keeling" wrote: > > On Wed, Aug 22, 2001 at 03:19:43PM -0600, Sasha Pachev wrote: > > > > Just to make it difficult for people to migrate to Oracle, the only > > documentation that we provide for the PASSWORD() fu

Re: FW: sql

2001-08-27 Thread Colin Faber
With out knowing the exact error im guess its because you're trying to start the server as root. Sheena Sidhu wrote: > > Hi All, > I have installed mysql-max. Previously I had the mysql verion 3.23.40 > without max libraries on the same machine. When I start the server , I get > the fol

Re: Shell Shocking

2001-02-12 Thread Colin Faber
Donald, Poor administration of the server or incorrect privileges assigned to your user account. Donald Korth wrote: > Hello > > The hosting company has given me a user name and passwd . When i log into my own >site thro' a telnet session i 'm able to view all the databases created in t

Re: Conversion

2001-02-16 Thread Colin Faber
bob, first build the tables, to match your ascii database structure, Next use LOAD_DATA INFILE option to load it up, See LOAD_DATA in the manual for a detailed explanation. g'luck bob wrote: > I'm looking for a way to translate a database in ASCII form throw a > MySQL database. > Could you tel

Re: XML support under mySQL

2001-02-21 Thread Colin Faber
For someone like my self having a tool to export via XML is bloatware, Any XML handling should be delt with in the milddleware, where it will be utilized NOT the database it self. Michael Bacarella wrote: > > > Gorjan Todorovski ([EMAIL PROTECTED]) writes: > > > > > > > Is there support for XML

Re: XML support under mySQL

2001-02-22 Thread Colin Faber
Gorjan, Don't you think it would be a better idea to comply with ANSI SQL92 before we start talking about adding features that are really not needed nor critical? Gorjan Todorovski wrote: > To Ed: Why be so negative about adding new features to the DB server? Why > not make things easier and ma

Re: XML support under mySQL

2001-02-26 Thread Colin Faber
Don't forget, Microsoft and Oracle are behind it so it _MUST_ be the greatest thing to come along since sliced bread. You folks need to keep in mind that with the microsoft system the XML layer IS NOT part of the database it self but an additional application which talks to the database via 'ODBC'

Re: configure fails on linux-2.2.14 (Redhat 7.0), mysql-3.23.33

2001-03-11 Thread Colin Faber
This has been discussed to death, DO NOT RUN GCC 2.96 TO COMPILE MySQL IT IS FAR TO BUGGY Please check the mailing list archives _BEFORE_ posting Lyman Neuschaefer wrote: > > Greetings, > > The configure process fails on attempting to compile and link the executable > > conftest. Below i

Re: configure fails on linux-2.2.14 (Redhat 7.0), mysql-3.23.33

2001-03-11 Thread Colin Faber
Yes always. :p "Charles L. Hagen" wrote: > > Are you always this hospitable to others? > > Charles > - Original Message - > From: "Colin Faber" <[EMAIL PROTECTED]> > To: "Lyman Neuschaefer" <[EMAIL PROTECTED]> > Cc: &l

Re: information request

2001-03-18 Thread Colin Faber
1) How was it 'installed' Did you use RPMs, the source, or a bindist? 2) Did you make sure mysqld wasn't already running? 'ps auxwww | grep mysqld' Mani kandan Ramachandran wrote: > > Respected Sir/Madam > > While i configure mysql in my RedHat 7.0,it gives problem.And i do not > know how t

Re: MySQL and XML?

2001-03-21 Thread Colin Faber
You need to read the mailing list archives, This has been discussed to death. Please try to follow the directions outlined when posting. See the 'http://lists.mysql.com/ (the list archive)' ? Bryan Coon wrote: > > Can anyone offer some insight into the following topic? > > I would

Re: MySQL vs Microsoft SQL

2001-03-23 Thread Colin Faber
A whole TODO list of things. One should really evaluate the pros and cons of both databases to make an educated decision on which system would better suit ones needs. "Ciprian I. Acatrinei" wrote: > > Is there something that you can do with MS SQL and you can not do with MySQL? > > At 04:01 PM

Re: MAILER-DAEMON@123box.co.uk: 123box.co.uk mail delivery system

2001-08-31 Thread Colin Faber
Yes. "s . keeling" wrote: > > Is anyone else getting these goofy bounces from 123box.co.uk besides > me? Should I report them to Spamcop? :-) > > database, sql, ... > > -- > Any technology distinguishable from magic is insufficiently advanced. > [EMAIL PROTECTED] TopQuark Software & S

Re: output to csv

2001-09-04 Thread Colin Faber
Yes, the same way you would with the INFILE syntax Steve Doig wrote: > > Hi Folks, > > I'm running a batch command in win2K: cmd> mysql < batch-file > output.txt > In the batch file, can I specify that values are separated by commas instead > of tabs? > > Cheers, > Steve > >

Re: problem with using mysqladmin

2001-09-08 Thread Colin Faber
if(redhat){ Fear RPM install's } else { ./mysqladmin -uroot -hlocalhost password } Farzad Faramarzi wrote: > > Hi > I tried to set the password to mysql by using mysqladmin > and I received the following error message >

Re: MySQL and Perl (STOP)

2001-09-11 Thread Colin Faber
STOP PLEASE. Not again. See mailing list archives. [EMAIL PROTECTED] wrote: > > PHP's mysql_fetch_array() fetches an associative as well as indexed array...or you > can specify which. (I'm a huge fan of perl, btw, and have used it to talk to > mysql when PHP was just a baby language so no f

Re: DBI-1.18.tar.gz Can't gzip -cd

2001-09-14 Thread Colin Faber
I would even suggest not using zcat given the solaris version only examins .Z files. try: cat DBI-1.18.tar.gz | gunzip - | tar xvf - this should work on all versions of solaris any just about any other unix (assuming gzip is installed with a working tar) "Adams, Bill TQO" wrote: > > rjtalb

Re: EMS MySQL Manager 0.92 released

2001-09-17 Thread Colin Faber
No problems here, Possibly mailing list issues? Peter Harvey wrote: > > Ok... this is getting out of hand. Is it just me or are we getting a posting > every week on this? > > Please keep these postings to majour releases (1.0, 2.0, etc)... at most. > Post your minor releases to your own maili

Re: Error From Web Site

2001-09-18 Thread Colin Faber
Try the PHP list, This is not a MySQL error. "System Administrator a.k.a. The Root of the Problem" wrote: > > I am getting a > > Warning: Supplied argument is not a valid MySQL result resource in > /usr/home/tsguide/html/ssi/phpfunctions.php on line 48 > > No results were found ... > > Point

Re: Illegal table names

2001-09-20 Thread Colin Faber
you can try DROP TABLE `table name`; Håkan Elmqvist wrote: > > By accident, I don't know how (perhaps microsoft played me a trick), I > managed to create a table with a name containing spaces i. e. a useless > table with an illegal name. > Now would like to drop that table. Is there anyone w

Re: Illegal table names

2001-09-20 Thread Colin Faber
forward ticks Håkan Elmqvist wrote: > > Thanks for your very rapid response but: > > mysql> show tables; > +--+ > | Tables_in_test | > +--+ > | personer | > | resultat impl VT2001 | > | tentamen_impl_vt2001 | > +--+

Re: Illegal table names

2001-09-20 Thread Colin Faber
if all else fails shut the db down and go in your db directory and just delete the data files ;-) Håkan Elmqvist wrote: > > mysql> drop `resultat impl VT2001`; > ERROR 1064: You have an error in your SQL syntax near 'resultat impl > VT2001`' at line 1 > I don't seem to have the proper character

Re: PHP variable conversion problem.

2001-09-20 Thread Colin Faber
This really isn't a MySQL question and should be handled by another list, But to answer your question (logically). You need to have the whole string `productcategory.ID=\"$cat\"' optional, so that if your variable `$cat' isn't populated the string `productcategory.ID=\"$cat\"' isn't included, Al

Re: Mysql List Bounce Message?

2001-09-21 Thread Colin Faber
As near as I can figure there are a few people out there that have yet to setup their MTA's correctly, so they think they're receiving messages for any addresses in the headers of the email. Jason Frisvold wrote: > > Can anyone explain why I'm getting a "Mail account is disabled" message from

Re: Mysql List Bounce Message?

2001-09-21 Thread Colin Faber
Also, a simple fix for you sendmail guru's HFrom: $>check_from Scheck_from [EMAIL PROTECTED] $#error $@ 5.5.5 $: "Broken MTA, Message ignored" Cheers. Colin Faber wrote: > > As near as I can figure there are a few people out there that have yet > to setup the

Re: strange error message

2001-09-30 Thread Colin Faber
run the perror app provided with your distrobution perror 13 Casey Tourangeau wrote: > > Hi, > > I'm using MySQL v3.23.42 with Mac OS 10.1, and whenever I try to > create a database (logged in as root), i get the error "create database > 'name'. (errno: 13)". > > Does anyone h

Re: repost: Too many open files

2001-10-02 Thread Colin Faber
it sounds like you've run out of file descriptors, I suggest rebuilding your kernel to handle more. In a bsd kernel you can do this simply by upping the maximum number of users allowed to access the machine at any given time. Robin Keech wrote: > > Hi, > > Any help would be greatly appreciat

Re: Yes or No

2001-10-04 Thread Colin Faber
I fail to see why ENUM() isn't used in this case, This is exacly what its for. Carl Troein wrote: > > Benjamin Pflugmann writes: > > > Hi. > > > > On Tue, Oct 02, 2001 at 09:33:53AM +, [EMAIL PROTECTED] wrote: > > [...] > > > I've seen rumors about bool being an alias for tinyint(1), but

  1   2   >