RE: backup InnoDB db to another server
-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 innodb We have a mix of InnoDB and MyIsam tables so that's really not an option. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: backup InnoDB db to another server
-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 data only. Osvaldo Sommer Actually I think it's more than that. We have cleaning scripts put place to delete records older than 3 months from certain tables. I think the users have been running these without optimizing the tables afterwards and therefore never reclaiming the space the created with the deletes. These tablename_Old tables were huge. On the main systems I did a mysqldump of just these tables, then dropped the originals from the db and restored them. The entire db size went from 65G to 20G. The database was already screwed up and I have another master running for our applications so there was no risk if I screwed something up. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Browser - limit 1000 by default?
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, on Linux version of MySQL Browser (v 1.2.4 beta), when double-click on any table, default query is SELECT * FROM table_name LIMIT 0,1000 On Win version (v 1.2.9 rc), there is no LIMIT part - what caused me to pull so many times tens, even hundreds thousands of records. I was looking for in setting for this feature, but wasn't able to find. is there way to set the limit value on default select query, on win version? thanks for any help. -afan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Browser - limit 1000 by default?
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- 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, on Linux version of MySQL Browser (v 1.2.4 beta), when double-click on any table, default query is SELECT * FROM table_name LIMIT 0,1000 On Win version (v 1.2.9 rc), there is no LIMIT part - what caused me to pull so many times tens, even hundreds thousands of records. I was looking for in setting for this feature, but wasn't able to find. is there way to set the limit value on default select query, on win version? thanks for any help. -afan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Order table by org heirarchy (emp-mgr)
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 | name | mgr | +--+---+--+ | 1001 | Denis Eaton-Hogg | NULL | | 1002 | Bobbi Flekman | 1001 | | 1003 | Ian Faith | 1002 | | 1004 | David St. Hubbins | 1003 | | 1005 | Nigel Tufnel | 1003 | | 1006 | Derek Smalls | 1003 | +--+---+--+ The number happened to be sorted here - but that may not be the case - there are new manager hires etc.. Thanks. On Dec 1, 2007 4:48 PM, Anoop kumar V [EMAIL PROTECTED] wrote: Hi Experts, I need a small help - I think the solution is not complex, but I am not sure where to start. Here is my problem. I have a table that defines the employee to manager relationship. This table will interface with another system and the users would be created in the other system. There will be a pointer to the user who is the manager of the currently processed user. So if the manager user has not yet been created, the current user process will not complete as the pointer to the manager-user does not exist. So I need to ensure that all managers are created first before creating the users. But managers are also like other users in the same table in the emp column. Here is a sample of the table: mysql select * from emp; +--+---+--+ | id | name | mgr | +--+---+--+ | 1006 | Derek Smalls | 1003 | | 1005 | Nigel Tufnel | 1003 | | 1004 | David St. Hubbins | 1003 | | 1003 | Ian Faith | 1002 | | 1002 | Bobbi Flekman | 1001 | +--+---+--+ 6 rows in set (0.00 sec) I need to sort this table to look like this: +--+---+--+ | id | name | mgr | +--+---+--+ | 1001 | Denis Eaton-Hogg | NULL | | 1002 | Bobbi Flekman | 1001 | | 1003 | Ian Faith | 1002 | | 1001 | Denis Eaton-Hogg | NULL | | 1004 | David St. Hubbins | 1003 | | 1005 | Nigel Tufnel | 1003 | | 1006 | Derek Smalls | 1003 | +--+---+--+ See how 1001 is the manager of everybody - so I can create this user first, that would take care of 1002 as it would contain a link to the 1001 user and all would be good. So on for 1002 and 1003 I think I need to do a self join and order by - if you could even give me a hint that would be most helpful. Thanks, Anoop No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.16.13/1164 - Release Date: 12/2/2007 11:30 AM
Re: MySQL Browser - limit 1000 by default?
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: 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, on Linux version of MySQL Browser (v 1.2.4 beta), when double-click on any table, default query is SELECT * FROM table_name LIMIT 0,1000 On Win version (v 1.2.9 rc), there is no LIMIT part - what caused me to pull so many times tens, even hundreds thousands of records. I was looking for in setting for this feature, but wasn't able to find. is there way to set the limit value on default select query, on win version? thanks for any help. -afan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]