Re: RH 7.2 - mysql Problem !

2002-03-29 Thread Curtis Maurand
More like he installed the rpm's from MySQL.com over the top of the one's from redhat. The scripts from the MySQL rpm's don't recognize the redhat rpms and the sripts from the redhat rpm's don't recognize the MySQL.com rpm's. The rpms from redhat are out of date (they were out of date when 7.2

Re: newbie installing MySQL/InnoDB on RH 7.1

2002-03-28 Thread Curtis Maurand
rpm -e the mysql product from the CD's to uninstall the originals. then rpm -ivh MySQL-Max-3.23.49a-1.i386.rpm to install the mysql-max product and you're golden. Curtis Voytek Eymont said: I need some newbie help... I've installed RedHat7.1 off RH7.1 CDs, also, installed MySQL that came

Re: mysql and snort

2002-03-25 Thread Curtis Maurand
what is snort? Curtis Idan Dolev said: Hi, I am pretty new guy dealing with mysql database, and I am sorry if this has being asked before. Are their any doc explaining how to integrate snort and mysql ? Best regards, Idan Dolev

Re: mysql/php on Win2000

2002-03-25 Thread Curtis Maurand
The only problem with Win2K is that a lot of the components for PHP aren't there. Also PHP will run as an ISAPI module, but its not recommended. The preferred method is as a CGI (read 25% performance hit). Win2K doesn't multi-task/multi-thread as well as either of the *nix's mentioned and its

Re: MySQL on netware

2002-03-19 Thread Curtis Maurand
I'll bet there are several people in Provo, Utah that could be convinced to do the port. Curtis Sinisa Milivojevic said: Adolfo Amo writes: Hi! We are ineterested in the possibility of using MySQL on Netware plataform. After visit MySQL website, we've found that you are interested in

Re: Web hosting scalability?

2002-03-08 Thread Curtis Maurand
Sounds like a transaction server to me. Curtis John Masterson said: Situation: mass virtual website hosting, with php/perl/python. One master mysql server, one or more replicated slaves. Question: would it be possible/feasible to write a daemon that accepts connections on behalf of

Re: Perl version of phpinfo()

2002-03-08 Thread Curtis Maurand
for $key (sort keys %ENV) { print $key = $ENV{$key}\n; } Page 155 of learning perl 1st (purple) edition. Curtis Margie New said: Is there a Perl function similar to php's phpinfo() that echos or returns a complete synopsis of the Perl configuration core? We are trying to determine

Re: mysql_fetch_array

