I recently ran across a replication error in mysql that looks a bit like the following: Error: 'Incorrect information in file… … .frm on query' If you run the command: mysql -e 'show engines' You will see that the InnoDB engine is DISABLED. Since mysql ships with InnoDB enabled by default, this is a strange [...]
Browsing Posts tagged innodb
I needed dump some data from a restored ibdata file on a production server. In order to do this, a second instance of mysql was started with a separate data directory. Here are the steps to make it happen. 1. Create a new data directory. mkdir /var/lib/mysql2 2. Install the base mysql server files. mysql_install_db [...]
