List:General Discussion« Previous MessageNext Message »
From:george larson Date:September 10 2010 5:00pm
Subject:Re: hard disk crash: how to discover the db?
View as plain text  

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.
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