Link to post

Share on other sites

But I think we have to think about a way to download everything. Fortunately (and because we decided early to migrate) there"s no hurry for now, we can think, study, test some ways to get the archive.

We don't have access to the DB, it's a fact. But it's not a new one, it's something that we've ever been facing to. We were depending on another community's tool and on a service that doesn't allow to get the data back. It's a long time known issue.

We can, from now, start to think how to get everything back whatever the way. No need for hurry.

No-one has ever, ever, asked me for a copy of the forum database. So this is most certainly not a 'long time known issue'.

You can have a copy of the MySQL db if you like. I just can't (and won't) include the users table, so it's useless for migrating to another host, but fine for extracting posts from.

Share this post

Link to post

Share on other sites

@NasimiAsl it would be awesome if we can get the backup from Rich and reinject the data into a new read-only category I can create in the new forum (like archive) or on some website (not sure I want them in the new forum as they will not be related to any user and not flagged as answered)

Share this post

Link to post

Share on other sites

I dumped the db today and it appears Invision puts the IP address of the poster in nearly every table

This isn't information I can release, so I'm going to have to tidy this all up before sending it. The db dump is over 600MB, excluding logs. Also, be aware it doesn't include file attachments. Not that you'd be able to upload them to Discourse anyway.

Share this post

Link to post

Share on other sites

It's fine, I just need to check all tables for an IP address column and blank them if they have them, plus erase the users table (you still have the usernames of those who made the posts in the actual posts table). Then you can do whatever you want with the actual data.

I can provide a dump of attachments too, but only once, as it's time-consuming. So let me know when you want me to do that. It will be up to you to consolidate these files with the attachment IDs in the database. I'm not sure how much space you get with Discourse, I think it's 1TB, before Deltakosh will have to start paying monthly to be hosted there.

Just to clarify - forum updates are paid for until April 2019, after which it will still work, but Invision won't be updated any longer. Without BJS or Phaser here traffic will be really small, so I can move it to a cheap VPS and keep it online indefinitely (or until some massive Invision security flaw comes out!)