MySQL Forums
Forum List  »  Newbie

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.

Options: ReplyQuote


Subject
Written By
Posted
error messages while importing sql file
November 23, 2011 04:00PM


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.