Content in WordPress is inside the WordPress database. If you have deleted the WP database, then the content is gone. Installing a new WP instance will create a new, mostly blank database. So, unless you have a backup copy of your database to restore, your content is gone. Your hosting place may have made a … Read more
Error establishing database connection Can Only mean one thing and that is an Error establishing database connection, check your wp-config.php again and see that the database settings is correct and also make sure that your database user as permission on the database server.
Store partial database to an archive database time to time
Restose content from revisions – sql query
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
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
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
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
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.
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