All the content of this domain and the associated blog is copyright Creative Commons License gpg key 154588427F2709CD9D7146B01C99BB982002C39F

And licensed under the Creative Commons Attribution 4.0 International License

To copy this website download this file and this other file into the target directories of the target website and target blog.

tar -xvf
tar -xvf

After you have untarred in the blog directory you will find an sql file wordpress.sql that will create the database tables for the blog.

The database has been purged of IP addresses. Email addresses have been hashed with a 128 bit secret. The Avatar Privacy salt has been replaced with a 128 bit random value that is different in every backup. You should replace it with your own secret salt if you want Avatar Privacy to actually provide privacy.

Instructions for installing a blog on a lemp server, and for moving a blog that is too big for the built in Wordpress backup and restore process

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 wrong 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, for the UI to change the password is likely broken if the 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»";