Linking a Form

2001-08-02 Thread Mark A. Perez
Hello, I am creating a web based table that when users request or want information they list the information in a form. This works great but the problem I am having is that I cannot link MySQL table with the form. I am using FrontPage 2000 and the only tables that it wants to create are result

Re: Crazy Threads

2001-08-02 Thread Jeremy Zawodny
On Wed, Aug 01, 2001 at 10:46:39PM -0500, Chris Hilbert wrote: I noticed an issue with MySQL v3.23.40 on my Linux box where after a random amount of time (usually over an hour) MySQL runs a hell of a lot of threads for no apparent reason. I watched it when i ran mysqladmin -uroot -i 5

Re: Fwd: This Ad Really Works!!!

2001-08-02 Thread Colin Faber
Is the filter no longer working? snip bullshit spam PS database - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

Re: Linking a Form

2001-08-02 Thread shawn reed
mark, you need to actually write the code somehow in frontpage. i've not dealt w/ frontpage in a LONG time (mainly cos i can't stand it, but that's personal opinion so i'll refrain from commenting) ... but i believe there is a way you can write raw html or php code in there somewhere. that

Re: Fwd: Re: win32 build process docs (was: Re: Why can't I compile the mysql workspace?)

2001-08-02 Thread Miguel Angel Solórzano
At 10:08 01/08/2001 +0200, Cynic wrote: Hi Cynic, Hi Miguel, I'm forwarding you this as suggested by John Dean. Can you comment? First I agree with you that is necessary to introduce in our literature the instructions how to build from the source the MySQL Win32 stuff. However in my opinion,

Re: MySQL Client Software

2001-08-02 Thread Sommai Fongnamthip
Mysqlfront from www.mysqlfront.de and ursql from http://www.urbanresearch.com/ Sommai Fongnamthip At 11:46 1/8/2001 -0700, Faiz Khan wrote: Hi there, I am having problem finding MySQL Client software to connect to Web Hosts server so i can create tables and run queries at their server

Re: Version question...

2001-08-02 Thread Sommai Fongnamthip
3.23.40 is stable on Linux too. At 18:46 1/8/2001 -0500, Gerald R. Jensen wrote: Garth: I would go for the current version (3.23.39a). The current version went on the stable list a long time ago, and has a boat-load of function/featur eimprovements that either did not exist in 3.22.xx or were

Full text indexing

2001-08-02 Thread Simon Jones
Hi all, I'm new to mysql and I am interested in using the fulltext search feature. Is it possible to match a search term with two indexed columns from different tables, or do I have to use separate queries? Any help would be much appreciated. Simon

Re: Newbie need help on MySQL on RH 7.1

2001-08-02 Thread Mario Witte
On Wed, Aug 01, 2001 at 08:19:45PM -0400, Stonix wrote: Hi, I installed a RH 7.1, and I installed all the packages for apache, php and mysql. I don't know how to check if mysql server is running. On my machine cannot connect to mysql server. Hi, try executing the following command: ps

Re: MySQL Client Software

2001-08-02 Thread sarahana
What does this error mean? I ran a simple connect query just to check if mysql is there, and now I know it is cause i ran phpinfo(): Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) thanks.

Re: Fwd: This Ad Really Works!!!

2001-08-02 Thread Matt Wagner
Colin Faber writes: Is the filter no longer working? We're looking into it. The problem is that I wasn't the one who monkeyed with the new query,database,table goodword filter. Sasha did this. I have mailed him about it already. Hopefully he'll have time to look at it later today.

Re: [Got error 139 from table handler using InnoDB]

2001-08-02 Thread Heikki Tuuri
Brian, the support for 8000 byte rows in InnoDB is not yet in binary distributions of MySQL. To use 4 GB rows you have to download InnoDB-3.23.39b source from www.innodb.com replace it to MySQL-3.23.40 (or .39) source and recompile. I am right now compiling and testing the new InnoDB-3.23.40b

Re: mySQLd won't die under Darwin (Mac OS X 10.0.4)

2001-08-02 Thread Mark Tully
Can you check with mysqladmin proc in which state were connections after shutdown ?? mark@localhost:/usr/local/mysql/bin mysqladmin -uroot -psql proc ++--+---+--+-+--+---+--- ---+ | Id | User | Host | db | Command | Time | State

