3.23.54 log files

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • John

    3.23.54 log files

    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

    #2
    Re: 3.23.54 log files

    Among other things, you said:[color=blue]
    >
    > 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.
    >[/color]


    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


    Comment

    • Mike A

      #3
      Oh, 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


      Comment

      • Mike A

        #4
        Re: 3.23.54 log files

        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

        Comment

        • John

          #5
          Re: 3.23.54 log files

          "Mike A" <reply@newsgrou p.please> wrote[color=blue]
          > Among other things, you said:[color=green]
          > > 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.[/color][/color]
          [color=blue]
          > 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;[/color]

          <snip>
          [color=blue]
          > Your post kind of indicates that you have not done this, as a
          > SELECT is done FROM a TABLE, not a file.[/color]

          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

          Comment

          Working...