wordpress

Wordpress runs it's cron job automatically approximately every 10 minutes. Sometimes it is blocked by .htaccess or other server configuration. To avoid issues, it might be a good idea to run from the server crontab itself.

References:

https://kinsta.com/knowledgebase/disable-wp-cron/

https://wpbeaches.com/set-up-wordpress-wp-cron-php-to-run-manually/

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!