![]() ![]() You can either use WP-Cron (if your site gets enough traffic to reliably trigger it to run at the right time) or schedule a cron job. To get it to run on a scheduled interval (I want it to run just a couple minutes before my WordPress backup starts to run at 7am). Now this script should create a backup of the database "ecom_db_name" whenever it is run. to backup multiple databases, copy all of the above code for each DB, rename the variables to something unique, and set their values to whatever is appropriate for the different databases. Open up a text editor and create a file called backup_dropbox.php. Then I had to actually create the database backup. To store a backup of the e-commerce database, I created a folder in my site's root directory (/temp - call it whatever you want). ![]() Perhaps with a few tweaks to my answer, but still they should be able to accomplish the end result. Anyone who has a MySQL database and can run PHP should be able to benefit from this. The solution I came up with is not specific to WordPress or an e-commerce site.
0 Comments
Leave a Reply. |