The tutorial also includes instructions on how to enable remote access from cPanel.Ĭaveat: Due to PCI compliance requirements, you might need to use a different IP address for remote access. There are screenshots in the tutorial as well, so check it out! Basically, open up your wp-config.php file and get the details. To connect to the database remotely, we need to follow the same initial steps as outlined in my earlier tutorial. Step 1: Getting the Database Details and Enabling Remote Access The full path to where you want the backup to be stored.To schedule a remote backup, we need the following pieces of information first: This means minimizing cron jobs and reducing the number of plugins.įor these reasons, I prefer to schedule backups remotely and have them downloaded onto my local desktop. In addition, you want to reduce the load on your WordPress installation as much as possible. If your local server crashes, you lose all your backups. First, a plugin will perform a backup and either store it on the local server or send it to a 3rd party online storage. So in this tutorial, I’ll show you how to schedule a backup of your database and download it onto your computer. There’s no command line interface that we can use to schedule a task. It needs a user to manually select the backup option.
Just open your database in HeidiSQL, right-click the database you want and export as SQL. Now if you need to take a backup, it’s extremely easy. In a previous article, I’d shown you how to connect to your MySQL WordPress database remotely through the HeidiSQL program.
0 kommentar(er)
