How to edit a huge SQL file?

Question

linux

Hello!

We plan to transfer the database from myisam to InnoDB by dumping the current tables and importing them with the InnoDB parameter instead of myisam.

The problem is compounded by the fact that we have a 50 GB table, and when editing a dump file with this table with the sed command, the approximate time to change the table type will be 25 hours, which is a very long time.

Are there other ways to solve this problem?
Method ALTER TABLE table_name ENGINE=InnoDB; it makes no sense to offer, it will take even more time.

Answer 1

Why not make 2 dumps
1. structure
2. data
There is an even more advanced way to use data synchronization utilities. They handle more complex cases.

Answer 2

on the dock did not try?
UPD: https://serverfault.com/questions/51982/converting...
UPD2: emnip, it seems like all indexes and keys must be killed, then convert and create keys / indexes, which will seriously speed up the process.

Answer 3

I am not a mysql expert. But in other DBMS, CTAS/alter table rename is sufficient for any type and storage geometry changes.
Sed is generally a bad ETL utility. Don't use it.