Re: MySQL Browser - limit 1000 by default?

2007-12-02 Thread barry
I'm talking about the Linux (ubuntu) version. On Sun, 2007-12-02 at 10:00 -0600, Afan Pasalic wrote: > hi barry, > this is on Linux version of MySQL Query Browser. I need the same on Win > version. But, there is no such a solution (Tool > Option > ...). > :( > > -afan > > > > barry wrote: > >

Re: Order table by org heirarchy (emp-mgr)

2007-12-02 Thread Peter Brawley
Anoop, It's an edge list tree, so unless you can specify max recursion depth, you need an sproc. See listing 7c at http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html. PB Anoop kumar V wrote: The resultant table should be this: +--+---+--+ | id | nam

Re: MySQL Browser - limit 1000 by default?

2007-12-02 Thread Afan Pasalic
hi barry, this is on Linux version of MySQL Query Browser. I need the same on Win version. But, there is no such a solution (Tool > Option > ...). :( -afan barry wrote: I'm assuming you're talking about the Mysql Query Browser? You can change the number of records under Tools-> Preference

Re: MySQL Browser - limit 1000 by default?

2007-12-02 Thread barry
I'm assuming you're talking about the Mysql Query Browser? You can change the number of records under Tools-> Preferences and changing the "Max Rows For Generated Queries" to whatever you want, set to zero removes the limit entirely. On Sat, 2007-12-01 at 15:17 -0600, Afan Pasalic wrote: > Hi,

RE: backup InnoDB db to another server

2007-12-02 Thread Jeff Mckeon
> -Original Message- > From: Osvaldo Sommer [mailto:[EMAIL PROTECTED] > Sent: Saturday, December 01, 2007 8:23 AM > To: 'Jeff Mckeon'; 'David Campbell'; mysql@lists.mysql.com > Subject: RE: backup InnoDB db to another server > > Jeff: > > Mysqldump don't back up your index, that's your da

RE: backup InnoDB db to another server

2007-12-02 Thread Jeff Mckeon
> -Original Message- > From: js [mailto:[EMAIL PROTECTED] > Sent: Saturday, December 01, 2007 8:11 PM > To: Jeff Mckeon > Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com > Subject: Re: backup InnoDB db to another server > > You might want to use --single-transaction option when mysqldumping