error messages while importing sql file
Posted by:
Zoltan Sz
Date: November 23, 2011 04:00PM
Hi Friends,
When I import an sql file in the Command Line Client into a previous version of the database (created manually), I receive various error messages, like these:
ERROR 1366 (HY000): Incorrect string value: '\xC3\xA1s Es...' for column 'UserNa
me' at row 201
ERROR 1298 (HY000): Unknown or incorrect time zone: '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'
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'
mysql>
What should I do to eliminate these error messages? Would it make a sense to delete the existing database first and to import the new version?
Any help is highly appreciated,
Zoltan
Edited 4 time(s). Last edit at 11/23/2011 04:43PM by Zoltan Sz.
Subject
Written By
Posted
error messages while importing sql file
November 23, 2011 04:00PM
November 23, 2011 05:48PM
November 23, 2011 06:14PM
November 23, 2011 09:20PM
November 24, 2011 12:23PM
November 25, 2011 12:43AM
November 27, 2011 01:41PM
November 27, 2011 02:25PM
November 27, 2011 02:40PM
November 27, 2011 04:56PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.