DECIMAL math?

Since DECIMAL fields are stored as strings how are calculations performed? Does MySQL use string math routines or does it convert the string to a double and use the double for the calculation? The real question is, can floating point imprecision errors occur when using the DECIMAL type? Bill

Restoring from a mysqldump

I have a file produced by mysqldump and I need to restore it. Can someone point me toward the instructions on how to do this? Todd -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Granting privileges

I have installed Red Hat 9 and it installs MySQL. After logging on as root, I did the following: mysql mysql use mysql; mysql grant all - on * - to todd indentified by 'my_password' - with grant option; I then log out of mysql and log out as root. Logged in as "todd" I type the

Re: Granting privileges

Jamie - Two questions: 1) Does "grant all" give the user the rights to create a database. 2) What is the difference between "on * " and "on *.* " Todd Jamie Krasnoo wrote: You still need to flush the privileges. Changes in permissions are not automatica

Re: Granting privileges

Jamie - grant all on *.* to [EMAIL PROTECTED] identified by 'some_password' with grant all; flush privileges; That definitely works, but what I am not sure about is now -u todd -h localhost has all "Y" in the privileges; before only the first few had "Y". Why i

Re: Granting privileges

I did some experimenting and here is what I found: grant all - on * - to bugsbunny indentified by 'bugs - with grant option; After putting the above into MySQL as root, I signed on as "todd" with the appropriate PW and tried to get into mysql with mysql -u bugsbunny -p [

Re: Granting privileges

Roger - Thank you for taking the time to clarify that for me. I was using "PHP with MySQL" and they are not clear on the differences I found and you explained. Thanks again Todd Roger Baklund wrote: * Todd Cary I did some experimenting and here is wh

Re: select help

I'm new, too, so someone correct me if I'm wrong, but... if you make it an ENUM field in a table you can store it using the value in the selection, retrieve it as the same value, and still get all the advantages of numeric storage. Todd On Sunday, July 6, 2003, at 02:38 PM, Dan Cox wrote

Can't start MySQL on Mac OS X

I run mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Any ideas? Thanks, Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Can't start MySQL on Mac OS X

OK. I've verified that no mysqld is running using Egor's command from below, and by using netstat (which someone else suggested) there is nothing listening on port 3306. Any new ideas? Thanks, Todd On Wednesday, July 2, 2003, at 09:51 AM, Egor Egorov wrote: Todd O'Bryan [EMAIL PROTECTED

OS X downloads

There are two sets of binary downloads at mysql.com for Mac OS X. They're different sizes, but both say OS 10.2. Is that a typo? Is one of the two for OS 10.1, and could I have downloaded the wrong one and could that be the reason I can't get mysql to start? Todd -- MySQL General Mailing List

Re: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable

Do what it says: cd /usr/local/mysql ./bin/mysqld_safe and see if that's any better. Todd On Wednesday, July 2, 2003, at 05:18 PM, [EMAIL PROTECTED] wrote: Hi, I got the following message when trying to start the mysql instance: $ mysqld_safe [1] 22717 $ The file /usr/local

Re: Can't start MySQL on Mac OS X

I figured out what happened, though I don't know when it happened... I had screwed up the permissions for the /tmp/ directory, so the mysql user could not create the socket it needed there. A well-placed chmod and things are back in working order. Thanks to all for the suggestions, Todd

Re: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable

were at the limit of my knowledge when I told you to try cd-ing and re-typing the command) and I'm just throwing out possibilities... Todd On Wednesday, July 2, 2003, at 08:57 PM, [EMAIL PROTECTED] wrote: Todd, It didn't help. Here is the message: $ cd /usr/local/mysql $ ./bin

Dual / Single CPU

cpu? These boxes will be used mostly as readers (delayed inserts done thru replication). Thanks -- Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Dual / Single CPU

