How to fix error when importing MySQL database?

Question

PHP

when importing database via MySQL console:

SOURCE C:\путь_к_БД\admin_tdekor.sql
following error occurs:
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`ce90120_tdekor`.`#sql-c88_22`,
CONSTRAINT `fk_product_term$product` FOREIGN KEY (`product_id`) REFERENCES `oc_product` (`product_id`) ON DELETE CASCADE ON UPDATE CASCADE)
tried to import it through phpMyAdmin, but since it is quite large in volume, the import is interrupted after a timeout and various errors also occur when re-importing .

wamp server 3.0.4.
MySQl version - 5.7.11,
phpMyAdmin version - 4.8.0.1,
encoding of the database into which I am importing - utf8_general_ci, table type - InnoDB

info about the imported database:
-- phpMyAdmin SQL Dump
-- version 4.7.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Server version: 5.7.22-0ubuntu0.16.04.1-log
-- PHP version : 7.2.1-1+ubuntu16.04.1+deb.sury.org+1

Answer 1

The best way to do a dump is with mysqldump.
If there is already a left dump, then add to the beginning:
and at the end:

/*!40014 SET [email protected]_FOREIGN_KEY_CHECKS */;

Answer 2

https://github.com/fadlee/bigdump