Unable to import a database dump: SET FOREIGN_KEY_CHECKS = on; | CodimTh

Web tips, snippets & code sharing

Category:

Question:

I don't know the meaning of this error, how to import database without errors?

import database

Solution:

Change php.ini

max_execution_time = 600
max_input_time = 600
memory_limit = 1024M
post_max_size = 1024M

Change my.ini

max_allowed_packet = 1024M

Tags :

Drupal 8 & 9 & 10 Snippets Tips Drupal

Riadh Rahmi

Senior Web Developer PHP/Drupal & Laravel

I am a senior web developer, I have experience in planning and developing large scale dynamic web solutions especially in Drupal & Laravel.

Recent comments

Recent content

Create paragraphs and attach to node programmatically in drupal 10

Dependent select dropdowns using #ajax in node add/edit form drupal 8 & 9

Provide token for media entities in Drupal 8 & 9

Create custom image token in drupal 8 & 9

How To Create A Custom Token In Drupal 8 & 9

How To Use Batch API in Drupal 8 & 9

How to use Batch API to do heavy processing in Drupal 8 & 9

Disable cache for a block in Drupal 8

Create and Apply Patches using GIT DIFF and APPLY

How to change canonical URL programmatically in drupal 8 & 9

How to Create a Custom Field Formatter in Drupal 8 & 9

Programmatically update an entity reference field in Drupal 8 & 9

How To pass parameter from node to webform with custom token In Drupal 8 & 9

How to create media entities and attach them to paragraphs in Drupal 8 & 9

How to attach paragraphs to node programmatically in drupal 8 & 9