Answer the question
In order to leave comments, you need to log in
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;
Error: 2055: Lost connection to MySQL server at 'localhost:3306', system error: 10054 An existing connection was forcibly closed by the remote host
[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 questionAsk a Question
731 491 924 answers to any question