![]() Now, can I solve this PHP mystery in 25 minutes before I have to go out? *Cue Mission:Impossible theme*- Martin Costello February 9, 2015Ĭomputers: the source of my income and maybe also a killing spree in the imminent future.- Martin Costello FebruMission: FailedĪs you can see, I gave up. On reflection, staying up until 3am messing about with PHP wasn't the best idea.- Martin Costello February 9, 2015 PHP confuses me.- Martin Costello February 8, 2015 I'll let this selection of tweets show you some highlights of the journey: I'll get all the code checked in and branch and get to work then.Ĭue montage of trying to get it to work to the theme of Murder She Wrote. I'm only one person, so great, sounds like the perfect fit. ![]() GitHub don't allow private repositories for free but Visual Studio Online is always private, supports Git and is free for up to 5 users. There's some private configuration data for the site to run in Azure though (like connection strings) so I don't want it publicly available. Azure has a nice deploy from Git workflow so I'll go with a Git repo to look after it. That way I can rollback if I mess everything up, plus I can setup a test slot somewhere where I can do testing without worrying about screwing up my "production" MySQL database. Great I've got the source, now what do I do? Well I better put it in source control somewhere before I start tinkering. I just had to FTP into the IIS website's directory in Azure and pull it out. Better get it then, which is pretty simple. Step one: where the hell is the website source?Īs everything had been set up for me in the Azure wizard, I'd never actually seen the website source itself ever. There's PHP drivers for SQL Server now and a WordPress plugin for using SQL Server as well? Microsoft have even blogged about how to do it, so it can't be that hard, right? Wrong as I was about to discover. Microsoft have been pushing for SQL Server interoperability with PHP (which WordPress is written in) for a while so I thought why not migrate to use SQL Server as the data store instead? That way I can host a SQL database (which I know how to do) in Azure in the right subscription and point WordPress at that instead. The next hurdle was that I'm not really au-fait with MySQL management given I'm a Microsoft/Windows guy, and if I'm honest I wasn't particularly inclined to learn to do so either. 20MB seemed a bit pathetic considering with one post I'd already used 15MB, and I already wanted to move the database to a different subscription so why remove the limit and start paying more? So how do you move a MySQL database from one subscription to another? I don't know, I never found out - more on this later. It was then that I discovered that the database was on a free tier with a paltry 20MB maximum size. ![]() I had no idea where this was, but eventually through some clicking of buried-away links in the Azure portal I found a link through to the third-party portal for the database. So the first problem was that the MySQL database that Azure automatically provisioned for me when the WordPress blog was initially provisioned is through a third-party provider. By this point I'd grown two different Azure subscriptions and the blog was running in the wrong one and I was starting to hit limits on my free Azure credits due to other usage, so I figured I'd switch it around. However I've got an idea for a second blog post that I've been procrastinating over writing for a while, so I thought I'd start on that (aside: this isn't that blog post, that's coming soon). Yeah, so I'd been a bit slack on the whole writing a blog thing. Great - time to get blogging!įlash-foward a few years, and I had a sum total of one solitary blog post. A few clicks through a wizard later and I had a WordPress blog running in Azure, backed by a MySQL database. As I'm mostly a developer in the Microsoft stack, I decided I'd set it up in Windows Azure as an Azure Website (now a "Microsoft Azure Web App") as that was something I knew of and knew a little about. Initially I created a blog in Blogspot but I decided some time later that I'd rather host it myself with custom DNS, etc., mainly as a learning exercise. A few years ago I thought I'd set up a blog. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |