Re: Fulltext index on a mediumblob column?

Thanks Paul - it worked perfectly. And for anyone else listening, modifying the table did not adversely affect the data (although I did back up just in case). --Aaron On 11/1/02 7:34 PM, "Paul DuBois" <[EMAIL PROTECTED]> wrote: > At 15:25 -0600 11/1/02, Aaron Merrick wrote: >> Ladies & Gentleme

Simple Linux RPM error question

I'm attempting to install the following Linux RPMs: MySQL-3.23.53a-1.i386.rpmMySQL-client-3.23.53a-1.i386.rpm MySQL-Max-3.23.53a-1.i386.rpmMySQL-devel-3.23.53a-1.i386.rpm MySQL-bench-3.23.53a-1.i386.rpm MySQL-shared-3.23.53a-1.i386.rpm When I do so I get the following error: rpm -iv

mi_test_all error help

I am using BSDI 4.3, and downloaded MySql source code 3.23.53. After untarring it, it passed ./configure --prefix=/usr/local/mysql. But when I run make, finally it says make: don't know how to make mi_test_all. Stop *** Error code 1 Your help will be appreciated Shawn Xu ___

mysql not working behind linksys router

Hi, apologies upfront since this is not directly a mysql question. I have a mysql host sitting behind a linksys router/wireless ap. The mysql host is configured as a DMZ host in the router. All web/ftp other connections are working fine, however mysql connection from outside the network is not

creating related tables

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all -- I would like to create a couple of related tables (just for starters) but I can't figure out how to do it; there are lots of CREATE TABLE examples in the mysql manual but nothing that shows related columns. For instance, I'd have a client

Re: MySQL 4.0.5(a) is released

Stefan, Lenz, et al., May I suggest, for backward compatibility, obsolescing the 'safe_show_database' variable (a NOOP) instead of removing it? Also, IMPO, it is better practice to grant each customer's user access to their own database(s). Each customer's rights can then be specifically manage

Re: MySQL 4.0.5(a) is released

Stefan, Lenz, et al., May I suggest, for backward compatibility, obsolescing the variable (NOOP) instead of removing it. Happy Holidays. :-) ==_-+- Steve - Original Message - From: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]> To: "Lenz Grimmer" <[EMAIL PROTECTED]>; "MySQL anno

Re: attempting to use DATE_FORMAT function in a SELECT STATEMENT

Thanks very much Robert, that worked. I was surprised at the effect of the '*'. Best regards, Nicole Robert Kostko wrote: Hi, Nicole IMHO after * all additional field statements "DATE_FORMAT(date_rec,'%Y-%m-%d %T')" are ignored. Try to list all neccessary fields after SELECT and give an a

Re: sarnia - problem one solved

This is the list of fields, originally there are over 80 fields, but I cut it down. Go to our website to see what I am doing right now, making them .htm pages so EXCITE can search on them. I put all 800 entries into ASK SAM and tried to export as a csv file, but won't do over one line per field. T

Re: Help Transferring Data from MS Access to mySQL

At 04:12 PM 11/30/02, you wrote: I've pretty much resigned myself to writing some kind of script to manually export these records using some kind of unique record delimiter, but I thought I'd check and see if anyone has any other better ideas on how to get my data transferred. You'll find all ki

Help Transferring Data from MS Access to mySQL

I'm very new to mysql and haven't got much of a background in databases generally, so thanks in advance to any who have the patience to deal with my question. I'm trying to get data from ms access 97 to mysql by exporting to a text file then using the "load data" command to import it. The data in

OT: what list software is this?

Okay, okay -- before anyone else bothers to email me, the answer is right in the header. Doh! :-) I really did glance at the headers, but it slipped by me! SQL -- : Jan Steinman -- nature Transography(TM): : Bytesmiths -- artists' services:

mysql join problem (bug?)

Hi all, I found this join problem using mysql 3.23.53-max-nt (on WinXP). It works fine on MySQL 3.23.52-log (on Linux). Could someone please confirm that it is a bug? Or enlighten me on writing the correct sql? I have a table and data as shown in the script below. CREATE TABLE t

Re: Innob next-key locking, please help!

Joao, - Original Message - From: "João Borsoi" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Sunday, December 01, 2002 1:20 AM Subject: Innob next-key locking, please help! > Hello, > > I have a question about Innob next-key locking. I'm using mysql 3.23.49. > The followin

