DT125R FORUM
    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Popular
    • Users
    • Groups

    Forum Database Migration & General Upgrades

    Forum Related Issues
    4
    6
    284
    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.
    • Calum
      Calum last edited by

      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 Reply Quote 2
      • Calum
        Calum last edited by

        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 Reply Quote 1
        • O
          oldman last edited by

          Thanks Calum, appreciate the effort

          Calum 1 Reply Last reply Reply Quote 0
          • Calum
            Calum @oldman last edited by

            @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!

            declan 1 Reply Last reply Reply Quote 0
            • declan
              declan @Calum last edited by

              @Calum I wish I could understand any of that lol

              NINJA 1 Reply Last reply Reply Quote 0
              • NINJA
                NINJA @declan last edited by

                @declan Welcome to the club dude!!! 😉

                SEDUCED BY THE DARK SIDE!!!

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