Skip to Main Content

Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error 1231 al restaurar BD en Mysql

3030333Sep 29 2018

Hola, Buenos días.

Tengo un problema:

Acabo de instalar Oracle Linux 7.5  y MySQL 5.7.22 en  OVM

pero al tratar de restaurar un Dump me da los siguientes errores:

ERROR 1231 (42000): Variable 'time_zone' can't be set to the value of 'NULL'

ERROR 1231 (42000): Variable 'sql_mode' can't be set to the value of 'NULL'

ERROR 1231 (42000): Variable 'foreign_key_checks' can't be set to the value of 'NULL'

ERROR 1231 (42000): Variable 'unique_checks' can't be set to the value of 'NULL'

ERROR 1231 (42000): Variable 'character_set_client' can't be set to the value of 'NULL'

Query OK, 0 rows affected (0.00 sec)

ERROR 1231 (42000): Variable 'collation_connection' can't be set to the value of 'NULL'

ERROR 1231 (42000): Variable 'sql_notes' can't be set to the value of 'NULL'

el dump lo cargue con source /ruta del respaldo/respaldo.sql

Saludos y gracias de antemano por su ayuda.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 27 2018
Added on Sep 29 2018
0 comments
443 views