Hi all, trying to change the URL of my website which has an ugly address at the moment - 123907blah.netsolhost.com - by changing all occurrences of this in the database (exported via phpmyAdmin) to the official domain name that's already mapped to it (but couldn't connect to it via General Settings) then reimporting using phpmyAdmin again. The domain name works ok, I've checked it on absolute URLs to specific WP files.
It should be simple enough to export and re-import, but whenever I've tried this before, there's always some errors. So in this case, I get the error "#1062 - Duplicate entry '1' for key 1" in the wp_commentmeta table. I've searched for this throughout the forums, and the usual answer seems to be - you have a duplicate entry somewhere.
But my knowledge of databases is way short of what it should be - so what should I actually do in this case, to reimport the data? Can I simply delete the commentmeta table or fields, since (it seems to me) I don't need the comments left on the website's posts? Would that theoretically sort the problem, or would that mean problems in future if I decided I DID want more comment interactions?