Re: the way to get more info in logs

2009-04-18 Thread Claudio Nanni
seems like there is a problem of consistency of innodb data and recovery does not go well. try to take a look at innodb status: >show engine innodb status http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting.html http://dev.mysql.com/doc/refman/5.0/en/innodb-monitors.html Cheers Claudi

Re: How to change where NULL values sort?

2009-04-18 Thread Martijn Engler
They'll normally sort at the top, unless you use ORDER BY DESC. Anyway, fixing that is easy: SELECT col1, col1 IS NULL AS isnull FROM tbl1 ORDER BY isnull DESC, col1 ASC That should give you the results ordered by col1, with the null-values at the top. - Martijn On Sat, Apr 18, 2009 at 19:54, Da

How to change where NULL values sort?

2009-04-18 Thread David M. Karr
I think normally NULL values will sort at the end, correct? I believe there's a way to make NULL values sort at the beginning, but I can't remember how to do it. I just searched a couple of MySQL resources, but I couldn't find it. -- MySQL General Mailing List For list archives: http://lists

Re: binlog question

2009-04-18 Thread Baron Schwartz
>> I would stay away from any of the do-db or ignore-db settings. >> > > Can you explain, why? They are dangerous. Search the list archives, I wrote a diatribe about it a while back. Cheers Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:h

Re: binlog question

2009-04-18 Thread Uwe Kiewel
Baron Schwartz schrieb: So, how it's possible to replicate one specific db? I have 4 db's writing into binlog. I need only one of them at client site. After the successful setup of the replication I get errors on client site like no such table, no such database etc... On the slave side, use --r

Re: binlog question

2009-04-18 Thread Baron Schwartz
> So, how it's possible to replicate one specific db? I have 4 db's writing > into binlog. I need only one of them at client site. After the successful > setup of the replication I get errors on client site like no such table, no > such database etc... On the slave side, use --replicate-wild-do-ta

Re: binlog question

2009-04-18 Thread Michael Dykman
You can configure your master to only write specific databases or tables to the bin log, if you only expect to replicate a subset. As normal practice, I always make my configuration as specific as possible. see http://dev.mysql.com/doc/refman/5.0/en/replication-options-binary-log.html and look

Re: binlog question

2009-04-18 Thread Uwe Kiewel
Michael Dykman schrieb: No, I'm afraid not. So, how it's possible to replicate one specific db? I have 4 db's writing into binlog. I need only one of them at client site. After the successful setup of the replication I get errors on client site like no such table, no such database etc... T

Re: binlog question

2009-04-18 Thread Michael Dykman
No, I'm afraid not. - michael dykman On Sat, Apr 18, 2009 at 7:11 AM, Uwe Kiewel wrote: > Hi, > > is it possible to have separated binlogs for each mysql-db? > > Thanks, >Uwe > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://li

binlog question

2009-04-18 Thread Uwe Kiewel
Hi, is it possible to have separated binlogs for each mysql-db? Thanks, Uwe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org