… ago, I had to convert all tables of a database from MyISAM to InnoDB on a new server. The plan was to take a logical dump…. mysqldump has options to export schema and data separately, let’s use them: # Export schema $ mysqldump –no-data sakila > schema.sql # Export data $ mysqldump…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… data in MyISAM table so all you have to do is to drop old table and convert new table back to Innodb after restarting without innodb_force… in case you will need to look into it more later. Another alternative is to dump table with MySQLDump and load it back. It is all pretty much the same stuff. I’m using MyISAM table…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… need to keep into account possible query changes, replication etc. Q: Is it possible to move MyISAM to Innodb through … is really no gain in dumping table via mysqldump and loading it back. If performance is …MySQL Replication to work. You might need to inject MySQL 5.0 in between so it will convert …
Comment: Is DRBD the right choice for me?
December 12, 2012 By 18 Comments
… you use InnoDB exclusively and pass the –single-transaction flag. If you do have (large) MyISAM tables you can’t convert to InnoDB due to using FULLTEXT/RTREE index, you might use LVM snapshots rather than mysqldump –single-transaction…
Post: Living with backups
November 6, 2008 By 28 Comments
…to wait much longer until disk operations are scheduled and executed which converts…MyISAM tables which have dedicated buffers only to…to the incoming queries quick enough. What can be done about it? Nothing really when you are using mysqldump…
