Re: error messages while importing sql file

[Zoltan Sz]

Yes, but I missed to archive the old db. My major problem is that some of the tables after the import became completely empty, even the old values have been deleted, instead of getting filled up.
How I can import the content of the sql tables?
If I delete a table before import, it will be re-created during the import, but no values will be imported (although the values are available in the sql file).
It is strange that if there is no table, and the table is created, I get following error message:
Incorrect string value: '\xC3\xA1s Es...' for column 'UserNa
me' at row 201
Is it maybe a character set problem? In the source database I have Hungarian characters. In some cases I specified it as UTF8, in some cases as latin2. Which set is the "correct"?
Where can I set the character set for a non-existing table?

Again, the problem is:
1) I exported the database with the tables
2) I deleted the tables in the empty target database
3) I get error message when importing into the empty database

How and why do I get error message, since the target database is empty?

I also get following error message:
ERROR 1406 (22001): Data too long for column 'PTitle'
How can it be too long, if it is not too long in the original database?
Can it be a compatibility issue? Or the characters are converted somehow so that a special character will be more characters?



Edited 3 time(s). Last edit at 11/23/2011 07:36PM by Zoltan Sz.