Backing up and updating WordPress on Windows with IIS

Backup. Update. Done! Not so easy as you might expect.

Shortly after I got everything up and running it is time for some updates. Of course, before I do any updates I want to back up everything so if something goes wrong, I can revert to my current situation which is working beautifully.

WordPress: I back up the site folder with the WP files and this will include also any images or media I uploaded to my own website. Just zip the folder and save it with a date somewhere.

MySQL: I can’t see a backup option, but there is a data export option, with the option to export to one self-containing file. Sounds like a backup to me, and this is also what I did moving things over from my development server to my new production server.

Unfortunately, the data export gives me a warning: “mysqldump.exe is version 5.7.17, but the MySQL Server to be dumped has version 8.0.11. Because the version of mysqldump is older than the server, some features may not be backed up properly.” This does sound a bit worrying, and so does the huge gap of versions, looks like many years to me.

Looking for this I find the developers site of MySQL, and there is an option to download MySQL utilities… Wasn’t this included when I ran the new installer just a few days ago? Not much choice, so downloading the utilities 1.6.5 version.

Great, it installed some command line tool, not what I expected. Plus it didn’t have what I needed in it. Back to Google.

Google was better to me this time, got me to the right track. Both the MySQL server AND the workbench come with the export tool, so it is in both “C:\Program Files\MySQL\MySQL Server 8.0\bin” and in “C:\Program Files\MySQL\MySQL Workbench 6.3 CE” The workbench obviously takes from its own directory, which needs to be changed to the path of the server installation in the preferences: Edit > Preferences -> Administrator -> Path to mysqldump Tool.

*Sigh*, next error: Workbench was unable to get mysqldump version. Please verify the log for more information. Google finding people reporting the problem, but no solutions. Where is that log file? The log file is here: C:\Users\[yourname]\AppData\Roaming\MySQL\Workbench\log\wb.log

Okay: Could not parse version number from C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqldump.exe

There seems to be a problem in the Python script, not returning a value or something, this doesn’t look very professional. Going to ignore this error for now.

 

Now, for updating WordPress on IIS, the default permission are not enough. So I give the user “IUSR” full control over my website directory and that does the trick. Got WordPress 4.9.5 now, and it promised me to install future updates automatically. Did I just give WP control of my server?

Leave a Reply

Your email address will not be published. Required fields are marked *