READ_ME

All the content of this domain and the content formerly at jim.com and the associated blog is copyright ushwx@protonmail.ch Gpg fingerprint: 0D6ABF58AA31AF9594E70E4673E4BC62E92B87D7 and is licensed under Creative Commons License
the Creative Commons Attribution 4.0 International License,

To copy this website and the associated blog, download this file into the target directory of the target website and

tar -xvf backup.tar .

The blog will be in the blog subdirectory.

In the blog subdirectory you will find an sql file blogdb.sql.zip which is a zipped up *.sql file in the format that phpMyAdmin likes, that will create the database tables for the blog.

The database should have been purged of IP addresses.

Except that users and blog address in the database will not have you as admin, nor the correct domain.

And your config.php file probably has the database table and the wrong table prefix. Edit the table-prefix in config.php to wp_

So expand the zip file, edit the sql files and zip it up again

Edit the admin_email and new_admin_email record in the wp_options table to your email.

Edit the siteurl to the new domain name.

Edit wp_users table so that it has a user with an email that you can receive, so that when you click on "I forgot my password’, you can login as blog admin.

And/or you can copy some entries from the users and usermetadata tables from another blog to the database of the copy of the blog, so that you can login with a password you already possess. Once you manage to login, go to Settings/General and reset the values there.

To change the password from sql, which UI is likely broken if password is broken, edit the wp_users table of the database.

UPDATE `wp_users` SET `user_pass` = MD5('NEWPASSWORD') WHERE `wp_users`.`user_login`  "NEWUSERNAME";