By timdp on

I backed up my database several times using phpMyAdmin export. Then I accidentally destroyed my active one, but after 12 hours straight, I am not close to restoring yesterday's backup. The reason seems to be that although I think I backed up in utf8 (so it says at the top of the file) and I am restoring in utf8, many special characters like m-dashes truncate record fields. This leads to duplicate keys (which I can edit out in the backup) or truncations in the large amounts of text content which are so many I don;t think I can do them by hand.

I am getting desperate - I think I have to clean up the special characters in teh backup. But perhaps that's not even the solution.

Does anyone have any clues? Thank you.

⋅ Categories: Drupal 6.x

Comments

timdp’s picture

timdp commented

Even a simple apostrophe truncates a text record.

timdp’s picture

timdp commented

I haven't put the site back up yet, so I can't be certain, but the DB is restored and looks healthy. The answer, in case anyone else experiences this frustrating problem, was to open the .sql file in Notebook and save as utf8. Then restore; 14 hours to figure out and 1 minute to do.