List:General Discussion« Previous MessageNext Message »
From:Johnny Withers Date:September 10 2010 5:16pm
Subject:Re: hard disk crash: how to discover the db?
View as plain text  
If you still have the mysqld binary and you _think_ it is version
5.3.something, you could try this:

strings /usr/libexec/mysqld | grep "5.3.*"

The version # should be somewhere near the top of the output. (Is on my copy
anyway, of 5.0.x)


  ------------------------------

*Johnny Withers*
jwithers@stripped
601.919.2275 x112
 [image: eCash Software Systems]


On Fri, Sep 10, 2010 at 12:00 PM, george larson
<george.g.larson@stripped>wrote:

>
>
> Shawn Green (MySQL) wrote:
> > On 9/10/2010 10:01 AM, george larson wrote:
> >>
> >> Uwe Brauer wrote:
> >> ...
> >> The only one I know of, for my environment, is /etc/my.cnf.  I believe
> >> that it can be located elsewhere but you could just use 'find' to find
> >> it.  I've broken my dev. MySQL many, many times and that's the only file
> >> I know about outside of my data directory.  :)
> >>
> >> I don't have any good ideas about discerning precisely what version of
> >> MySQL was running, though.
> >>
> >
> > The error log will have the version information. Each successful
> > startup includes something similar to
> >
> > 100910  7:50:30 [Note] mysqld: ready for connections.
> > Version: '5.1.48-enterprise-gpl-advanced'  socket: ''  port: 3306
> > MySQL Enterprise Server - Advanced Edition (GPL)
> >
> > For more information on how to locate the error log:
> > http://dev.mysql.com/doc/refman/5.1/en/error-log.html
> >
> That's a neat trick and I don't mean to steal the thread but that didn't
> work for me:
>
> ---
> :/var/lib/mysql # head mysqld.log
> 100910 12:50:09 mysqld_safe Starting mysqld daemon with databases from
> /var/lib/mysql
> 100910 12:50:09 [Warning] option 'table_cache': unsigned value 536870912
> adjusted to 524288
> 100910 12:50:09 [Warning] The syntax '--log_slow_queries' is deprecated
> and will be removed in MySQL 7.0. Please use
> '--slow_query_log'/'--slow_query_log_file' instead.
> 100910 12:50:09 [Warning] Changed limits: max_open_files: 65535
> max_connections: 50  table_cache: 32737
> 100910 12:50:09 [Note] Plugin 'ndbcluster' is disabled.
> 100910 12:50:09 [Note] Plugin 'FEDERATED' is disabled.
> ---
>
> I'm going to comb through my 'my.cnf' to see if it might have somehow
> been disabled.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


-- 
-----------------------------
Johnny Withers
601.209.4985
johnny@stripped

Thread
hard disk crash: how to discover the db?Uwe Brauer9 Sep
Re: hard disk crash: how to discover the db?andrew.2.moore9 Sep
  • Re: hard disk crash: how to discover the db?Uwe Brauer9 Sep
    • Re: hard disk crash: how to discover the db?George Larson10 Sep
      • Re: hard disk crash: how to discover the db?Mike McMullin10 Sep
        • Re: hard disk crash: how to discover the db?Uwe Brauer10 Sep
          • Re: hard disk crash: how to discover the db?Mike McMullin10 Sep
      • Re: hard disk crash: how to discover the db?Joerg Bruehe10 Sep
        • Re: hard disk crash: how to discover the db?Johan De Meersman10 Sep
        • Re: hard disk crash: how to discover the db?Uwe Brauer10 Sep
      • Re: hard disk crash: how to discover the db?Uwe Brauer10 Sep
      • Re: hard disk crash: how to discover the db?Steve Staples10 Sep
        • Re: hard disk crash: how to discover the db?george larson10 Sep
        • Re: hard disk crash: how to discover the db?Johnny Withers10 Sep
      • no success (was: hard disk crash: how to discover the db?)Uwe Brauer13 Sep
        • RE: no success (was: hard disk crash: how to discover the db?)Gavin Towey14 Sep
Re: hard disk crash: how to discover the db?george larson10 Sep
  • Re: hard disk crash: how to discover the db?Uwe Brauer10 Sep
  • Re: hard disk crash: how to discover the db?MySQL)10 Sep
    • Re: hard disk crash: how to discover the db?george larson10 Sep
      • Re: hard disk crash: how to discover the db?Johnny Withers10 Sep
Re:hard disk crash: how to discover the db?kapil verma11 Sep