so mysql can take full advantage of the dual cpu w/out a recompile? Thanks --Todd On Mon, 30 Jun 2003, Mike Wexler wrote: Todd Burke wrote: Which is the better option to host mysqld: MACHINE A: 2.4 GHz CPU 1024 MB Ram 2x 18 GB SCSI HDD RAID 1 MACHINE B

Replication Performance

/ Is there any documentation on handling and configuring large tables? Hope this is not too confusing... Many thanks Todd Burke phbnyc.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

4.1 not using btree index on heap table on an UPDATE

Any reason why a SELECT which finds no matches returns instantly but an update which has the same where clause takes about 2 secs to return. explain reports that the select is exaninng 10 rows in a 300,000 row table. which is exactly what i am expecting. are there any know issues? -Todd

BTREE indexes in Heap table

how do your set the index type in 4.1? My tables still appear to hash indexes. -Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: About JDBC

It should be enough to place the .jar file in the jre/lib/ext folder (Binside your Java installation folder. If you don't want to do that, you (Bcould modify your CLASSPATH environment variable to include wherever (Byou decide to place the .jar. (B (BTodd (B (BOn Saturday, April 5, 2003,

Re: cannot connect to mysql server

Try the following cd /usr/local/mysql ./bin/mysqld_safe and see if that starts up the server. If it doesn't, check to make sure you don't have a proxy set in your internet configurations. Todd On Saturday, April 5, 2003, at 12:00 PM, Peter Gumbrell wrote: I have installed mysql on Mac OS X

Re: JDBC can't connect, but command line can...

if you forget what all is involved in the switch. Color me stupid, Todd On Wednesday, April 2, 2003, at 10:56 AM, Mark Matthews wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Todd O'Bryan wrote: | I've managed to get mysql up and running again (I don't know how) but | JDBC won't connect

Re: JDBC can't connect, but command line can...

is '^]'. 0 4.0.12-standardTwz!2tvp, Bad handshakeConnection closed by foreign host. --- 4.0.12 looks like it's MySQL, but I have no idea what this means. This at least looks like it should tell somebody something. Any idea where to go next? Thanks! Todd On Wednesday, April 2

Mac OS X package problems

successfully answered yet, but it's hard to be successful at that if I don't have a working mysql installation. Each student has entered 6 or 7 questions as an XML document, and I just have to get them into the database and set up a quiz program. Thanks, Todd -- MySQL General Mailing List For list

Still Mac OS X problems (4.0.12)

to local MySQL server through socket '/tmp/mysql.sock' (2) Help! If anybody has any idea how to fix this, I'd appreciate it. TIA, Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Can't uninstall, reinstall, or otherwise get 4.0.12 to work on Mac OS X

really need a working version on my iBook. Any help, pointers, or insight greatly appreciated! TIA, Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

OS X errors (using 4.0.12 package installer)

:51:18 InnoDB: Shutdown completed 030330 16:51:18 /usr/local/mysql/bin/mysqld: Shutdown Complete 030330 16:51:18 mysqld ended Any idea what to do now? And shouldn't the installer be taking care of all of this semi-automatically? Todd -- MySQL General Mailing List For list archives: http

Restoring a DB

If I have a file, mydb.mbk that was created with mysqldump, how do I recreate/restore the DB? Do I run a command line using mysql with a switch and mydb.mbk? Todd -- Ariste Software, Petaluma, CA 94952 \n [EMAIL PROTECTED]

Importing into an AutoIncrement field

. Will MySQL ignore my value and overwrite it with the auto value? The next is question is the command line syntax for importing a file liek the above? I have never done it and I am using the Linux version of MySQL. Todd -- Ariste Software, Petaluma, CA 94952 \n [EMAIL PROTECTED] /div

Select newest records

I am having troubles with queries, selecting only the newest records. Select ID,title,article From news ORDER BY ID LIMIT 0,2 I tried this but it always shows the first two records and I want to select the last two records(newest ones added). Can someone help out? Thanks

sql join help?

) into the empty fields of MSI_List in accordance with the zip code in MSI_List? Thanks in advance! Todd Clemmer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Using PHP to do a MySql Dump

Is there a function that can be implemented with PHP to do the equivalent of a mysqldump? Todd -- Ariste Software, Petaluma, CA 94952 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Front end for MySQL databases

.). The application is written in PHP and I am curious what others use for front-ends to MySQL DB's. Also, the site will only allow SSH connections and the client is using a Windows platform. Many thanks Todd - Before

