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

Please Disable Your Browser Adblock Extension for our site and Refresh This Page!

our ads are user friendly, we do not serve popup ads. We serve responsible ads!

Web tips, snippets & code sharing

On May 7, 2020 . By CodimTh

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 (Drupal & Laravel)

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

Recent comments

Recent content

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

Dependent select dropdowns using #ajax in node add/edit form 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

How to create custom contextual links programmatically in drupal 8 & 9