Error al hacer mysqldump

Al hacer un mysqldump me encontre con el siguiente error:

root@usefultips:~$ mysqldump -u user -p DatabaseName --protocol=tcp > ~/Downloads/salida.sql
mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"') FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = 'DatabaseName' AND TABLE_NAME = 'agenda';': Unknown table 'COLUMN_STATISTICS' in information_schema (1109)

Para solucionarlo, basta con agregar el siguiente parametro:

root@usefultips:~$ mysqldump -u user -p DatabaseName --protocol=tcp --column-statistics=0 > ~/Downloads/salida.sql

Leave a Reply

Your email address will not be published. Required fields are marked *