Erreur "mysqldump: Couldn't execute 'SELECT COLUMN_NAME" lors du restore - Sauvegarde et restauration Base de données https://www.simax.fr/actualites-et-echanges-espaces-forum/f-sauvegarde-et-restauration-base-de-donnees/t-erreur-mysqldump-couldn-t-execute-select-columnname-lors-du-restore/ NOUT SAS ; Bienvenue sur nos espaces de discussion autour des solutions SIMAX™ fr-FR Fri, 07 Aug 2026 11:26:21 +0000 wpForo 60 Erreur "mysqldump: Couldn't execute 'SELECT COLUMN_NAME" lors du restore https://www.simax.fr/actualites-et-echanges-espaces-forum/f-sauvegarde-et-restauration-base-de-donnees/t-erreur-mysqldump-couldn-t-execute-select-columnname-lors-du-restore/#post-203 Mon, 17 May 2021 11:56:12 +0000 Description :
mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"') FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = 'prod' AND TABLE_NAME = 'enplus';': Unknown table 'column_statistics' in information_schema (1109)
Operation failed with exitcode 2

Solution :
Dans MySql Workbench version 8.0.13 do the following steps:
Go to Management/Data export
Choose the schema to export in the 'Tables to export' list
Click the 'Advanced Options...' button (top right)
Search for the option 'Other/column-statistics'
Set the value to 0
Click the 'Return' button (top right)

]]> Sauvegarde et restauration Base de données nsimax34170 https://www.simax.fr/actualites-et-echanges-espaces-forum/f-sauvegarde-et-restauration-base-de-donnees/t-erreur-mysqldump-couldn-t-execute-select-columnname-lors-du-restore/#post-203