Re: Failure to enforce length of fields to index corrupts tables

2001-11-28 Thread Matt Johnson
for your help! -- Matt Johnson [EMAIL PROTECTED] Developer AVSIM Online! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread

Newsgroups

2001-10-29 Thread Matt Sellers
specific post! Personally I would find this MUCH easier to manage and would be as helpful or more so. Matt Sellers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

MS Access Front end with MySQL Back-end

2001-10-26 Thread Matt Sellers
version: 3.23.38-nt MySQL ODBC ver 2.50.37.00 Thanks, Matt Sellers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: Features in 4.0

2001-09-26 Thread Matt Wagner
TABLE question, please direct this question to Sasha Pachev ([EMAIL PROTECTED]). Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr

Re: Obtaining MySQL for Solaris 8, Intel Version

2001-09-26 Thread Matt Wagner
(with transactions): http://www.mysql.com/downloads/mysql-max-3.23.html Both are found in the Solaris section. Regards, Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED

Re: Mysql as backend for email ?!?

2001-09-22 Thread Matt Wagner
'mail_to_db.pl' in the 'tests/' subdirectory. This script is exactly what you are looking for. You can either pipe mails to it one by one as they come into your system, or you can feed it mailbox files. Matt -- For technical support contracts, visit https://order.mysql.com

Re: Mysql List Bounce Message?

2001-09-22 Thread Matt Wagner
at domainhost.com and they say they are working on it. :-\ Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor

Re: [fwd] 123box.co.uk mail delivery system (from: MAILER-DAEMON@123box.co.uk)

2001-09-20 Thread Matt Wagner
Alexander Skwar writes: sql Could this user please be removed? It's [EMAIL PROTECTED] Done. -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL

trying to reset auto-increment

2001-09-16 Thread matt
I manually entered into my database several rows with high values in the auto-increment column. I subsequently deleted the high value rows. I now am trying to reset the auto-increment. How do I reset it to the Max of the currently existing values? -matt [EMAIL PROTECTED

Re: creating tables using a number THIS IS A BUG

2001-09-14 Thread Matt Wagner
/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA ___/ www.mysql.com

slave_net_timeout?

2001-09-13 Thread matt
that. There is, however, a variable named 'slave_net_timeout.' I'm guessing that's the same thing? Looks like that manual ought to say ... set-variable = slave_net_timeout=# ... instead. Please CC me on any replies as I'm not subscribed to this list. - Matt

Re: XML Support

2001-09-04 Thread Matt Wagner
' option) to equate to the current HTML output functionality. I will also try to add XML output functionality to the 'mysqldump' utility in 4.0. Although this may have to wait until 4.1. On my long-range TODO I would like to contact people like Matt Sergeant (of Perl XML/AxKit fame) to see what features

Re: Problems getting into MySQL.com

2001-08-29 Thread Matt Wagner
Philip Daggett writes: Is anybody else not able to get onto mysql.com??? Hi, We're working on it. The eth card seems to have bombed, and the admins at our hosting facility (andover, where slashdot and freshmeat are) are working on it ASAP. Matt -- For technical support contracts, visit

Re: fwd: What is Pupport ? :)

2001-08-28 Thread Matt Wagner
Hi, Damn you guys are fast! :) Fixed. But the udmsearch is busted right now for unknown reasons. I will fix shortly. Matt Jeremy Zawodny writes: FYI... - Forwarded message from Sam Masiello [EMAIL PROTECTED] - From: Sam Masiello [EMAIL PROTECTED] To: MySQL General

Re: MySQL Documentation - how do you do it ?

2001-08-19 Thread Matt Wagner
detail how both of his programs work. You could probably also prod him into giving you copies, as he's been meaning to release them publicly for some time now. Matt On Thu, Aug 16, 2001 at 09:47:30AM +0100, David Herring wrote: Good morning, Does anyone have any details on the how

Re: Got and mirrored it... (Re: MySQL-MAX 3.23.41 download link is dead... (need a download))

2001-08-17 Thread Matt Wagner
Matt Wagner writes: Matt Wagner writes: Jeremy Zawodny writes: On Thu, Aug 16, 2001 at 06:00:16PM -0700, Jeremy Zawodny wrote: Does anyone have the latest 3.23.41 I could grab a copy of? I managed to fetch it from ftp.mysql.com. A copy is now available here as well

