Topic: problem with restore my db

i have a problem when i try to restory my database.

this is the problem

Error 1406 (22001): Data too long for column 'word' at row 1

when i try to put this line

INSERT INTO `search_words` VALUES (532, 0x6275726e696ec383c2a2c3a2e2809ac2acc3a2e2809ec2a2);

El Mejor Lugar de la Red - Corporación Azakur4

Re: problem with restore my db

What the hell? 0x6275726e696ec383c2a2c3a2e2809ac2acc3a2e2809ec2a2 does not look right smile

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Re: problem with restore my db

he easy fix is to remove all the lines starting
INSERT INTO `search_words`
and
INSERT INTO `search_matches`
then using maintenance to regenerate the search index after restoring.

Re: problem with restore my db

Yeah, but still. Where the hell did that huge hex code come from? smile

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Re: problem with restore my db

thanks , the hex code i don't know where out :S

El Mejor Lugar de la Red - Corporación Azakur4

Re: problem with restore my db

Result:
6275726e696ec383c2a2c3a2e2809ac2acc3a2e2809ec2a2
converts to:
burnin’

random corruption? weird tongue