E
E
Emil Revencu2021-07-14 13:14:13
MySQL
Emil Revencu, 2021-07-14 13:14:13

Can't import data from IBD file?

I'm trying to create a table from an IBD file

1. DROP TABLE IF EXISTS myTableName;
2. удаляю старый файл IBD
3. Создаю пустую таблицу myTableName
4. ALTER TABLE myTableName DISCARD TABLESPACE;
5. Копирую новый файл IBD (35Gb)
6. ALTER TABLE myTableName IMPORT TABLESPACE;

The process starts but after about 10 minutes I get an error:
Error: 2055: Lost connection to MySQL server at 'localhost:3306', system error: 10054 An existing connection was forcibly closed by the remote host


Some Settings:
RAM 16Gb
[mysqld]
wait_timeout = 999999
interactive_timeout = 999999
net_read_timeout=999999
connect_timeout=999999
bulk_insert_buffer_size=4294967295
innodb_buffer_pool_size=3G
max_allowed_packet=1G

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question