Store partial database to an archive database time to time
Store partial database to an archive database time to time
backup
Restose content from revisions – sql query
Restose content from revisions – sql query
Restore large number of permanently deleted posts
I never personally tried it, but maybe mysqldbcompare is worth a shot. Taken from this StackOverflow answer mysqldbcompare –server1=A –server2=B –changes-for=B –difftype=sql Should generate SQL statements that will make server B match server A. If you check the MySQL doc, you can run from same server by only specifying the –server1 option. I would test … Read more
Delete and perform a fresh install of WordPress
The wordpress importer / exporter should work for this task (maintaining post dates and comments), but it’s better to test it before deleting the online blog. My advice is to create first a fresh install in a folder (so you’ll can temporary reach your new installation at www.yoursite/folder/ ) and test if everything works fine … Read more
Backing up and restoring multiple sites efficiently
wp-cli can do all you need from the list. This is an elegant way to work with WordPress. Furthermore, you probably need some bash scripting to automate things even further. I would go with that. For instance. Backup the database and download the database backup; wp db export it will export the database to a … Read more
Recover wordpress by replace file manually
Depends on where the malware is. If the code is on pages generated by WP ‘core’ because core files are damaged, then a reinstall of WP to 4.7.2 is the starting point. Then I would reinstall all themes files, at least the active theme. You could manually install the active theme file in a new … Read more
WordPress Backend HA (Automatic failover)
You can achieve automatic failover using a synchronous service, like Galera cluster. It requires three nodes, but you can set up two nodes there, along with an arbitrator.
Uploading website to Host
I use Search-Replace-DB from interconnectit for years now and had always good results with replacing urls. In case you have Yoast SEO plugin installed you might have to deactivate it when you rewrite the urls, otherwise I never had trouble using that scripts up to now. https://github.com/interconnectit/Search-Replace-DB
Why does importing copies of the database dump and the document root make WordPress data inconsistent?
Why does importing copies of the database dump and the document root make WordPress data inconsistent?
Restoring backup of wordpress website on LAMP
Restoring backup of wordpress website on LAMP