mysql - How do I view the contents of an ibdata file? -
given mysql
ibdata
file (originally located @ /var/lib/mysql/
on ubuntu server), there way view in human readable format.
i understand it's not possible convert csv. appears kind of hex format.
and understand, ibdata
file steps take database it's current state.
essentially view each of steps. don't have associated .frm
files tables.
although not human readable, it's possible convert mysql ibdata
files various purposes. have tried innodb recovery tool? https://launchpad.net/percona-data-recovery-tool-for-innodb
documentation available @ http://www.percona.com/docs/wiki/innodb-data-recovery-tool:start
Comments
Post a Comment