Re: Got and mirrored it... (Re: MySQL-MAX 3.23.41 download link is dead... (need a download))

2001-08-16 Thread Matt Wagner
(!) now. :( I have mailed the SourceForge admins to ask if they can fix this. Sorry for the inconvenience! Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED

MySql and PHP

2001-08-07 Thread Matt Gaskin
Hi All Currently I have rented space on a Web Server that has MySql installed and PHP, They have created a database directory for myself. Do I need to install Mysql and PHP locally to take advantage of this. If so where do I start. I have had no experience of the above two products, although I

Re: Fwd: This Ad Really Works!!!

2001-08-02 Thread Matt Wagner
. Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA

Re: [fwd] Returned mail: Host unknown (Name server: mailserv: host not found) (from: MAILER-DAEMON@host2.webprovider.net)

2001-07-27 Thread Matt Wagner
Hi, I have removed '[EMAIL PROTECTED]'. Matt Alexander Skwar writes: Hi! Could someone please do anything about this? - Forwarded message from Mail Delivery Subsystem [EMAIL PROTECTED] - From: [EMAIL PROTECTED] (Mail Delivery Subsystem) Date: Thu, 26 Jul 2001 19:06:21

Re: Urgent Help needed for installing

2001-07-25 Thread Matt Wagner
by default?? Come find out it doesn't!! Is there something else that needs to be done during the install to enable BDB table handlers?? Hi, Please read: http://www.mysql.com/doc/B/D/BDB_install.html Regards, Matt -- For technical support contracts, visit https://order.mysql.com

Testing

2001-07-24 Thread Matt Wagner
Is this working again? -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA

Re: MS-DOS

2001-07-05 Thread Matt \TrollBoy\ Wiseman
WinME has this built right in, elsewise try doskey Matt TrollBoy Wiseman Webmaster: Shoggoth.net Site Designer: phpslash.org The oldest and strongest emotion of mankind is fear, and the oldest and strongest kind of fear is fear of the unknown. -H.P. Lovecraft

Unique select

2001-06-28 Thread Matt \TrollBoy\ Wiseman
| +-+--+ | greenfish | blah| +-+--+ | redfish | blah| +-+--+ I want it to return only bluefish,redfish,greenfish when I make a query on the first field. Does anyone know how this is possible? Matt TrollBoy Wiseman Webmaster: Shoggoth.net

Re: gui

2001-06-21 Thread Matt \TrollBoy\ Wiseman
check out mysqlfront. You can download it from download.com and it kicks some major ass.. Matt TrollBoy Wiseman Webmaster: Shoggoth.net Site Designer: phpslash.org The oldest and strongest emotion of mankind is fear, and the oldest and strongest kind of fear is fear of the unknown. -H.P

order by rand() question

2001-06-15 Thread Matt Heaton
() operation works? I can't find a specification out there for it. Thanks, Matt Heaton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: Making SQL request from a Mac

2001-06-14 Thread Matt \TrollBoy\ Wiseman
I see you're mailing the ODBC lists as well, that may very well be your answer. Mind you I'm not familiar with Mac Programming, however, why not open a odbc connnection to your DB. You can do it with MS Access on windows easy enough, why not on a Mac? Matt Trollboy Wiseman www.shoggoth.net

Question about order by rand()

2001-06-13 Thread Matt Heaton
a single row FAST even if a bunch of rows match. Let me know if you have any ideas. Thanks, Matt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Table Creation woes

2001-06-06 Thread Matt \TrollBoy\ Wiseman
can someone tell me what I'm doing wrong here?I keep getting the error You have an error in your SQL syntax near 'describe text, fulltext text, section VARCHAR (32) DEFAULT '0', type VARCHAR' at line 6 and I don't understand why: CREATE TABLE article( id INT (4) DEFAULT '0' NOT NULL

auto-increment and mysqldump

2001-05-31 Thread Matt Templeton
I've read the documentation but can't seem to find a clear answer to this... If I set up a table that has and auto-increment ID table and insert a number of records that are incremented in sequence. Then I delete, say the 5th and the 8th row and do a full (database creation and data)

What's the max number of records mysql can handle

2001-04-25 Thread Matt Benic
we're looking at implementing a system that will need to store an average of between 3 and 5 million records in the main table - we've decided interbase cant handle our volume-will mysql be able to do it? Matt Benic +27 72 182 6161 [EMAIL PROTECTED] http://i.am/mbenic

Re: Info on using MySQL with Java

2001-04-24 Thread Matt Yubin He
Professional JSP, by Wrox Press Ltd, is a quite good book. Matt - Original Message - From: Robert Alexander [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 24, 2001 2:48 PM Subject: Info on using MySQL with Java Hi all, I'm looking for some pointers towards some good

select question

2001-04-17 Thread Matt \TrollBoy\ Wiseman
How would I word a query to see what tables exist in a db that begin with box for example include boxTABLE1 boxTABLE2 boxTABLE3 but exclude sphereTABLE1 I'm basically trying lo populate a list box with the tables beginning with box in PHP. Matt "Trollboy" Wiseman www.shoggoth.ne

Re: BUG: Cannot DELETE all records with NULL entries in UNIQUE KEYfields

2001-04-09 Thread Matt Loschert
identical values (no matter what they are) into a field that is declared to be a unique key, the database should complain like crazy, if not completely disallow the action. In any case, thanks for the explanation. - Matt -- Matt Loschert | email: [EMAIL PROTECTED]| Software

Problems with Mysql on Sol7 i386

2001-04-04 Thread Matt Mueller
Hello, I am trying to install mysql version 3.23.26 on my sun machine running solaris 7. I have installed gnu make, tar, and gcc-version 2.95.2. I have also tried doing everything that is reccomended for my error such as editing config.cache and even using the reccomended configure line. The

binding to interface

2001-04-03 Thread Matt Pavlovich
via common storage device. Doing this would negate the need to bind multiple MySQL servers running on the same machine to different ports. Is this supported? Regards, Matt Pavlovich - Before posting, please check: http

Weird select with php

2001-03-07 Thread Matt \TrollBoy\ Wiseman
I'm attempting to do a select from my table, but the only odd thing is the customer wants the results to be completely random every time... is there anything like this?? $query = "SELECT * FROM members where Name like 'A%' ORDER BY random"; Matt "Trollboy" Wiseman www.s

help signing in

2001-02-28 Thread matt sword
I'm a new user and I bought a book PHP fast and easy web dev. I'm trying to sign in. The book instructs me to c:\mysql\bin then do mysqld --standalone I get a bad command error. What do I do? _ Get your FREE download of MSN Explorer

maximum number of characters

2001-02-22 Thread Matt Davis
Hi Can anybody tell me what the maximum number of characters I can have in one field. Thanks Matt. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: mysqldump output file not valid as input file for mysql client

2001-02-22 Thread Matt Loschert
How-To-Repeat: See above description. Fix: See above description. Submitter-Id: submitter ID Originator: Matt Loschert Organization: Matt Loschert| email: [EMAIL PROTECTED]| Software Engineer| w

Re: mysqldump output file not valid as input file for mysql client

2001-02-22 Thread Matt Loschert
On Thu, 22 Feb 2001, Sinisa Milivojevic wrote: Matt Loschert writes: On Thu, 22 Feb 2001, Sinisa Milivojevic wrote: [EMAIL PROTECTED] writes: Description: As of mysql 3.23.33, a dumpfile generated with mysqldump (using the flags: --opt --all

global search and replace

2001-02-20 Thread Matt Davis
I have an MySQL table in which one of the fields is a list of different catergorys. I want to change that catergory name to some thing else however it appears in my table just over 900 times. Is there any way I can do some sort of glabal search and replace in My SQL? Mat

SQL statement in PHP

2001-02-16 Thread Matt Davis
ain"; If I remove where Business_Type = "Consultancy" and Bassingbourn != "0" It work fine, but no variation of the above line works. Am I missing something really obvious. Please help as I am very quickly becoming bald. Matt. --

ASP and MySQL

2001-02-13 Thread Matt Davis
should get some. Should I not be using asp and if not what should I use, are there any applications for visual creation of these file types? Thanks Matt Davis. - Before posting, please check: http://www.mysql.com/manual.php

Strange Replication Problem in 3.23.33 (bug?)

2001-02-13 Thread Matt Hahnfeld
run "SET SQL_SLAVE_SKIP_COUNTER=0" on gromit. I just don't get it... Why are the skip counters being reset to thse crazy high numbers? Shouldn't both servers just replicate each other? Is this a replication bug? Please help! Matt Hahnfeld EverySoft

Need help with Install of MySQL

2001-02-09 Thread Matt Davis
k exists" I can not find any mysql processes running when I type "ps" and I cannot find any sock files anywhere. What am i doing wrong can somebody please please help. Thanks Matt Davis. - Before posting, pl

Re: Query Help

2001-02-06 Thread Matt Wagner
). Actually mysqlbug output would probably be desired, as this *may* be a bug in the optimizer. Also, please include the output from EXPLAIN on all the queries you have tried. http://www.mysql.com/doc/E/X/EXPLAIN.html Regards, Matt -- __ ___ ___ __ / |/ /_ __/ __/ _

200 DOLLARS FOR YOU

2001-02-02 Thread Matt Spears

Temporary Table problem

2001-01-27 Thread Matt Bailey
es on the temp table it still won't work - the table doesn't get created. If someone could help me out I'd be grateful! Matt _ Get your FREE download of MSN Explorer at htt

Re: PHP and MySQL combo

2001-01-19 Thread Matt Wagner
are probably looking for 'SHOW STATUS': http://www.mysql.com/doc/S/H/SHOW_STATUS.html And yes, if you are NOT using mysql_pconnect, the connection to your mysqld is closed each time. The 'p' in 'mysql_pconnect' is for "persistant" which avoids this problem. :) Regards,

Re: socket problem in red hat.

2001-01-19 Thread Matt Wagner
. Something is amiss. I will investigate more. Regards, Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA

Re: forwarded message from Brian Kaney

2001-01-18 Thread Matt Wagner
Sasha Pachev writes: cut We will add a stricter sanity check for the referers to work around the bugs in some browsers. Completo. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com

Re: [RedHat 6.2 RPM install: 'perl5', changing password]

2001-01-18 Thread Matt Wagner
everything verbatim as you stated above, then you the root password is currently (at your point of failure) set to nothing. So when the "Enter password:" prompt comes, just hit enter. After this, 'newpass' will take effect. Regards, Matt -- __ ___ ___ __ / |/

Re: fixed width

2001-01-18 Thread Matt Wagner
to MySQL using either the LOAD DATA INFILE syntax or the `mysqlimport' utility. Regards, Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___

Re: MySQL 3.23.31 configure fails with Berkeley DB 3.2.3h

2001-01-18 Thread Matt Wagner
me I don't have the proper version of the DB. Here are the last few lines from the configure output: This sounds similar to a problem that I reported a few hours ago to this list. Monty, MySQL dev team, any ideas ? I've forwarded Chris's report to bugs@. Regards,

Re: Fw: Mysql v3.23.30 make test failed ('select * from foo')

2001-01-15 Thread Matt Wagner
of the replication functionality (yet). Regards, Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA

importing a table

2001-01-15 Thread Matt Thoene
a .sql file. Is it possible? Also, is it possible to do an import of a database file without having to create the database first? I hope so since I'm not familiar with what the layout was of this .sql when it was sent to me. Thanks. -Matt

Re: Mysql privileges problem

2001-01-14 Thread Matt Wagner
id* do this before posting, my apologies... It was not very apparant that you had. :( Regards, Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wi

Re: rpm requires perl5 on redhat 7.0

2001-01-11 Thread Matt Wagner
for the *upcoming* 3.23.31 release. For now, you can just pass '--no-deps' to the RPM install command, and it should work. Regards, Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com

Re: [Make Crashes and Burns on myisam - Don't know how to make mi_test_all]

2001-01-10 Thread Matt Wagner
[EMAIL PROTECTED] writes: cut How-To-Repeat: As far as I know, just try building it on an i386 running BSDI 4.1 Sinisa, Who was the guy that just contributed the BSDI 4.2 tarball? Maybe he could give Aaron here some pointers. Matt

RE: Lazy

2001-01-10 Thread Matt Wagner
. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA ___/ Developer - Before posting, please check

<    2   3   4   5   6   7