hi , I have a problem using mysql transactions for InnoDB tables. I have a Backup and Restore Module , in this I start a Restore through which I update the database using a set of .sql files . When the restore is going on on the backframe I show a static progressbar along with a Cancel Button . At the time of clicking cancel , suppose 3 of 10 tables have got updated then i need to restore these 3 updated tables.
Now problem here is I start on page1.php the set AUTOCOMMIT=0 ; and then all the transactions go on , when cancel button is clicked , i goto page2.php where i do the rollback ; But this has no effect on the updated tables , they dont get restored . This all works fine when i do the AUTOCOMMIT=0 and rollback on the same page . pls help !!!!! Ravi Pandey (Do it my way) ([EMAIL PROTECTED]) __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed] Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
