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

Hablando de Ruby y Wayback Machine. El fin de semana pasado probé a descargar todo el sitio web archivado usando waybackmachinedownloader. Empecé con esta versión, que incluye las instrucciones de instalación:

Y al final acabé usando este fork:

Creo que me bloquearon por hacer demasiadas peticiones y no poner un retraso (delay), ya que al cabo de un rato solo me salían errores 403. A lo mejor cambió algo.

14

Una vez instalado, usé el símbolo del sistema de Ruby mediante ruby 4.0(admin privs) >

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

luego copié y pegué esto desde una marca de tiempo

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

Eran como más de 99.000 archivos o algo así. Podría tardar mucho tiempo. La recopilación de instantáneas no tardó mucho, pero me sigue saliendo el error 403, así que no estoy seguro de qué está pasando. Logré descargar algunos archivos antes de que empezara lo del 403 :frowning:

15

Hola:

Tal vez esta información ya esté en alguna parte del foro, pero no logro encontrarla.
Quería saber si los mensajes del foro antiguo se van a importar o si se podrá acceder a ellos en algún archivo, o si se han perdido por completo.

16

Trabajando en volver a activar el foro antiguo; en el mejor de los casos, estará disponible este mismo fin de semana.

17

¡Genial, gracias por la información! :slight_smile:

18

@Gryzor ¿cuál es la mejor manera para que las personas que tienen los medios te envíen algo de dinero para ayudar a cubrir los costos aquí?

19

¡Hola, amigo!

De verdad, muchísimas gracias.

Se puede usar PayPal.Me . De todas formas, agregaré (en algún momento) niveles de suscripción al foro también. El único beneficio será, como en el foro anterior, que los donantes tendrán un distintivo especial en su avatar.

Gracias de nuevo,

T