Re: Host Access denied

2001-08-02 Thread Mike
Thank you, but with a little more investigation I figured out that when logging in from different hosts, even using the same user/passwd, is counted as two diferent users. Therefore I had to insert (or in my case update) the user@Bob into the user table with the particular privys. Take care.

Select

2001-08-02 Thread Augusto Cesar Castoldi
HelpHi. I have a colun in my table for the birthday.: DD/MM/. It's varchar. In PHP, I can get the month of date, bu substr($date, 3, 2). (MM) Can I do a select with %LIKE% but saying the position of the varchar I want to find? thanks. Augusto

Needs earlier versions of mysql.

2001-08-02 Thread Vinh Cao
Hi There, I am in need the earlier version of mysql. The version number is: 3.23.30-gamma. Due to the fact that we have this version on one of our server and now we need a test server with the same version so I can import all mysql database into it. If you know where I can get this

Re: State: Writing to net

2001-08-02 Thread mike cullerton
being a network guy at heart, i'd like to see what tcpdump says is going over the ethernet card (if anything). does there appear to be traffic moving between the two machines, or is it caught in a buffer somewhere and hasn't even made it to the cable. since ftp works well, i'm guessing it isn't

Re: State: Writing to net

2001-08-02 Thread Grigory Bakunov
Date |Thu, 2 Aug 2001 12:19:52 -0400 From |Ravi Raman [EMAIL PROTECTED] Hello! RR hi. RR quick question... RR i have a simple query that returns ~53000 rows. RR when connected to the mysql server from localhost, this query takes about 2 RR seconds. RR when connected to the mysql server from

new user privileges

2001-08-02 Thread Stonix
Hi, I'm new in mysql admin. I have question on create new user. Suppose I have created a database called 'abcdb'. Now I want to add a new user with full privileges on only 'abcdb'. How should I do? I tried 'grant all privileges on abcdb.*' but still the new user has the superuser privileges.

Re: Problem compiling on HPUX 10.20

2001-08-02 Thread Sinisa Milivojevic
Ing. Gustavo Edelstein writes: Hi Sinisa, I've downloaded the gnu make, installed it OK and tried to compile again MySQL. This is the new err msg: make[1]: Entering directory `/usr/local/mysql-3.22.32/sql/share' make[1]: Nothing to be done for `all'. make[1]: Leaving directory

Query Acting Weird

2001-08-02 Thread Adam Douglas
I have a group of 3 queries that's used to find our representative for Unitary, Applied and Wholesale based on a Zip Code. This all is executed through PHP to MySQL. The three queries work fine and get the results I want. The problem is the 3 queries seem to work one minute but not the next. You

Re: Replicating or Not to Replicating that is the question

2001-08-02 Thread Jeff Hoover
You should see the changes right away. What did you put in the my.cnf file on the slave? Also, a good way to trouble shoot is to type show master status on the master and show slave status on the slave and compare the results. These commands should be typed at a MySQL command prompt.

Dedicated MySQL Application Server

2001-08-02 Thread Bryan Ross
Hi. What I want to do is this: Use mysql as a dedicated database for a desktop application, meaning that basically there's only one client allowed to connect to it, and that client is the application. Also, I would not want this database to interfere with any other instance of MySQL that may be

Mysql - Perl -DBI cannot work??

2001-08-02 Thread TestMonster
I just installed DBI module and try to run a cgi script from browser to access Mysql Database. The browser responsed with Internal Error From the /var/httpd/error_log it says Caught SIGTERM, shutting down Warning: user directive in VirtualHost requires SUEXEC wrapper. What is that means??

Re: Newbie need help on MySQL on RH 7.1

2001-08-02 Thread Grigory Bakunov
Date |Wed, 1 Aug 2001 20:19:45 -0400 From |Stonix [EMAIL PROTECTED] Hello! S Hi, S I installed a RH 7.1, and I installed all the packages for S apache, php and mysql. I don't know how to check if mysql S server is running. On my machine cannot connect to mysql S server. S Thanks in advance