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 Snippets Tips Drupal

Comments

Add new comment

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 and Laravel.

Recent comments

Recent content

Disable cache for a block in Drupal 8

Create and Apply Patches using GIT DIFF and APPLY

How To Use Batch API in Drupal 8 & 9

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

How to add a html field to a form in drupal 8 & 9

How to redirect an anonymous user to the login form after a 403 error in Drupal 8 & 9

How to redirect anonymous user in Drupal 8 & 9

How to get all vocabularies in drupal 8 & 9