RPM Install appears to have failed

--user=mysql cd_mysql_installation_directory - where the heck did it install at? don't think this happened... thanks in advance. Chris Becker MCDBA MCSE http://www.PrismSoftware.com [EMAIL PROTECTED] - Before posting

Perl MySQL installed with rpm's vs binaries combination

mysql_installation_directory shell ./bin/safe_mysqld --user=mysql cd_mysql_installation_directory - where the heck did it install at? don't think this happened... thanks in advance. Chris Becker MCDBA MCSE http://www.PrismSoftware.com [EMAIL PROTECTED

Archive of this mysql list

Is there an archive of all posts to this mysql list that I can search somewhere? Chris Becker MCDBA MCSE http://www.PrismSoftware.com [EMAIL PROTECTED] sql - Before posting, please check: http://www.mysql.com/manual.php

Re: RPM Install appears to have failed

At 06:23 PM 10/3/2002 -0700, you wrote: Hi, Where is the Mysql-server version. you have installed only client and mysql-max, but no mysql-server. Use rpm -Uvh for your installations, so that you can easily know the progress of installation. regards, Praveen --- Chris Becker [EMAIL PROTECTED

Re: RPM Install appears to have failed

there or it should be. John Coder On Thu, 2002-10-03 at 21:55, Chris Becker wrote: Thanks Praveen, So Max is not a server version, it sure is difficult to determine that on the download page: MySQL database server standard clients: · MySQL 3.23 -- Stable release (recommended

Re: ADO API support?

I have had very much success with passing sql commands via ado over the myodbc layer. I wouldn't trust addnew and update batch methods nor have I tested how or if they work, it's better to keep your connections to the database stateless for performance purposes. Meaning to execute dml

Access denied for user: 'root@localhost'

root login failing??? why? anonymus failing too?? I just installed the following on Win2k Server: Ver 8.23 Distrib 3.23.47, for Win95/Win98 on i32 Server version 3.23.47-max-nt Install goes seemingly ok. I test whether or not MySQL is working and have problem with this command

Re: VB/MySql/CrystalReport Problem?

IMHO - I would use ADO over the MyODBC layer to retrieve disconnected recordsets representing your report data from MySQL, then pass said adors to Crystal Report's viewer. To learn more about this approach, search seagate.com for ado disconn. rs, which utilizes ttx files (tab delimited text

Re: Query

select u.name, sum(p.id) from usertable u, posts p where u.userid = p.poster group by u.name order by 2 desc //chris www.mydba2000.com From: Laban [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Query Date: Fri, 15 Mar 2002 02:18:27 +0100 Hi I need a query that counts the number of posts

MySQL and MSAccess

Is anyone out there using MySQL on either Unix or NT, with MSAccess as the front-end? Are you using odbc bound controls on your access forms? Any issues? Suggestions? In-sights? We are planning on migrating a SQLServer back-end to MySQL on Linux as a robust and affordable back office

MySQL and MSAccess

Anyone using MySQL on Linux/Unix with a MSAccess front end? Using odbc bound controls? Any issues, insights, suggestions? How's the interaction with the Jet engine? Any performance issues? Thanks in advance. Chris _ Send and

Re: Encrypted table

encrypted table, no. encrypted data - yes! check out this AES algorithm, it can be used with C, C++, and there is even a VB implementation. I highly recommend. Chris www.MyDBA2000.com From: Tripp Scott [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Encrypted table Date: Tue, 12 Mar 2002

RE: VBA/VB DAO/ADO MS Access to MySQL?

I've done it by installing the MyODBC driver on NT4.0 WS running VB6sp2, and connecting to a RHLinux6.2 box running MySQL vs .36 - I've only done it w/ ADO over the ODBC layer, and it seems to work fine, however I am using disconnected recordsets and have not attempted binding a control to the

Unusual dependency error w/ rpm??

Please Help... I do believe I have these dependencies, why am I getting these errors? Running RH6.2 / INtel /mysqlrpm -i MySQL-3.23.37-1.i386.rpm failed dependencies: /bin/sh is needed by MySQL-3.23.37-1 /bin/sh is needed by MySQL-3.23.37-1 /usr/bin/perl is needed by

RE: Unusual dependency error w/ rpm??

reinstall. How do I UnInstall my current Perl version? Thanks, Chris B -Original Message- From: Scott Baker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 02, 2001 4:18 PM To: Chris Becker; [EMAIL PROTECTED] Subject: Re: Unusual dependency error w/ rpm?? Odd... could be different versions

perl DBD make test errors??? Please Help (PROBLEM SOLVED, I think...)

the tar.gz file. I beleive I'll recompile Mysql - do I use and rpm to do this? In other words, how do I re-compile Mysql to have it use the same compiler as Perl? Thanks in advance. Chris B -Original Message- From: Chris Becker [mailto:[EMAIL PROTECTED]] Sent: Monday, April 30, 2001 2:07 PM

INSTALL rpm over tar.gz??

I currently have Mysql .36 loaded on RH6.2 intel, installed from tar. How do I remove the .36 version so I can install the rpm version .37?? This is not an upgrade, I need to replace or recompile mysql - Is there a Un-Install process to remove the 36 version? Thank You in advance, ChrisB

Unusual dependency error w/ rpm??

I do believe I have these dependencies, why am I getting these errors? Running RH6.2 / INtel /mysqlrpm -i MySQL-3.23.37-1.i386.rpm failed dependencies: /bin/sh is needed by MySQL-3.23.37-1 /bin/sh is needed by MySQL-3.23.37-1 /usr/bin/perl is needed by MySQL-3.23.37-1

perl DBD make test errors??? Please Help

-1.2210/mysql' make: *** [test] Error 2 Please Help - am I installing DBD in the wrong directory? MySQL is installed in /usr/local/mysql - should I be running this make file there??? Thank in advance, Chris Becker MCSE MCDBA === Idysys http://www.idysys.com [EMAIL PROTECTED

Perl DBD Errors???

] Error 2 [root@clx Msql-Mysql-modules-1.2210]# Thanks in advance, Chris Becker MCSE MCDBA === Idysys http://www.idysys.com [EMAIL PROTECTED] === - Before posting, please check: http

RE: Perl MySQL Interface

go to perl.com - click CPAN and look for DBI and DBD, and look for docs on how to install a perl module. You need to install DBI first, then DBD... hope this helps. Chris Becker MCSE MCDBA === Idysys http://www.idysys.com [EMAIL PROTECTED

RE: Perl - DBD:DBI Errors

-1.2210/mysql' make: *** [test] Error 2 [root@clx Msql-Mysql-modules-1.2210]# Thanks, ChrisB -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Clark Sent: Monday, April 09, 2001 6:12 AM To: Chris Becker Cc: [EMAIL PROTECTED] Subject: Re: Perl - DBD:DBI

RE: Perl - DBD:DBI Errors

yes. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Clark Sent: Friday, April 06, 2001 5:59 AM To: Chris Becker Cc: [EMAIL PROTECTED] Subject: Re: Perl - DBD:DBI Errors You are logged in as root, are you not? Chris Becker wrote: Gerald, I

RE: Perl - DBD:DBI Errors

... Again - Thanks for your patience and working this thing through with me! Chris B -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Clark Sent: Friday, April 06, 2001 10:28 AM To: Chris Becker Cc: [EMAIL PROTECTED] Subject: Re: Perl - DBD:DBI Errors

RE: Perl - DBD:DBI Errors

PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Clark Sent: Wednesday, April 04, 2001 10:23 AM To: Chris Becker Cc: [EMAIL PROTECTED] Subject: Re: Perl - DBD:DBI Errors Chris Becker wrote: I checked my RH6.2 install cd's and found zlib-1.1.3-6.src.rpm, I went to install the package

RE: Perl - DBD:DBI Errors

:[EMAIL PROTECTED]]On Behalf Of Gerald Clark Sent: Wednesday, March 28, 2001 9:26 AM To: Chris Becker Cc: [EMAIL PROTECTED] Subject: Re: Perl - DBD:DBI Errors You don't have zlib on your machine. Check your 6.2 CD. Chris Becker wrote: I'm having trouble installing the perl module DBD specifically. I

(sin asunto)

try INSERT INTO tblDomains (field1, field2) VALUES (1, 'trlinux.com.'); ChrisB MCSE MCDBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Cesar Martinez Sent: Wednesday, March 28, 2001 12:40 PM To: [EMAIL PROTECTED] Subject: (sin asunto) that such!!

RE: Perl - DBD:DBI Errors

Is the zlib on CPAN? like module Compress::Zlib ? Many Thanks Gerald! ChrisB MCSE MCDBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald Clark Sent: Wednesday, March 28, 2001 9:26 AM To: Chris Becker Cc: [EMAIL PROTECTED] Subject: Re: Perl

RE: STUPID QUESTION

Note that foreign keys in SQL are not used to join tables, but are used mostly for checking referential integrity (foreign key constraints). If you want to get results from multiple tables from a SELECT statement, you do this by joining tables: SELECT * from table1,table2 where table1.id =

Uninstall

I'm going to try an Un-Install, then Re-Install Mysql. How do I Un-Install?? Thanks, Chris B - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list