start help: What happens in MySQL when you start a transaction, perform stuff on tables and commit at the end… BUT! - Help.com

What happens in MySQL when you start a transaction, perform stuff on tables and commit at the end…

BUT! one of the tables wrapped in a transaction is MyISAM rather than InnoDB… is the transaction totally ignored or just cannot be rolledback for this one table?

This open post was written 2 years, 9 months ago | V/U/S: 378, 2, 3 | Edit Post | Leave a reply | Report Post


Reciprocity (0) Reciprocation Failure -- The poster has NOT helped anyone else yet!

Since writing this post intellix may have helped people, but has not within the last 4 days. intellix is a verified member, has been around for 2 years, 9 months and has 21 posts and 85 replies to their name.

Post Tags (9)

Transaction, this one, totally, tables, start, Table, MySQL, InnoDB, myisam (How Tags Affect Reciprocity)

Replies (2)

Where were you?

Click and drag to move the map around. FAQ: How we place people on this map »
You can also watch events on Help.com as they happen
Mouse over the map for 2 seconds to see an expanded, interactive view

bill.affle offline Verified User (12 months) Long Term User Shouts: 0 #
An Unknown Location | 12 months ago (1 year, 9 months after post)

For work with mysql database make use of http://www.mysql.repairtoolbox.com software open/read/scan/export-import mysql data

Quote this reply Report this reply to moderators
stan26scwar offline Verified User (12 months) Long Term User Shouts: 0 #
An Unknown Location | 12 months ago (1 year, 9 months after post)

It must be your mysql data is corrupted
If I’m right try to use following utility http://www.mysql.fixtoolbox.com

Quote this reply Report this reply to moderators

Invite Others to Help

A logged in and verified Help.com member has the ability to setup a Friends List and invite others to help with posts.