Migrating to a new server

  • jhepworth

    (@jhepworth)


    6 years ago

    Hi everyone,

    We have recently decided to migrate our content hosting to Amazon AWS from our previous servers. We have several hundred sermons which we have uploaded to AWS. We want to update the URL of each sermon to reflect the new URL on the AWS servers.

    We’ve tested this to work by manually editing the URLs of the existing sermons. Is there a mechanism to achieve this automatically rather than needing to manually update each sermon?

    Thanks!
    James

Viewing 4 replies - 1 through 4 (of 4 total)
  • Jack Rogers

    (@joeisuzu)

    New URL on the AWS server? Why should this require new URLs?

    Jack

    Thread Starter jhepworth

    (@jhepworth)

    Hi Jack,

    I may not have adequately clarified the problem:

    Currently our files are hosted with our ISP such that the URL attachement to the file is of the form:

    “https://churchonmain.org.za/wordpress2/wp-content/uploads/2018/10/sermon.mp3”

    We have uploaded all our sermons to an s3 bucket on AWS to store the files. We wish to preserve the accessibility of all our existing sermons and simply direct the plugin to fetch the attachment from the s3 bucket such that the URL above becomes:

    “https://s3.us-east-2.amazonaws.com/churchonmain-sermon-audio/2018/sermon.mp3”

    As we have many sermons that we would like to update, doing this as a bulk action would be ideal.

    I hope that clarifies the issue. Thanks for replying to the topic and trying to help.

    • This reply was modified 6 years ago by jhepworth.
    Jack Rogers

    (@joeisuzu)

    (Edited)
    So your WP site didn’t move, just the sermon files.

    I’d do it with an easy sql update query, after getting a database backup. Unfortunately, I’m replying from a phone and I don’t have shell access to help with the sql query.

    Jack

    Jack Rogers

    (@joeisuzu)

    I’m sorry, I just realized this is for Sermon Browser (not Sermon Manager). I no longer have a Sermon Browser installation, so I can’t offer an sql query. Perhaps someone else here can help.

    Jack

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Migrating to a new server’ is closed to new replies.