Re: [ANN] PBXT storage engine version 1.0-Alpha released

2008-03-21 Thread Moon's Father
learnt On Tue, Mar 18, 2008 at 3:39 PM, Paul McCullagh [EMAIL PROTECTED] wrote: Yes, definitely. Previous versions of PBXT built on Windows, so there can't be much work to get it going. But I don't think I will get around to firing up my Windows VM until after the conference... On Mar

Re: binlog sequence # rollover

2008-03-21 Thread Moon's Father
This is my test 13795620 8.0K -rw-rw 1 mysql mysql 146 Mar 21 17:58 mysql.100 13795622 8.0K -rw-rw 1 mysql mysql 146 Mar 21 17:58 mysql.101 13795623 8.0K -rw-rw 1 mysql mysql 106 Mar 21 17:58 mysql.102 On Thu, Mar 20, 2008 at 10:08 PM, Baron Schwartz [EMAIL PROTECTED]

Re: Optimize db update

2008-03-21 Thread Velen
This does not solve my problem. DatabaseA and DatabaseB are on 2 seperate pc and the only communication that can be use between the two PC is a USB pendrive. Is there another way of copying a table from one Database to another? I don't want to update TableA directly as I want to validate the

Re: Optimize db update

2008-03-21 Thread Daniel Brown
On Fri, Mar 21, 2008 at 9:14 AM, Velen [EMAIL PROTECTED] wrote: This does not solve my problem. DatabaseA and DatabaseB are on 2 seperate pc and the only communication that can be use between the two PC is a USB pendrive. Is there another way of copying a table from one Database to

Re: Optimize db update

2008-03-21 Thread Velen
This one is alright but is there an alternative that can be run with the mysql prompt? Thanks. Velen - Original Message - From: Daniel Brown [EMAIL PROTECTED] To: Velen [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Friday, March 21, 2008 6:00 PM Subject: Re: Optimize db update

Re: Optimize db update

2008-03-21 Thread Daniel Brown
On Fri, Mar 21, 2008 at 10:04 AM, Velen [EMAIL PROTECTED] wrote: This one is alright but is there an alternative that can be run with the mysql prompt? Not to dump a file, but to import, yes. Check out the LOAD DATA INFILE command:

Re: doubt: mysqldump in linux like windows

2008-03-21 Thread dr_pompeii
Hello the process of the restore is painful. i see even in windows, i dont know why made the backup in that way, (i dindt change any option to make the backup in the mysql administrator) if you say that the restore would be painful thank for your time Moon's Father wrote: If you skip

innodb transaction not works

2008-03-21 Thread Saravanan
Hi lists, We are running database with mixed tables myisam and innodb. I know that innodb supports transactions. My server is running with default transaction-isolation=REPEATABLE READ Whenever our cron runs stats updation scripts. It locks whole table and make other sql statements which

RE: innodb transaction not works

2008-03-21 Thread Rajesh Mehrotra
Hi Saravanan, Please check http://forums.mysql.com/read.php?97,18003,18003 -Raj. -Original Message- From: Saravanan [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2008 1:59 PM To: mysql@lists.mysql.com Subject: innodb transaction not works Hi lists, We are running database with

InnoDB Hot Backup

2008-03-21 Thread Waynn Lue
I'm thinking of buying a license for this tool to do a migration from one server to another, but it's been hard for me to find good documentation on it after searching for awhile last night. Is it possible for me to migrate from a 32-bit to a 64-bit system across a network? How long would

Re: 64bit to 32bit

2008-03-21 Thread Craig Huffstetler
I do not foresee any issues or problems with the upgrade or the way you are handling it. MySQL replication should start fine. Just make sure the snapshot of the database is as current as possible so the I/O etc. catches up as quickly as possible (which has nothing to do with your 32/64bit

Re: InnoDB Hot Backup

2008-03-21 Thread Waynn Lue
Oh, and a followup question that I forgot to ask--what if the two systems have different db schemas? Is it possible to do some sort of mapping between the two? On Fri, Mar 21, 2008 at 1:48 PM, Waynn Lue [EMAIL PROTECTED] wrote: I'm thinking of buying a license for this tool to do a migration