I have a very old site. The database was created through cPanel, or maybe it was so old that the software created when I installed it, not sure.

Either way, my host said it was not created correctly. I was trying to add a user so I could query the database to add things back that are missing from v5 and I could not create a user.

I closed the site, downloaded the database, created a new database in cPanel, then imported the data.

All seems to be working, it's been about a week, but I notice a lot of odd characters on some of the older posts.

For instance,  posted where there should have been a space.

Is there something I can do (a replace query?), or just leave it alone - they're "old" posts anyhow. Part of the issue is, there are almost 2m posts, and people often dig up old ones.

Thanks

Unfortunately, there isnt really any correcting that or than a new export and import. The issue there would be caused by an incorrect export and import of the database and its charset when this was done.

Thanks, I'm doing a replace query for some of the common ones (I know - don't do that...) :)