2002-01-22 Thread Curtis Maurand
while ($line = mysql_fetch_array($result1) { execute your code } Curtis Original Message From: [EMAIL PROTECTED] Date: Tue 1/22/02 11:40 To: Undisclosed Recipients Cc: [EMAIL PROTECTED] Subject:mysql_fetch_array i'm

Re: GUI for Windows

2001-12-25 Thread Curtis Maurand
Microsoft Access or Visual Basic. Use the ODBC connectors. Curtis On Mon, 24 Dec 2001, John Mayson wrote: Eventually my databases will be on my Linux system. In the meantime, is there a Windows program that builds a quick and dirty GUI interface for my SQL databases? Thanks, John

Re: How can i autostart MYSQL

2001-12-23 Thread Curtis Maurand
edit your rc.local file and add the command to start your mysql server. Curtis On Sat, 22 Dec 2001, sreedhar wrote: hi all, How can i autostart MYSQL while starting of my LINUX server. regards, sreedhar - Before

Re: Access to MYSQL via ODBC?

2001-11-13 Thread Curtis Maurand
The last time I checked, the windows version of PHP had MySQL support built in. Curtis On Tue, 13 Nov 2001, mweb wrote: Hello, apart from performance issues, is it possible in PHP to read/write a MYSQL DB not directly, but via ODBC? The reason (as states in my other message MS ACCESS

RE: [PHP] Access to MYSQL via ODBC?

2001-11-13 Thread Curtis Maurand
There are scripts available at MySQL.com to perform the task. Curtis On Tue, 13 Nov 2001, mweb wrote: GREAT, THANK YOU! Now the only step left is how to convert (on Linux) the MS access database to MySQL...How? mweb -- Initial message --- From

Re: User Permissions Issue (Easy questions?)

2001-10-01 Thread Curtis Maurand
TO username@%.ourdomain.com identified by password with grant option; should do the trick for you. Curtis Maurand President Maine Line Systems On Mon, 1 Oct 2001, Erica Douglass wrote: Hi, I am working with an internal database. We add a user using the following statements: create database

Re: MS-Access

2001-10-01 Thread Curtis Maurand
Look in the contrib section of the website. There are scripts for exporting Access databases to mysql. Curtis On Mon, 1 Oct 2001 [EMAIL PROTECTED] wrote: On Mon, 1 Oct 2001, Andreas Schmidt wrote: Hi List I want to migrate from a NT-Server to a Linux Server. Therefore I'm looking

Re: MySQL and Perl

2001-09-11 Thread Curtis Maurand
Quite nicely. Take a look at the Perl DBI functions. Curtis On Tue, 11 Sep 2001, Nilesh Parmar wrote: Hi I just wanted to know how well MySQL gels with Perl, when compared to MySQL and PHP. any ideas ?? regards Nilesh

Re: LAST_INSERT_ID()

2001-08-22 Thread Curtis Maurand
A caveat is that you get the last_insert_id for your connection. Not the last one in the database. Curtis On Wed, 22 Aug 2001, Dr. Werner Stürenburg wrote: Jari Mäkelä schrieb am Mittwoch, 22. August 2001, 14:57:06: At 13:19 22.8.2001 +0200, you wrote: LAST_INSERT_ID() should return

Re: RH Linux 7.1 Binary Install Configure and Auto start/stop

2001-08-22 Thread Curtis Maurand
#1 no. #2 yes. run /usr/sbin/setup and go to system services. Then check off the mysql entry and save it. or you can put /etc/rc.d/init.d/mysqld start in your rc.local file, HTH Curtis On Wed, 22 Aug 2001 [EMAIL PROTECTED] wrote: Good Morning. I recently installed

Re: Virtual Server?

2001-08-22 Thread Curtis Maurand
I always grant all on a particular database to the user who's purchased the service. I reserve the right to add and delete users, but you could set up a web page for users to add and remove users for their own database. making it idiot proof and not exploitable by the script kiddies would be

Re: Access Database into mysql

2001-06-12 Thread Curtis Maurand
You should be able to export data directly from Access to a delimited text file. Curtis On Thu, 7 Jun 2001, Ute Hoffmann wrote: Hi, I have a database table, which was made with Microsoft Access and am to move the data into a mysql database table. As there are some long entries, which

Re: Open Source MySQL Appl. Dev Tools for W2K/NT?W98.

2001-05-04 Thread Curtis Maurand
try http://www.nusphere.com Curtis On Fri, 4 May 2001, Fowler, J.T. wrote: I will be having to develop a MySQL application on Windows 2000, NT, and/or Windows 98 system - no choice on the OS. What I would like to do is develop using Open Source tools instead of MS products like VB, etc.

Re: [OT] SQL syntax qestion

2001-03-26 Thread Curtis Maurand
Thanks, I tried the latter, but it didn't work. I'll try you're suggestion. curtis - Original Message - From: "Quentin Bennett" [EMAIL PROTECTED] To: "'Curtis Maurand'" [EMAIL PROTECTED]; "MySQL List" [EMAIL PROTECTED] Sent: Monday, March 19, 2001 11:44 P

[OT] SQL syntax qestion

2001-03-19 Thread Curtis Maurand
Hi, Just a quick quesiton, I have a table that contains difined as create table picks( handle char(30) primary key, ... total int unsigned); there is a user table that has a list of handles and other user info. handle is the primary key. If I issue the command "select handle,

Re: Can mysql read from Informix

2001-03-12 Thread Curtis Maurand
Perl DBI with the Mysql and the Informix drivers installed. Curtis - Original Message - From: "MArk Williams" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 12, 2001 7:21 AM Subject: Can mysql read from Informix I have a mysql server running. I would like to be able to

Off Topic Perl Mysql modules install problem

2001-03-06 Thread Curtis Maurand
Hello, I'm now lost. I cannot figure out what the make file is looking for. Anyone have any ideas? LD_RUN_PATH="/usr/lib/mysql:/lib:/usr/lib:/usr/lib/gcc-lib/i386-redhat-linux/2.9 6" cc -o ../blib/arch/auto/DBD/mysql/mysql.so -shared -L/usr/local/lib dbdimp.o mysql.o -L/usr/lib/mysql

Re: yes/no

2001-03-02 Thread Curtis Maurand
set your column something like: enum('0','1'); Curtis On Fri, 2 Mar 2001, Scott Dunn wrote: I want to have like in Access a column that is yes or no or true or false, something on that line. I looked at www.mysql.com but could not find anything. I don't know what exactly I am looking for.

RE: RAW Device support

2001-01-27 Thread Curtis Maurand
That would be more like DB2 or Oracle which would be more than happy to setup their own table space on a raw drive. They build their own file system and tables on the drive. Its very efficient and why a lot of large databases reside on DB2 or Oracle. Curtis On Sat, 27 Jan 2001, Sander Pilon

Re: encrypted fields

2001-01-21 Thread Curtis Maurand
See the section of the documentation on the password function. Insert into users (username, password) values ('joesmith',password('somepassword')); It will encrypt your passords. then you select using the same function. select username, password from users where username = 'joesmith' and

<    1   2