Skip to content
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (Slate)
  • No Skin
Collapse
Brand Logo

DT125R FORUM

  1. Home
  2. Forum Related Issues
  3. Forum Database Migration & General Upgrades

Forum Database Migration & General Upgrades

Scheduled Pinned Locked Moved Forum Related Issues
6 Posts 4 Posters 734 Views
  • 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.
  • CalumC Offline
    CalumC Offline
    Calum
    wrote on last edited by
    #1

    Hello,

    Due to the recent instability issues we were having over the last few months, it's been decided that we will migrate the database from one system to another.

    I plan on making some changes to the server over the next few months, and migrating the database will be the first of many changes. The new database may impact on performance, but it's a necessary upgrade to improve the stability.

    To compensate for this fact, I've just ordered a new faster system to host the server on, as well as a new HDD to store the data to.

    @Arite Has created the necessary scripts to back the data up. He also has the complete works of the old forum saved locally which he's going to give me.

    The plan will be to create a new READ ONLY forum at archive.dt125.co.uk which will house all of the old Forum on the same server as the new one. Meaning we should be able to make direct links from this site to that site.

    I also plan to move the forum from dt125r.co.uk/ to dt125r.co.uk/forum

    This is accommodate the new features that will be found at dt125r.co.uk/home

    This is going to be a massive migration as all links currently pointing at the original location will have to move. As well as any Google index's will have to be recached, meaning we will most likely revert back down on the Search engine lists.

    My plan today will be to stop the forum for a few hours whilst I migrate the database.

    When the new server arrives, I will work to get that working over Christmas, with a plan to have a new site in the new year.

    Expect a server outage for a few hours today whilst the migration occurs. There is a lot to migrate and I can't be having any new content being written whilst the migration is in process. So the forum will be offline.

    If all goes well, this should be back up and running on the new database by tomorrow.

    Kind Regards,

    Calum

    Always Originate, Never Pirate!

    1 Reply Last reply
    2
    • CalumC Offline
      CalumC Offline
      Calum
      wrote on last edited by
      #2

      Okay, well that didn't work. After wasting 5 hrs and migrating over half a million keys, it crashed.

      So will have to try again another time.

      Nevermind!

      Always Originate, Never Pirate!

      1 Reply Last reply
      1
      • O Offline
        O Offline
        oldman
        wrote on last edited by
        #3

        Thanks Calum, appreciate the effort

        CalumC 1 Reply Last reply
        0
        • O oldman

          Thanks Calum, appreciate the effort

          CalumC Offline
          CalumC Offline
          Calum
          wrote on last edited by
          #4

          @oldman Yeah didn't work lol. Waste of my Saturday and my computer was hammered at like 600% CPU all day 😞

          Always Originate, Never Pirate!

          declanD 1 Reply Last reply
          0
          • CalumC Calum

            @oldman Yeah didn't work lol. Waste of my Saturday and my computer was hammered at like 600% CPU all day 😞

            declanD Offline
            declanD Offline
            declan
            wrote on last edited by
            #5

            @Calum I wish I could understand any of that lol

            NINJAN 1 Reply Last reply
            0
            • declanD declan

              @Calum I wish I could understand any of that lol

              NINJAN Offline
              NINJAN Offline
              NINJA
              wrote on last edited by
              #6

              @declan Welcome to the club dude!!! 😉

              SEDUCED BY THE DARK SIDE!!!

              1 Reply Last reply
              1
              Reply
              • Reply as topic
              Log in to reply
              • Oldest to Newest
              • Newest to Oldest
              • Most Votes


              • Login

              • Don't have an account? Register

              • Login or register to search.
              • First post
                Last post
              0
              • Recent
              • Tags
              • Popular
              • Users
              • Groups