Now a problem, we will get this warning.įollowed by error messages like this, which results in no data export at all. Select your WordPress database, Dump Structure and Data, choose all objects for good measure and ‘Start Export’ – we will get a problem, which we will resolve. Now we simply have to export our structure and data using the ‘Data Export’ (which uses mysqldump) function in MySQL Workbench in the administration \ Management options. We are going to backup our database and files from Azure as the source using Workbench 8.0 for database and the Azure online browser GUI for files.Ĭonnect to your database using MySQL Workbench, the details can be retrieved from Azure.
You can download MySQL Community Server and WorkBench from this link. We are going to need MySQL Workbench 6.3 (ish) and MySQL Workbench 8.0, you will see why. Server 2 was installed with Windows Server 2016, IIS, Web Platform Installer and MySQL version 8.0 Server 1 was installed with Windows Server 2012 R2, IIS, Web Platform Installer and MySQL version 5.1.73
MYSQLDUMP DATABASE WORKBENCH INSTALL
We created 2 pre-installed virtual servers on which to test this process, 1 would be a lower version of MySQL ( 5.1.73) than is running in Azure (version 5.7) and 1 would be a higher version of MySQL (8.0) both would be installed with vanilla WordPress install at the same WordPress version as our live environment and with the same plugins already installed (at the end we will test with a non-matching WordPress version and with no plugins installed to restore into). With the goal of being able to fully move between Azure and our own server infrastructure, so this is where MySQL Workbench (mysqldump) and a few other tools and scripts come into play.
MYSQLDUMP DATABASE WORKBENCH FULL
So there are many plugins that cover WordPress backup and restore but we won’t go into these in this article, we wanted a plugin free way and something where we felt we had full control and something we could automate. At the time of writing this article we host in Azure but at anytime we may want to change host or even host the site on our own server infrastructure in a data centre and also protect ourselves from bad actors by having routine and automated backups. So what a great early article to tell you how we go about backing up and restoring this site. So as we set out on this journey to create a great blog we realised we needed increase our WordPress IQ, from hosting to backups to plugins you name it.
0 kommentar(er)
