Rename wordpress database prefix (https://iandunn.name/2016/07/21/rename-wordpress-database-prefix-with-w…)
Change site URL:
wp search-replace 'example.dev' 'example.com' --skip-columns=guid
Or, if you only want to change the option, you can do:
wp option update home 'http://example.com'
wp option update siteurl 'http://example.com'
Updating admin user e-mail, when you only have MySQL command line access: UPDATE `wp_users` SET `user_email` = 'INSERT_MAIL' WHERE `ID` = '1';
generate wordpress password for insertion in database: echo -n "password" | md5sum
If you are unable to post in Wordpress, you might want to add this to your wp-config.php: define( ‘WP_MEMORY_LIMIT’, ‘256M’ );
Also install classic editor and disable Wordfence completely (look in .htacces) and remove or rename .user.ini
There are many backup solutions out there for wordpress sites.
For example these plugins:
UpdraftPlus can be connected with dropbox.
Jetpack
backWPup
Among others.
You might also want to build your own backup routine with cronjobs on the hosting server.
Remember to backup!
