I accept that answer
This is what I ended up doing should someone else get themselves in the same situation (I doubt that!):
- Make copy of MySQL database.
- Convert database copy and tables to UTF-8 if necessary.
- Export to CSV via Vanilla Porter - requires some small changes in the source to support older ExpressionEngine versions.
- Install Vanilla and import CSV into new database.
- Use
vanilla_mysql.rb
to import from this database - either remotely or locally.
@riking: Regarding that last step I had to make minor correction because users is not defined in
next if all_records_exist? :users, users.map {|u| u['UserID'].to_i}
Not making any PR’s because I know nothing about Ruby.