0
votes
1answer
707 views

Safe conversion from one InnoDB(ibdata) file to innodb file per table

I have MySQL database with tables on InnoDB engine. But server is configured to use only one file ibdata0 without parameter innodb_file_per_table. I want to change this without making dump and restore ...
0
votes
0answers
359 views

Error 'Unknown table engine 'InnoDB'' on query. after restarting mysql

I have mysql DB on server S1 (mysql version 5.1.41-3ubuntu12.7-log), i have created master-slave for this DB on server S2 (mysql version 5.1.54-1ubuntu4-log). the DB on S1 was using one data file ...
1
vote
2answers
417 views

Switching To `innodb_file_per_table` In MySQL

If I turn on innodb_file_per_table (not currently active), will it destroy my existing tables?
2
votes
2answers
85 views

I already created a mysql database. However, for my future tables that I create, I want to default to INNODB

How can default to INNODB for every table to create in the future?
15
votes
5answers
3k views

How do you choose a MySQL database engine

In particular, how do you choose between MyISAM and InnoDB, when neither is missing a required feature (e.g. you don't need foreign keys). Does it always come down to trying both and measuring? Or ...