importing sql file thorugh phpmyadmin
Posted on 2009-04-01
I backed up a DB file for a Drupal website locally using phpmyadmin, but I can't upload it again. Either it fails because of duplicate keys, or if I edit the DB to prevent that (which I haven't succeeded in doing without making a nonsense of some data), it truncates lots of content, apparently where there are non-alphanumeric characters. BTW, I don;t think the duplicate keys are real, just looks that way if some key fields are truncated. SO perhaps truncation at non-alphanumeric characters on import is the whole problem.
IF I look at the data in e.g. wordpad, it seems to be fine - it isn't truncated. So I think the problem is reimporting through phpmyadmin onto a shared hosting service.
BTW, I have no real expertise in writing sql queries- I just followed instructions to export and import the DB through phpmyadmin.
I am desperate to get this data up again - help much appreciated.