Calendar database

and ending date. Suggestions welcomed. Todd -- Ariste Software, Petaluma, CA 94952 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

win32 batch scripts

i would like to know how to write batch script for dumping schema and data into a sql file. This script should dump the whole database and data - Before posting, please check: http://www.mysql.com/manual.php (the manual)

RE: Remote admin app?

Neal, I use Webmin. It has a MySQL module that allows you to create and drop tables as well as view, edit, add, and delete the records in the tables. I run it on a Linux box and it has other admin features for the rest of the system as well. Todd -Original Message- From: neal [mailto

[todd@fries.net: Re: Error: CHILD: exit on signal (11)]

, btw, to catch this. -- Todd Fries .. [EMAIL PROTECTED] (last updated $ToddFries: signature.p,v 1.2 2002/03/19 15:10:18 todd Exp $) - Forwarded message from Todd T. Fries [EMAIL PROTECTED] - Date: Wed, 21 Aug 2002 14:36:08 -0500 From: Todd T. Fries [EMAIL PROTECTED] To: [EMAIL PROTECTED

Calculating time fields

Hi Folks, I have a MYSQL table with timeIn and a timeOut columns and I'm trying to figure out if I can calculate the difference within a SELECT statement. Both fields are type TIME (e.g., 00:00:00). Thanks, Todd Schacherl [EMAIL PROTECTED] One of the penalties for refusing to participate

running totals

WHERE woid='$woid' GROUP BY laborid END Thanks in advance, Todd Schacherl [EMAIL PROTECTED] One of the penalties for refusing to participate in politics is that you end up being governed by your inferiors. -Plato

Re: ODBC and TimeStamp

Patrick - I have the following Sql SELECT statement: SELECT FirstName, LastName, ChangeTime FROM Members; If I execute the statement using ADO (uses a ODBC connection), the result set is empty. When the ChangeTime is removed, I get a result set. Todd -- Todd Cary Ariste Software 2200 D

Re: ODBC and TimeStamp

Jay - Here is the table structure. If I include the MEM_Code field, the ODBC SELECT throws and exception, but I can understand that since CHAR is usually a one character field. The MEM_Change_Date field is another story. When it is included, the result is empty. Strange?!? Todd # # Table

Re: ODBC and TimeStamp

Can you run the query from mysql interface? Yes. Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com

ODBC and TimeStamp

I have a MySQL TimeStamp in my table. If I try to do a query via ODBC, I get an error on the field. Any suggestions? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED

Significance of /*!32312 IF NOT EXISTS*/;

In my mysql dump of a DB using the -B switch, I get CREATE DATABASE /*!32312 IF NOT EXISTS*/ sfyc; What is the significance of /*!32312 IF NOT EXISTS*/ - the /*!32312? Isn't the statement commented out? With the CREATE TABLE, what happens if the table already exists? Todd -- Todd Cary

Moving a DB from one Server to another

Is there a quick and simple way to move a MySQL DB from one server to another MySQL server? Can I just copy the tables? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED

Installing mysqladmin

My platform is RH Linux and I did a rpm with rpm -i /tmp/MySQL-3.23.49a-1.i386.rpm I got back the acknowledgement and the suggestion that I change the root user password with /usr/bin/mysqladmin However, mysqladmin is not on the system!! What did I miss?? Todd -- Todd Cary Ariste Software

Re: Installing mysqladmin

the default. I want a database in /home/sfyc. Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php

Cannot set privileges

When I log into mysql with [root mysql]# mysql -u root -p and enter the password, I have access to mysql. Then I type in grant all on * to todd identified by 'mypassword' with grant option; Now when I do a select * from users; All of the privileges for todd have N's. Have I missed

Re: Cannot set privileges

Thanks to Paul, I solved the problem by replacing the * with *.*. In my PHP and MySQL book, the * is used in the examples. Any explanation why this does not work? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED

Re: Remote admin of MySQL from Win 2K

That was the answer and solution to my MySQL problem!! Many thanks Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please check: http

Re: Remote admin of MySQL from Win 2K

YES! I was missing something: Telnet!! I can log in *BUT* I am unable to change the MySQL password. mysqladmin -h www.myhost.org -u root -p password 'new_password' asks me for the password and when I use the root password (su password), I get Access Denied. Todd -- Todd Cary Ariste Software

Re: Socket problem connecting

: There is not a my.cnf file on my system. How do I determine where mysql is looking for my.cnf so that I can create one in that location? Many thanks. Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED

Re: Socket trouble

Amy - See my message and the fix for mysql. Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php

Remote admin of MySQL from Win 2K

Is there an appl for administering MySQL on a remote Linux server from a Win 2K client? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please

Re: Remote admin of MySQL from Win 2K

Just installed MySQL Manger...great! But I cannot get into a Cobalt RaQ-4 - problem due to my inability to be root since I can only admin the server by a Web page. H Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED

Re: Remote admin of MySQL from Win 2K

Told my client that dealing with Yahoo would have it's problems...they will not do anything to the server once they wipe the disk clean and install RaQ-4 :-) !! Thanks for the MySQL advice.. Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL

Re: Remote admin of MySQL from Win 2K

business). Todd * This is the first time I have ever used MySQL and I am trying to see if I can around not being able to access Interbase (my usual DBMS). -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED

Socket problem connecting

I am getting this message when I try to establish a connect to the DB. Any suggestions on where I can find an answer? Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /var/www/html/mysql/php/connect.php on line 2 Todd -- Todd Cary Ariste Software 2200 D

Re: Adding new users

Whps! I am using PHP on a Linux platform. Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] Georg Richter wrote: On Monday, 13. May 2002 07:06, Todd Cary wrote: Hi, However this does not work in a script

Re: Adding new users

. Could that be true? I check my router and see if it has port 110 open - with Interbase, it is port 3050. Warning: Can't connect to MySQL server on '209.204.172.137' (110) in /var/www/html/mysql/php/connect.php on line 2 Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952

Re: Adding new users

Where is the user table? Can it be viewed? How can I tell what is in it with mysqladmin? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please

Adding new users

1) Can I add new users with mysqladmin? 2) With mysqladmin as root I can get a response to # /usr/bin/mysqladmin -pmypassword ping However this does not work in a script: mysql_connect(209.204.172.122, root, mypassword); What am I missing? Todd -- Todd Cary Ariste Software 2200 D Street

Best book on MySQL

I need to convert a PHP app from using Interbase to using MySQL. What is the best book? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please

DDL and MySQL

? With Interbase it is gdb. Many thanks... Todd -- Dr. Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php

What does this message mean

I am receiving this message from MySQL: +++ Sorry. Your message could not be delivered to: w3d3demo (Mailbox or Conference is full.) +++ What am I missing? Todd -- Dr. Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED

[Newbie] Connecting for the first time

, ); if ($link) { print(Connectedbr); } else { print(Cannot connectbr); } ? html head titleConnection form/title /head body Trying to connect to a MySQL DB /body /html -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED

Re: [Newbie] Connecting for the first time

that my questions are really going to be basic!! Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php

Connection timing problem?

. -- Todd Thompson Wayside Press Ltd. (Peerless Plant) 1172 Battle Street Kamloops, BC V2C 2N5 Ph: 250.372.3373 Fax: 250.828.6848 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

RE: mysql

SPAM ALERT -Original Message- From: va ku [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 11:04 AM To: [EMAIL PROTECTED] Subject: mysql mysql See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_02

RE: Do any of your applications work?

I agree with everyone that has responded. A vague answer that does nothing but moan about something that is more or less incompentence from your developmental team. Not only that, but you have a support contract, so why you asking a question here? Shouldn't you be calling your support for this

RE: MySQL Book

I agree with Chris... Writing a book on features that do not exist yet is asking for trouble. -Original Message- From: Christopher Thompson [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 12:00 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: MySQL Book On Friday 05

RE: Help. I have truly blundered.

Wow John... Sounds like you are in deep chit... Just kidding... Linux 6 doesn't say which distro it is, same with mysql 3, there are a bunch of mysql version3s out there. Your problem... Log into as root then restart it. -Original Message- From: john [mailto:[EMAIL PROTECTED]]

RE: mysql forum

How about newsgroups for php? They have a couple on php/mysql I believe and they respond quite quickly... Look at php.net -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 12:12 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE:

RE: Password function still doesn't working

Im going to take a shot in the dark since I have not messed with ASP in years Have you just tried to verify the data is there with a simpler script? Just do the connection script then the user_check then see if it is still there. If it was PHP I would be able to find it. -Original

RE: Beginners Question

Yes, mySQL is up to the task. Just make sure you design the DB with fast retrivals in mind -Original Message- From: Zhao, Charles [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 3:53 PM To: '[EMAIL PROTECTED]' Subject: Beginners Question Hello there, I am trying to find

RE: Why does my delete not work :(

Here: ? $sql = DELETE [columumname] FROM [tablename] WHERE id = '$id'; That's your basic delete statement in PHP. -Original Message- From: sunny [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 6:18 PM To: Rodney Broom; [EMAIL PROTECTED] Subject: Re: Why does my delete not

RE: Why does my delete not work :(

Sunny... Pay close attention.. You are trying to execute a query that is a bit complex for someone new to mySQL and PHP. $sql = SELECT messages.topicid FROM messages LEFT OUTER JOIN main ON messages.topicid=main.topicid WHERE main.topicid = 'NULL' $result =

RE: Why does my delete not work :(

($result)) { $sql2 = DELETE FROM messages WHERE topicid = $row =[0] ; } -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 6:47 PM To: 'sunny'; 'Rodney Broom'; [EMAIL PROTECTED] Subject: RE: Why does my delete not work :( Sunny

RE: pb while querying in strange db name

You need to use the use command Mysql \u [databasename] Now you may run the query Mysql select * FROM dbname.table; -Original Message- From: David yahoo [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 4:25 PM Cc: [EMAIL PROTECTED] Subject: pb while querying in strange db

RE: MYSQL on a Cobalt RaQ4

Yes, my hosting providers use raq servers and I have mysql databases on all of my domains -Original Message- From: Denis Croombs [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 8:30 AM To: Mysql (E-mail) Subject: MYSQL on a Cobalt RaQ4 Hi Will MySQL run on a Cobalt RaQ4

RE: phpMyAdmin issue + looking for php/mysql websites

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

RE: phpMyAdmin issue + looking for php/mysql websites

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

RE: phpMyAdmin issue

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

RE: mysql/php on Win2000

IIS: Kill the services, and disable them If you need to know which ones let me know. Oracle8i: No, they use different ports. I run Oracle8, mySQL, SQL Server7 without any problems -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002

RE: mysql/php on Win2000

I have found Win2k completely stable with Apache/PHP/mySQL. Not one issue! If you are talking IIS combo, then yes issues will arise. I don't see any performance hit on this setup as a CGI. I think you are being a bit bias towards Windoze. Windows 2k is quite stable. The thing about win2k is

RE: mysql/php on Win2000

Properties and select Disable in the drop down box -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 12:34 PM To: 'Todd Williamsen' Cc: [EMAIL PROTECTED] Subject: RE: mysql/php on Win2000 Hi, if you think that IIS and Apache are going to have problems

RE: mysql/php on linux

browser, I got Format error. Did I not do it right? Should I put it in my cgi-bin? Could some one send me a working php script and instruct me how to test it? Thanks From: Todd Williamsen [EMAIL PROTECTED] To: 'Andrew Hazen' [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE

RE: MySQL, MyODBC and MS Access

Your client won't drop Access in favor of a faster, more secure database like mySQL? Why is your client stuck on Access? The data can be dumped and make the GUI web based to look just like the Access one... Stick in on a Intranet server, and lock it down... I would rather have that than a slow,

RE: NT service problem

I ran the .exe file and WHAMMO! It installed itself as a service. I just needed to edit the service to have it automatically start at boot -Original Message- From: Gerald R. Jensen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 6:40 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]

RE: mysql/php on linux

PHP http://www.php.net/manual/en/install.linux.php mySQL http://www.mysql.com/doc/L/i/Linux.html I never had any problems with mysql and PHP talking to each other on Linux, and I am very wet behind the ears with Linux. Maybe you can give us an error messages you are receiving, and that will

RE: IS THIS BETTER?

Try turning the CAPs off first... Makes it easier to read... Second... You are using ADOB to connect to mySQL? Is that what you are doing? Using ASP? Try using PHP, easier to learn and is much more compatible with mySQL. ASP/mySQL can be used, but it’s a pain, plus ASP has its limitation

RE: problem in telent to mysql server

Can you telnet into anything else? How about a webserver? Try port 80 or 25 if you have a mail server. If you can't, you need to make sure you have telnet rights -Original Message- From: Jianping Zhu [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 1:58 PM To: [EMAIL

RE: problem in telent to mysql server

I didn't realize you were trying to telnet to a client. You cannot do that. You need to telnet to the SERVER. Whatever the server is You need to make sure the user you are trying to use has access rights for the user for telnet -Original Message- From: Paul DuBois [mailto:[EMAIL

RE: mySQL connection problem!!!

I think I read somewhere about this issue. I think it had to do with multiple mySQL servers running concurrently. See if there is multiple servers running using the ps command. If so, then kill one of them. Also, when adding a user, do you select a database first before adding a user?

RE: creating a password field..

Peter, I have no idea what your front end is, and this is what will do the actual encryption, all mysql does is holds the data. So whatever your front end programming language is, it will have to do the encryption. Below is the link for php encryption

RE: Dropdown lists

Josiah.. I think you are asking the wrong mailing list for this... I am assuming you are using PHP correct? Your explanation isn't all that clear, but I can guess what you are trying to do. You want to have a drop down list, but don't know what data type.. You can use VarChar or text for

RE: Some PHP - mySQL help please ... new to both

Daniel, Usually in PHP there are some sort of syntax error before the line that says failed. -Original Message- From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 11:05 AM To: [EMAIL PROTECTED] Subject: Some PHP - mySQL help please ... new to both I am

RE: login and logout

Matthew... Did you look into the session variables Session_start() Session_register() Mysql, query -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 4:49 PM To: [EMAIL PROTECTED]; mysql list; Siulun A Sze Subject: RE: login and logout

RE: [ANN] Blue World Announces Lasso vs PHP White Paper

Can you provide a NON-BIAS so-called TRUE comparison? I would be curious on what Blueworld has to say. Also, why do you think the TCO is lower with lasso than PHP? I don't get it, there is no cost to own it, just to develop it. And if you develop with PHP correctly, then the TCO is low.

RE: [ANN] Blue World Announces Lasso vs PHP White Paper

You think Blue World getting the point yet? Maybe they are thinking twice about spamming mailing lists with their products? Maybe a better target is Microsoft's .NET boards since both products are about the same price -Original Message- From: Jonathan Hilgeman [mailto:[EMAIL

<    1   2   3   >