RE: import all data from the old forum into the new one (highly unlikely)

General CPCWiki related
1

Hey Gryzor, Long time.

I was Extreme Gamer on CPC Zone back in the day(silly egg avatar > Dizzy)

Anyway, I posted this on Xyphoe discord to a different Gryzor(egg on face) but didn’t want this to sink into oblivion as might be of use thought wise.

It probably more likely if it was done in an archived state to new forum or just to a subdomain << which removes major headache.. Not simple but doable. Ignore stuff like avatars its the data being available that is relevant.

Take a sample set of your old database .sql backup. Lets say work with 6 categories and ten posts per cat.

rename table rows and columns to reflect the database structure of the new forum db. If you need to enter a column inbetween 2 columms there is a sql command to do that so that the query doesn’t fail on select query

It been an extreme long time thinking about sql for me but if you know someone very long standing in the community(who you trust) with up to date knowledge and expertise. I say its well doable and if thought out right AI like claude might just make it a helluva lot easier.

Just food for thought.

2

Hey man, glad to see you here! I actually missed your avatar​:grin:

You’re describing a migration, actually, if I’m getting it correctly.

Well, believe me, much more capable men than me have tried. The official importer is, unfortunately, half-baked.

I’ll try to find a thread I had read where someone got close, so that you can get an idea of what it entails.

However, one thing we do want to do is to put up the old forum on read only form. That’ll be something, at least.

3

I’d call it a migration of some type.

Its all done by hand on a localhost server, per se. The reason I thought of a subdomain for it as people can just post links from it to continue discussions and while its WIP can be locked up via .htaccess once deployed semi live etc

Right, off to get tipsy now. Good to see the place back.

4

Ohh so you mean copy paste data by hand?

Yeah probably not doing that :grin: If anyone wants to I cutie probably export a chunk for them to convert, but I don’t think it’s worth it, sadly.

Have a good one!

5

Ah, No worries.

This seems to be the latest snapshot that kind of works on Wayback Machine

Some of the posts have been crawled, and some just don’t work

I thought I’d stick it here. I had the though of using a wayback machine downloader but its an all or nothing kind of thing for me.

6

Yeah, started working on the restoration of the old forum today a bit. Only some light reading to remind me how it was set up to prepare the new server accordingly. So hopefully we’ll know within days. Emphasis on hopefully

7

Good to hear.

I’ve been messing for like 20 mins on the wiki application section and a fair few .zip files download. Sadly, some just get a 403 error. But I’m rather impressed how many actually download.

8

That’s impressive indeed, given that the db was so badly damaged that it was essentially wiped out…

9

I know Discourse the company has a migration service but it’s possible they already have a script for the old forum software and maybe they share that script under the AGPL.

@Typhon I promise not to get into a licensing discussion here too :wink:

10

yeah they do have an importer, but as far as I can tell it’s far from perfect and is basically a base for others to work on :frowning:

11

I know a little bit of Ruby (although I did get a personal lesson from Matz himself!) if you’re thinking of going down the import route.

12

Thanks, much appreciated. But I don’t think you need to touch Ruby for this…

13

A proposito di Ruby e della Wayback Machine. Lo scorso fine settimana ho provato a scaricare l’intero sito archiviato usando waybackmachinedownloader. Ho iniziato con questa versione, che contiene le istruzioni per l’installazione:

Alla fine sono finito su questo fork:

Penso di essere stato bloccato perché facevo troppe richieste senza alcun ritardo, e dopo un po’ ho iniziato a ricevere un sacco di errori 403. Forse era cambiato qualcosa.

14

Una volta installato, ho usato il prompt dei comandi di Ruby tramite ruby 4.0(admin privs) >

cd C:\Users\yourusername.local\share\gem\ruby\4.0.0\gems\wayback_machine_downloader-2.3.1\bin

poi ho copiato e incollato questo da un timestamp

wayback_machine_downloader http://cpcwiki.eu --from 20101203024504 --delay 7.0 >> ruby cmd window

Erano circa 99.000+ file o qualcosa del genere. Potrebbe volerci molto tempo. La raccolta degli snapshot non è durata molto, ma continuo a ricevere l’errore 403, quindi non sono sicuro di cosa stia succedendo. Sono comunque riuscito a scaricare alcuni file prima che iniziasse la storia del 403 :frowning:

15

Ciao,

Forse questa informazione è già presente da qualche parte nel forum, ma sembra che io non riesca a trovarla.
Vorrei sapere se i messaggi del vecchio forum verranno importati o se saranno accessibili in un archivio da qualche parte, oppure se sono andati completamente perduti.

16

Sto lavorando per rimettere online il vecchio forum; nel migliore dei casi, sarà attivo entro il fine settimana.

17

Ottimo, grazie per l’informazione :slight_smile:

18

@Gryzor qual è il modo migliore per chi ne ha le possibilità di inviarti un po’ di soldi per aiutarti a coprire alcune spese qui?

19

Ehi amico,

Davvero, davvero felicissimo e grato per il tuo aiuto.

Si può usare PayPal.Me . Comunque aggiungerò (prima o poi) anche dei livelli di abbonamento al forum. L’unico beneficio sarà, come nel vecchio forum, che i sostenitori avranno uno stemma speciale sul proprio avatar.

Grazie ancora,

T