I'm converting tables in an old MYISAM database to InnoDB to increase robustness in case of power loss etc.
I'm using Mysql 5.5.x
Before doing the production system, I am doing a trial run on a copy of the DB on a test machine - just in case.
I backed up the tables with mysqldump using this information.
Some tables take more than the timeout (600sec) to convert, and so I get an error 2013:
ALTER TABLE voice.members ENGINE=InnoDB Error Code: 2013. Lost connection to MySQL server during query
When I check the table later, it's listed as InnoDB.
show table status in voice like "members";
Here are my questions:
- Can I assume that the conversion went as intended?
- Are there any obvious checks I should perform to ensure that integrity is not compromized?
- Should I enforce that the DB is single user before conversion, or is my only worry that response time might be bad while conversion is ongoing + loss of work in case of a restore from the initial backup?