I need to re-import data tables for a forum and need help to do it correctly.
After my first import and convertion of database tables from my old forums (rs-discuss - RSD) I will need to reimport them. The first import caused problems with special characters in titles - æ/ø makes it impossible to open posts because the posts' slug is messed up.
I need to replace the data before I can convert the table contents to fit the new forum (SimplePress forum - SPF) - and eventually find out if the converter works as it should.
What would be the correct procedure? Should I...
a) Delete both the RSD and the SPF tables, export and then import the RSD tables - and then try the convertion (which will populate the SPF tables)?
b) Or isn't it necessary to delete any of the tables first?
c) Maybe just delete the SPF tables before running the convertion?
d) Delete nothing, just run a new conversion?
Also:
When exporting the RSD tables - should I export it as latin-1 (which some table fields are labeled) or as utf8?
Sorry - just don't know how these servers behave.
So some help is highly appreciated!
Thanks,
Kjetil
PS I use phpMyAdmin for this job. The two forums are using the same database. The first was startet last spring - maybe this tells something about which server software was/is used.