Innob next-key locking, please help!

Hello, I have a question about Innob next-key locking. I'm using mysql 3.23.49. The following is writen on the manual: "You can use the next-key locking to implement a uniqueness check in your application: if you read your data in share mode and do not see a duplicate for a row you are going to i

attempting to use DATE_FORMAT function in a SELECT STATEMENT

I am trying to format a TIMESTAMP column on output by using the DATE_FORMAT() function: Can someone tell me why this does not change the format - no error message - just does not do anything? $sql = "SELECT * from arviContacts WHERE fid=$zz AND DATE_FORMAT(date_rec,'%Y-%m-%d %T');" I have als

Re: fatal error

compile php with mysql-support, i.e. configure --with-mysql and so on. If you are on a redhat system and using the installed apache-webserver, then there should be a package php-mysql*.rpm or similar which needs to be installed. Thats not a real mysql-problem. ;-) Thomas On Sun, 1 Dec 2002 07

fatal error

Hi all, I'm not really sure if I'm posting this to the right list or not, but I've recently installed mysql on a Linux machine in order to learn some mysql/php stuff. However, I've obviously configured something wrongly and can't work out what. The output i get when I try to do anything mysql-ish

Re: Multiple indexed images or property id or both

Greetings mysql gurus! I have a client who has specified using 5 fields, each indexed with an image id. Would it be better to have a separate table using image urls, with each set of images using the corresponding property id? I'm not clear why he wants to index the image ids. Thanks.

default mySQL buffer cache size

Hello, We want to know the default buffer cache size that mySQL uses with the traditional Myisam tables...that is, when it does not rely on bdb for buffer management? Do you know what that is? Actually, we would also be interested in the bdb_cache_size? Thanks, Laura

Re: backing up mySQL database ?

OK ... but you newed to work this out with you ISP. Create a shell script, and place it in the server's path: # #!/bin/sh # Create /dbbakup directory # $1 = Unix/MySQL Username # $2 = Unix/MySQL Password if [ ! -e /dbbakup ] then

Multiple Inserts and updates

Can anyone give me an example of how to insert and/or update multiple records in the same table simultaneously? I have a table with three fields; ID, PartNum, Qty. The user enters PartNum and Qty data in an unbound grid UI. When the user hits "Save" I'd like to build a single SQL statement from th

Re: sarnia - problem one solved

In my previous posting, I misspelled a name: Paul Dubois should be Paul DuBois. Sorry about that - I should know by now. -- /* All outgoing email scanned by Norton Antivirus 2002 */ Amer Neely, Softouch Information Services W: www.softouch.on.ca E: [EMAIL PROTECTED] V: 519.438.5887 Perl | PHP | M

Re: Complex Query

this doesnt do the trick as it will produce a table containing the following columns: 1- stations.name 2- invitations.invitation_status 3- count(*) , which is the count of the number of invitations which have this status for this particular stations. this is not what i need, the output should be s

MySQL & Mandrake 9.0

Hi all I am trying to follow the guide "HOWTO provide Microsoft Access-like functionality on Linux with open-source tools - OpenOffice.org 1.0, unixODBC, and MySQL" @ http://www.unixodbc.org/doc/OOoMySQL.pdf. Got past the first few obstacles, (f)lex & (b)yacc not installed. Just want to know if

Re: sarnia - problem one solved

