MySQL Forums
Forum List  »  Newbie

Re: error messages while importing sql file
Posted by: Peter Brawley
Date: November 23, 2011 09:20PM

> some of the tables after the import became completely empty, even the old values have been deleted, instead of getting filled up.

I've no idea what that means.

> How I can import the content of the sql tables?

By running the dumpfile of course.

> 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).

Then MySQL must be issuing error messages.

>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

That looks like a charset/collation problem. You might find help on that at http://mysql.rjweb.org/doc.php/charcoll

> 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"?

As above.

> Where can I set the character set for a non-existing table?

I've no idea what that means.

Options: ReplyQuote


Subject
Written By
Posted
Re: error messages while importing sql file
November 23, 2011 09:20PM


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.