Re: mysqldump question

2005-05-13 Thread Aaron Wohl
http://www.birdsoft.demon.co.uk/proglib/slowpipe.htm would seem to do what you want... I havent tried it yet, but noted the URL for the next time I needed that functionality. - Original message - From: "Amit M Bhosle" <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Date: Fri, 13 May 2005 09

Re: Rollback

2004-01-02 Thread Aaron Wohl
You can add a version field to each row. Then add a seperate table with info with a list of the versions and a flag for deleted. Queries would look for each record that has the highest version number thats not deleted. Having a lot undo/redo info can get kind of complicated, especialy with multip

Re: Migration to INODB?

2003-11-21 Thread Aaron Wohl
Run all your tables thru this. Save the script as xinno_convert. As in xinno_convert < foo.sql | mysql Suposedly you can also alter a table to innodb. But that never worked for me it just looped using cpu for days. So I made this script which worked fine. Other than converting implicit lockin