mysql импорт таблицы из файла ibd

Database changed
mysql> alter table abtest import tablespace;
Query OK, 0 rows affected, 1 warning (2 min 10.51 sec)

mysql> flush tables visitors for export;
Query OK, 0 rows affected (0.03 sec)

mysql> unlock tables;
Query OK, 0 rows affected (0.00 sec)

mysql> alter table visitors discard tablespace;
Query OK, 0 rows affected (0.03 sec)

mysql> alter table visitors import tablespace;
Query OK, 0 rows affected, 1 warning (13 min 4.41 sec)

 

MYSQL

Related Articles

0 Comment

Leave a Comment

Ваш адрес email не будет опубликован.