3.23.54 log files

[John]

Hi

I'm using mysql 3.23.54 over Red Hat Linux 9. I'm having problems with
the error logs.

I've run mysqld start --l, mysqld start --log, mysqld start
--log-error, and mysqld start --log=MyErrors.lo g and not once managed
to find a log file.

I'm running mysql and then issuing:- SELECT * FROM myFile WHERE 1;
which gives ERROR 1046: No Database Selected. That should surely be
logged in a file somewhere.

I'm using:- find / -amin -5 to select anything altered in the last
five minutes, after many fruitless hours trying to find the correctly
named files (from <http://dev.mysql.com/doc/mysql/en/query-log.html>).
I can't see anything containing that error.

Ultimately, I'm trying to work out whether a J2EE app has connected
with mySQL. I want to see whether the CORBA error I'm getting is
because mySQL rejected the request, or whether it's from CORBA itself.
If mySQL rejected it, there'd be an error message. I just can't see
any error message store at all. Can anyone see the error of my ways?

J

PS. Somehow when I previously posted this, it was appended to someone
elses thread. I didn't do that knowingly, apologies

[Mike A]

Among other things, you said:

I'm running mysql and then issuing:- SELECT * FROM myFile WHERE 1;
which gives ERROR 1046: No Database Selected. That should surely be
logged in a file somewhere.

When you use the mysql client, you need to specify the database you are
using. After logging in, at the mysql> prompt, type:

mysql>show databases;

you will see a list of databases: 'mysql', 'test', and your databases.
'mysql' is the system database which contains users, hosts, privileges,
etc. 'test' is a test database, which is a workspace you can safely
experiment in. The others are your created databases. (You DID create a
database, didn't you?) You select your database using:

mysql>use your_database_n ame

It will respond with 'database changed.' Now you can perform queries
against your database.

If you haven't created a database, you will need to do so. Then you have
to create one or more tables in the database in which to store your
records. Your post kind of indicates that you have not done this, as a
SELECT is done FROM a TABLE, not a file. It is fairly easy to create a
database and a table, then load your file into the table. See the
documentation on MySQL's website, or locally on your computer. If you
need a hand with it, post again with a question (and some details like
field names and data types, and how your file is delimited - tabs, commas,
etc.) and we'll help you get it going.

--
Mike Argy
Custom Office solutions
and Windows/UNIX programs

[Mike A]

If you're just setting up your MySQL database, get the latest version from
their site (4.1.11). It is available as an RPM that you can install
easily on RedHat 9, and it is more functional than the version that came
with the distro. You'll likely be much happier with it. Download/install
the server and client packages at the very least; the 3.23 client won't
work as well with the 4.1 server. Also, if you want to run the max
version of the server, you need that IN ADDITION TO the server package.

It will be much easier for you to start with the newer version than to
migrate to it later.
--
Mike Argy
Custom Office solutions
and Windows/UNIX programs

[Mike A]

By the way,

If you're just setting up your MySQL database, get the latest version from
their site (4.1.11). It is available as an RPM that you can install
easily on RedHat 9, and it is more functional than the version that came
with the distro. You'll likely be much happier with it. Download/install
the server and client packages at the very least; the 3.23 client won't
work as well with the 4.1 server. Also, if you want to run the max
version of the server, you need that IN ADDITION TO the server package.

It will be much easier for you to start with the newer version than to
migrate to it later.

--
Mike Argy
Custom Office solutions
and Windows/UNIX programs
Excel 2000 on Fedora Core 3

[John]

"Mike A" <re***@newsgrou p.please> wrote

Among other things, you said:

I'm running mysql and then issuing:- SELECT * FROM myFile WHERE 1;
which gives ERROR 1046: No Database Selected. That should surely be
logged in a file somewhere.

When you use the mysql client, you need to specify the database you are
using. After logging in, at the mysql> prompt, type:
mysql>show databases;
<snip>
Your post kind of indicates that you have not done this, as a
SELECT is done FROM a TABLE, not a file.

Thanks, I don't think I knew the "show databases" command. I was
trying to create an error deliberately though, in order to work out
where the error files were, so I did know about the other stuff (worth
checking tho).

I'm moving to SUSE Linux soon on a new machine so I think I'm going to
wait and see how MySQL works on that, whether I need to upgrade it (as
the other respondent said) and so on.

Thanks for your help
J