Stack Overflow en español Asked by ilernet on July 30, 2020
intento hacer una copia de una bd mysql en remoto con mysqldump y obtengo este error y la verdad no se por donde tirar.
Intento conectarme y hacer una copia de toda la base de datos.
C:Windowssystem32>mysqldump -h 212.XXX.XXX -P 3306 -u usuario1 -p intranet > dump.sql
Enter password: **********
mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM,'$."number-of-buckets-specified"') FROM information_schema.COLUMN_STATISTICS
WHERE SCHEMA_NAME = 'intranet' AND TABLE_NAME = 'proveedores';':
Unknown table 'COLUMN_STATISTICS' in
information_schema (1109)
Gracias,
En la versión 8 de MySQL el comando mysqldump
trae activada por defecto la bandera column-statistics
, la cual es incompatible con versiones anteriores de MySQL.
Al parecer el dump de hizo en una versión MySQL 8+ y ahora intentas restaurar en una versión más vieja.
Si es posible, se recomienda actualizar tu versión de MySQL. En caso de no ser posible, puedes apagar esa opción al hacer el dump poniendo la bandera: --column-statistics=0
, por ejemplo:
C:Windowssystem32>mysqldump --column-statistics=0 -h 212.XXX.XXX -P 3306 -u usuario1 -p intranet > dump.sql
Para más detalles consulta esta respuesta en ServerFault.
Correct answer by A. Cedano on July 30, 2020
1 Asked on January 19, 2021 by jonathan-alarcon
1 Asked on January 19, 2021 by david-l
1 Asked on January 19, 2021 by ivanrangel
2 Asked on January 18, 2021
3 Asked on January 18, 2021 by alfredo-arvelaez
3 Asked on January 18, 2021 by yasiel-hernndez
1 Asked on January 18, 2021 by luis-benito
1 Asked on January 17, 2021 by reynald0
0 Asked on January 17, 2021 by ezer2020
1 Asked on January 16, 2021 by m-angel-ambrose
0 Asked on January 16, 2021 by alex-gz
1 Asked on January 15, 2021
0 Asked on January 15, 2021 by sergio-durn-vega
1 Asked on January 15, 2021 by genarito
0 Asked on January 15, 2021 by david-torres-v
0 Asked on January 15, 2021 by dante-turcutto
Get help from others!
Recent Answers
© 2022 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP, SolveDir