Hello,
I am using version MySQL v5.5.5-10.4.15-MariaDB-cll-lve. I would like to change the engine of some database columns (1/4 of them are on the MyISAM engine, including posts, topics, statuses, and the remaining 3/4 on InnoDB), so I have questions for you:
Can changing these tables delete some data? For example, if we have 3000 posts, it can suddenly become 2980 after conversion?
Which way is better: First way) Typing in turn for each table: ALTER TABLE wp_comments ENGINE=InnoDB; Second way) Manually changing the table setting:
Does it not matter which of the two options?
Do I need to do anything else after doing either of these two options? And it will rebuild some itself from MyISAM to InnoDB?
I will be grateful, especially @bfarberfor help.
Thanks 😘