KF Related - General Knowledge I think I can recover a good part of the Kiwfarms General Thread

[𒂶𒃑𒄀𒄖𒄦𒅑𒆑]

Funny joke

 

[Crimson Fucker]

He's probably in hospice due to his age and weight.

he's old for fuck's sake. give him some slack already. I still agree what kengle did is shitty

 

[Crimson Fucker]

now I'm going to drink your blood

Hey, that's my thing. (Joke based on my username.)

 

[Crimson Fucker]

I had the developer set this up as a daily backup offsite. However, what I did not anticipate was that the developer did this incorrectly so that when the file was backed up there was no SQL being backed up. I did not find this out until a couple of days ago. Then we had issues with the sites going down because of lack of disk space. I am sorry but this was something I had no control over. What I am trying to do is to recreate the thread from screengrabs in the archive.

Did you have control over your finger when you deleted the thread?

 

[Crimson Fucker]

I get it. It sucks because I was on the ground floor with you people. Only a small portion of the original thread was able to be restored from the backup. But I can recreate a lot of the material from the snapshots in the archive to try and minimize the loss.

Doubt

 

[Crimson Fucker]

It's better than nothing I supposed

It's what it will be, I doubt he will restore any of it.

 

[fag0t]

and nothing of value was lost

 

[Crimson Fucker]

and nothing of value was lost

This site didn't shut down yet.

 

[Cat Administrator]

This site didn't shut down yet.

And it won't.

 

[Cat Administrator]

First 100 Pages
Pages 1 to 38 Can be recovered
Pages 39 to 40 Lost
Pages 41 to 52 Can be recovered
Pages 53 to 55 Lost
Pages 56 to 64 Can be recovered
Pages 65 to 68 Lost
Pages 69 to 77 Can be recovered
Pages 78 to 85 Lost
Pages 86 Can be recovered
Pages 87 to 89 Lost
Pages 90 to 91 Can be recovered
Pages 92 to 100 Lost

71 Pages can be recovered. 29 are lost.

 

[cosmic veteran]

@Kenneth Erwin Engelhardt then make sure when your site creates backups, it creates an sql file too. in fact, you should tell your developer to configure your site's automatic backup system to create an sql file every time it creates a backup

 

[fag0t]

he should continue to fuck shit up

 

[polonium]

he should continue to fuck shit up

It's part of the rustic charm of the place at this point

 

[ecto_chasm]

I have been checking the internet archive for back copies of Onionfarms and then have been going in there to the KF General thread. I think I can recover most of the pages. I have been saving each page as a MHTML document and I want to make them available. From what I have checked in the internet archive there were 380 pages listed but not all of them have been saved. But I may be able to get 2/3 to 3/4 of them recovered. Some of the pages were not archived and they are gone but I think I can get quite a bit of content recovered.

Godspeed! If ED can do it, so can you.

 

[Time 4 Guillotines]

@Kenneth Erwin Engelhardt then make sure when your site creates backups, it creates an sql file too. in fact, you should tell your developer to configure your site's automatic backup system to create an sql file every time it creates a backup

The blind leading the blind, truly

If anything he should fire the (((developer))) and learn to RTFM instead

 

[cosmic veteran]

The blind leading the blind, truly
View attachment 51999
If anything he should fire the (((developer))) and learn to RTFM instead

do you know how sql backup works? no, I really like to see you try explaining it to me

 

[polonium]

do you know how sql backup works? no, I really like to see you try explaining it to me

SELECT GROUP_CONCAT('DROP TABLE IF EXISTS ', table_name, ';')
FROM information_schema.tables
WHERE table_schema = 'onion farms database here';

 

[cosmic veteran]

SELECT GROUP_CONCAT('DROP TABLE IF EXISTS ', table_name, ';')
FROM information_schema.tables
WHERE table_schema = 'onion farms database here;

oh, my bad, I only deal with local sql database, not online. I don't know if this will work but I think you can create a custom function that will allow you to automatically create an sql backup file. I know this because I have created an sql backup file in the past

 

[Time 4 Guillotines]

do you know how sql backup works? no, I really like to see you try explaining it to me

Yes and now I'm qualified to be a mouthy fag to my elders as well

 

[polonium]

oh, my bad, I only deal with local sql database, not online. I don't know if this will work but I think you can create a custom function that will allow you to automatically create an sql backup file. I know this because I have created an sql backup file in the past

Yes you can write an SQL query that will reconstruct the database schema and populate it with data and most RDBMSs will auto-generate it for you. You could even just run that query on a different but compatible RDBMS to migrate from one place to another