MU Soapbox

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Muxify
    • Mustard

    What a refreshing feeling

    MU Code
    5
    8
    2045
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Chime
      Chime last edited by

      mysql> drop database thereach;
      

      Yes. It is done.

      I have archives of the wiki, the forum, the game, etc etc etc. Not sure there is interest but the archives exist and some of them can be safely posted (e.g. via bittorrent or the like).

      As it stands, the forum content is only in the mysql dump and I don't imagine that is easy to extract in a useful form that doesn't have significant privacy violations. The complete wikistate from sql is present, but I will likely instead offer the mediawiki content xml export and a separate tar of the images. The content xml was somewhere around 4G of data but compressed to around 100M. The images with thumbnails mostly removed, etc., come out to about 4.5G. Final sqldump is about 1G. Game internal DB state, maildb and comsys have been archived via my git archive backuper thing, so I have detailed version history over time. No, not handing that out. Complete git archive (bare) for that is about 2.2G.

      Realistically, any future flatfile of the reach game db would need to have users removed and quite likely a great deal more. I'm going to punt and for now say that the people that need that data should already have that data and go yell at fallcoast if you'd like more than that.

      Q&A:

      • But I was still using that!
        Okay. Go play somewhere else, now. The Reach was closed ages ago.

      • But the wiki!!
        Realistically it spent most of its time locked because of the AbsenteeLandlord plugin that locks a wiki if no admins login. In any case, I have a relatively pre-sanitized mediawiki xml export and separate image tar that may suit your needs. Ask and I'll put that together.

      • But the ICONS omg
        Yes, okay. I can see why lots of games would want access to the icons and didn't manage to copy them off before whatever. See this archive

      It is by will alone I set my mind in motion. It is by the juice of Coffea arabica that thoughts acquire speed, the table acquires stains, the stains become a warning. It is by will alone I set my mind in motion.

      1 Reply Last reply Reply Quote 4
      • S
        Sonder last edited by

        Thank you for all that you do, Chime!

        1 Reply Last reply Reply Quote 1
        • S
          Sammi last edited by

          What's the proper form of alcohol to pour out to commemorate the death of a MySQL database?

          Derp Chime 2 Replies Last reply Reply Quote 1
          • Derp
            Derp Admin @Sammi last edited by

            @Sammi

            Mad Dog.

            Racism isn't Tinkerbell. It doesn't need you to believe in it for it to exist.

            1 Reply Last reply Reply Quote 1
            • Chime
              Chime @Sammi last edited by

              @Sammi --

              It was more than that, but the drop database bit looked cooler. No one really wants to see all of the

              cd /var/www/thereach/docroot/w/maintenance
              php dumpsomethingorotherIforgettherestbutyermumetcetc |xz -9 >~/reach.xml.xz
              cd ..
              rm -rf images/
              tar xJvf ~/images.tar.xz images
              cd
              rm -rf /var/www/thereach
              cp /home/mush/thereach/game/backups/somethingorother ~
              cp -r /home/mush/thereach/git ~/reachgit
              rm -rf /home/mush/thereach
              groupdel thereach
              userdel -r thereach
              a2dissite thereach
              a2dissite thereach-ssl
              service apache2 restart
              rm /var/spool/cron/crontabs/thereach
              

              and so on, and on. The guts are always ugly. Not sure appropriate alcohol/music to give it a sendoff. Leaning toward the Sound of Silence and a double of scotch.

              It is by will alone I set my mind in motion. It is by the juice of Coffea arabica that thoughts acquire speed, the table acquires stains, the stains become a warning. It is by will alone I set my mind in motion.

              1 Reply Last reply Reply Quote 1
              • S
                Sammi last edited by

                @Chime
                Oh baby, talk bash to me.

                1 Reply Last reply Reply Quote 2
                • Thenomain
                  Thenomain last edited by

                  I'm listening to the Shadowrun Returns soundtrack and plotting the future. I think the best we can do is remember who we were then and who we are now and that the more drama we cut out of our games the more fun they are.

                  “If you wish to make an apple pie from scratch, you must first invent the universe.”
                  ― Carl Sagan, Cosmos

                  1 Reply Last reply Reply Quote 6
                  • S
                    Sammi last edited by

                    And how many hours I spent going through the nWoD books to make sure that the Merits and powers pages were absolutely perfect.

                    1 Reply Last reply Reply Quote 0
                    • 1 / 1
                    • First post
                      Last post