> The pest from Sarnia. > I think I solved the first problem, made them as a csv file, but my DOS > program will only write 64 characters per line (doesn't csv have to be > on one line)?? > I have a few records with over 3,000 characters. > > Still haven't figure out how to use MySQL. > Would it b

Synchronizing MySQL Databases >> HELP NEEDED

I am currently developing a website that would use a MySQL database to store data. The company using this website would require users to be able to make changes to information on the site (LIVE - database on webserver), but they would also need to be able to make changes on their copy (which is of

Re: Select: JOIN magic?

try aliasing your right table twice and join it both ways. something like: select award.*, a.name, b.name from ( award left join user a on award.uid = a.uid) left join user b on award.uid = b.uid if you have a windows box to use as a front end, download a copy of corereader to help you devel

RE: Select: JOIN magic?

SELECT t1.name AS Nomi, t2.name AS Propo FROM award t0 INNER JOIN user t1 ON t0.nominee=t1.uid INNER JOIN user t2 ON t0.proposer=t2.uid > -Original Message- > From: Michael Carter [mailto:[EMAIL PROTECTED]] > Sent: Saturday, November 30, 2002 11:51 AM > To: [EMAIL PROTECTED] > Subject: Se

Re: backing up mySQL database ?

I rent my mySQL database from my ISP would this be a problem ? Maybe you provide me with a simple example ? Since I'm very new to mySQL and have no knowledge of unix. Thanks Neil From: "Gerald R. Jensen" <[EMAIL PROTECTED]> Reply-To: "Gerald R. Jensen" <[EMAIL PROTECTED]> To: "Neil Tompkin

OT: what list software is this?

I'm getting ready to set up a list server, and I very much like the way this list orders topics by thread in the digest. Can someone who knows tell me what list software is being used? Or if you have an alternate suggestion that can be set up to order digests by thread, let me know? I'll be run

Re: backing up mySQL database ?

You don't have to develop or buy anything. You can use mysqldump in conjunction with a shell script to do what you want, and automate it with either the Windows Scheduler (on Win32) or a cronjob (Linux, *nix). - Original Message - From: "Neil Tompkins" <[EMAIL PROTECTED]> To: <[EMAIL PROTEC

Re: backing up mySQL database ?

I might be totally off track here, but a simple shell script works fine for me. /bin/sh, tar, and cron are a powerful team. --Joe -- Joe Stump Affordable Computers, Inc. 800-864-2345 x113 - Original Message - From: "Neil Tompkins" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturd

Select: JOIN magic?

Hello. I'm trying to select and display from a couple tables I have. I have an awards table, which has info on an award a user has earned. I've also a user table which lists all the users. What I'm trying to do is display information about an award, but can't find the right SELECT syntax to make

backing up mySQL database ?

Hello, I'm looking to either development a software application that will allow me to automatically at scheduled intervals backup my mySQL databases. I would like to save the table structures and data. I;ve used mySQL Front that allows you to backup these, but I need it to be automated e.g ev

RE: No port listed

what you can do is check if port 3306 is listening try lsof -i :3306 and about connecting to a remote mysql server via the -h switch check your firewall to see if your IP or whatever you specify is allowed to connect to the mysql server. If it is not that try and add a -u and -p switch to the com

Re: Date()

> Is it possible for mySQL to recognize and compare dates written in this > format: MM/DD/YY? =the short answer is yes and no: "yes" it can be done by combining various SQL/MySQL functions, but "no" there is no easy 'built-in' method. > I know standard date format for mySQL is YYY-MM-DD, but I n

Re: [OT] LEGAL information about MySQL.

Hello. I do not intent to follow-up on the issue, as you are either trolling or clueless (and not willing to inform yourself) or both. On Sat 2002-11-30 at 08:30:52 -0500, [EMAIL PROTECTED] wrote: > Seems like all against I see are coming from MySQL team. But I want to prevent a misconception: I

Re: [OT] [FYI] All Innovative Product Inventors

ENOUGH ALREADY!!! Either take this inane exchange to private ranting or to a more appropriate forum. DET MySQL, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

[FYI] All Innovative Product Inventors

The following is the copyright note for PostgreSQL. That's simple and you can avoid all the obstacles to invent your products. It's free. Pae // # PostgreSQL Copyright ## PostgreSQL Database Management System (formerly known as Postgres, then as Postgres

Re: [OT] LEGAL information about MySQL.

Seems like all against I see are coming from MySQL team. I know MySQL is stealing a lot of code from the public domain, inclduing the SSL part. How funny! I already mentioned in the previous message. I am only encouraging the people to create more innovative works, and Open Source based product te

Re: [OT] LEGAL information about MySQL.

Hi. On Sat 2002-11-30 at 06:43:11 -0500, [EMAIL PROTECTED] wrote: > Didn't you the previous posting that contains two paragraphs > from GPL? I saw these paragraphs. How do they relate to anything of this discussion? They are taken out of context from the Preamble of the license and only state som

Re: [OT] LEGAL information about MySQL.

No. You are complete WRONG. I am encouraging people who trying to sell their own products same as GPL. So I am in the same line. In addition, I am not expecting anyone has to agree with me. That includes you as well. And do not accuse me in such comment. You are starting the flame. This is a warn

Re: [OT] LEGAL information about MySQL.

On Sat, 2002-11-30 at 14:46, Pae Choi wrote: > If MySQL plays so dirty, go with PostgreSQL. It's been known > to be better and more acceptable in all platforms. Ex, they > have triggers, etc that MySQL does not have. FUD. I pointed to information of FSF and people not related to MySQL. Seems l

Re: [OT] LEGAL information about MySQL.

One final thouhgt for the people who wish to sell your own products. You can distribute your own products, but let your customers download the GPL packages. In that way, you are not distributing that. And you can include your license saying that something like any utilziation of third-party packa

Re: [OT] LEGAL information about MySQL.

If MySQL plays so dirty, go with PostgreSQL. It's been known to be better and more acceptable in all platforms. Ex, they have triggers, etc that MySQL does not have. Pae - Original Message - From: "Tonu Samuel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, November 30,

Re: LEGAL information about MySQL.

I do not know about MySQL marketing strategies. But as far as GPL goes, it even encourge to sell. "Does the GPL allow me to sell copies of the program for money? Yes, the GPL allows everyone to do this. The [1]right to sell copies is part of the definition of free software. Except in one special

Re: Innodb Hash search

Tony, - Original Message - From: "³Â ½­Äþ" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, November 29, 2002 8:08 AM Subject: Innodb Hash search > hi, > I now test Mysql+innodb performance, my platform is Solarise 5.8 1G RAM . >I use my-huge.cnf, set the bu

Re: [OT] LEGAL information about MySQL.

All who haven't read GPL FAQ, go and read it: http://www.fsf.org/licenses/gpl-faq.html Current discussion is covered beginning from: http://www.fsf.org/licenses/gpl-faq.html#ModifiedJustBinary http://www.fsf.org/philosophy/free-sw.html Also, discussion here reminded me MySQL vs Progress case wh

Re: getting InnoDB running on windows 2000

Bruce, - Original Message - From: "OS2000" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Saturday, November 30, 2002 9:11 AM Subject: getting InnoDB running on windows 2000 > > I have mysql running using its standard myisam database. > > The server is version 3.23.39-max,

Re: Enforcement of foreign keys

Paul, - Original Message - From: "Paul Vincent Craven" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Saturday, November 30, 2002 6:32 AM Subject: Enforcement of foreign keys > Shouldn't the following be illegal? > > drop database registry; > create database registry; > use

Re: LEGAL information about MySQL.

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Pae Choi wrote: mysql, sql, query What you advocate is the same as saying that you if stick a pirated copy of windows in with your software, but disclaim in your documentation that you're only paying for your software, not the copy of windows that

Re: [OT] LEGAL information about MySQL.

Didn't you the previous posting that contains two paragraphs from GPL? And if someone wants to sell the software that use the MySQL, then simply let them downlaod it. Then you will be out of this crap. Also, PostgreSQL will be your alternative option as well. Pae P.S.: There are many commercia

Re: [OT] LEGAL information about MySQL.

Hello. This is quickly heading towards off-topic. If you are interested in a discussion of what the GPL means, a different forum would be more adequate, I think. I do not necessarily completely agree with MySQL AB's interpretation of the GPL, but since it's their product, I am fine with it. But

Re: LEGAL information about MySQL.

- Original Message - From: "Mark Matthews" <[EMAIL PROTECTED]> To: "Pae Choi" <[EMAIL PROTECTED]> Cc: "Tonu Samuel" <[EMAIL PROTECTED]>; "Darney Lampert" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, November 30, 2002 5:30 AM Subject: Re: LEGAL information about MySQL. > If you

Re: LEGAL information about MySQL.

mysql, sql, query > > What you advocate is the same as saying that you if stick a pirated copy > of windows in with your software, but disclaim in your documentation > that you're only paying for your software, not the copy of windows that > is not following Microsoft's licensing terms. > Your ex

Re: LEGAL information about MySQL.

I know the GPL and seen many commercial software using the software and/or tool under GPL. Btw, which paragraph are you referring to? Pae > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Pae Choi wrote: > > If your software utilize the software under GPL license, you can > > simply add th