Re: SELECT frmo two tables

In addition to Paul's suggestion of using mysql_error to check to see if it was successful, when I'm having trouble I like to print the query in the output for testing and then try to run the query from the MySQL CLI. print "SELECT SUM(s.groundballs) AS grounders FROM stats s LEFT JOIN rahs r ON

404 on search function on mysql.com

Hi, For some reason I get a 404 error when I click on 'search' in the Quick links section at http://www.mysql.com/documentation/mysql/bychapter/. It looks like it does some type of redirect so my browser could be broken too, but usually not so much with a 404. :) Steve -

Replication code from 3.23.25-beta to today.

Hello, I'm looking to port a MySQL replication set that runs 3.23.25-beta to a later version of MySQL. I understand that the format for the binary log changed from .25 to .26 and again at 4. It appears, from looking at the code for 4, that it looks at the version of the replication master and i

Re: Problem

Hi, Are you sure that the MySQL server is running? If so, maybe look for the mysql.sock file (find / -name "mysql.sock") ./mysql -u -p --socket=/location/of/socket.sock Steve On Mon, Feb 25, 2002 at 04:38:59PM +, Ricardo Javier Aranibar Le?n wrote: > > > I have a problem, when I try to

Re: mysql and java

Hello, You'd probably want JDBC. http://www.mysql.com/downloads/api-jdbc.html Steve On Tue, Feb 19, 2002 at 03:17:49PM +, Bill Fogarty wrote: > Hi, > > Does anyoone know how to connect to mysql from a Java application in windows 2k? > Any help would be greatly apppreciated. I may be writi

Version 4 Schedule

Hello- I've done some searching through archive and the website but can't seem to find a semi-concrete answer. What's the schedule, if any, for version 4.0 to go stable? Thanks for any help or pointers. Steve - Before posti

Re: copy tables to another db

There are a number of ways to do this. Not being sure exactly what you want, a live copy (replication) or a transfer (mysqldump), it's tough for me to say which method would be best. Look in the manual under mysqldump or replication and see if those fit your needs. Steve At 04:19 PM 9/25/01

Re: New database

At 03:58 PM 9/14/01 +0200, jean.schuller wrote: > I'm under root and say :mysql -u root -p password and > mysql says ERROR 1045: Access denied for user: 'root@localhost' >(Using password: YES) > What can this password be ?? where can I get it ?? Did you set a password with

Re: MySQL/PHP

hmm. Are you sure that MySQL is running? Conversely, does the file /var/lib/mysql/mysql.sock exist? Steve At 11:52 AM 9/5/01 -0700, Chakravarthy K Sannedhi wrote: >Hello all, > >I am trying to integrate the mysql with php. As I am using the Red Hat >7.0, I know that they come pre-installed a

Version 4.0

Hello- I poked around on the site but didn't find any definite answer. Roughly when is version 4.0 of MySQL expected out? I saw the information on the todo in regards to version 4.0 and the subsequent 4.1 but didn't see any dates. Thanks for any help. Steve

Re: PHP Warning

are you sure mysql is running? At 10:06 AM 8/21/01 -0700, my sql wrote: >On a new install of Suse 7.2 I get this message when >attempting to acces MySQL through a php scrpipt in >apache 1.30.20 (MySQL 3.23.39 and PHP 4.0.6): > >Warning: Can't connect to local MySQL server through >socket '/var/li

Re: Linux Bootup problem after modifying /etc/rc.d/rc.local

Hello- You need to place mysqld in the background by adding a & after the command. Something like this: /usr/local/mysql/bin/safe_mysqld & As to the problem after it starts mysqld in the foreground, have you tried CTRL-C? Otherwise try going to a different console with ALT-F2, ALT-F3, etc.