Transition Technology: Ticket #550: Transition Town Totnes migration

hours, totalhours changed

chris — Sun, 19 May 2013 16:04:51 GMT

hours changed from 0.0 to 0.8
totalhours changed from 0.0 to 0.8

I've copied the site to wiki:ParrotServer:

http://ttt.parrot.webarch.net/

I've written a script to rsync the files and the copy and import the database so we can update the parrot version of the site easily from the live server (which depends on having root on both servers):

#!/bin/bash
# sync from host-a.ecodis.net
rsync -av --exclude="wp-config.php" host-a:/home/ttt/public_html/ /home/ttt/sites/default/
chown -R ttt:ttt /home/ttt/sites/default/
# dump the remote database and rsync it
ssh host-a /home/ttt/private/dump.sh
scp host-a:/home/ttt/private/ttt.sql.gz /home/ttt/private/
# import the remote database
cd /home/ttt/private/
gunzip ttt.sql.gz
cat ttt.sql | mysql ttt

It will probably take around 15 mins to run the next time around, the site has 744M of files and the database is 638M.

The status of the core code and the plugins:

wp core update
  Success: WordPress is at the latest version.
wp plugin status
 19 installed plugins:
  UI add-from-server
   I akismet
   I backupwordpress
   A delightful-downloads
   A duplicate-post
   A easy-wordpress-donations
   I file-gallery
   I hello
   A lightbox-gallery
   I lightbox-plus
   A page-list
   A popo-feature
   A pretty-file-lister
   A subpage-navigation
   A the-events-calendar
   A events-calendar-pro
   A twitter-facebook-google-plusone-share
   I wordpress-easy-paypal-payment-or-donation-accept-plugin
   I wp-smushit
 Legend: I = Inactive, A = Active, U = Update Available

The available update for Add to Server isn't a security update, see https://wordpress.org/extend/plugins/add-from-server/changelog/

I'll hold off installing wp-piwik until there is agreement for this, it appears that GA is hard coded at a template level rather than via a plugin. This is fine -- it would make sense to trial piwik before considering switching GA off.

I have created a page to document the site, wiki:TransitionTownTotnesWordPress

ed — Mon, 20 May 2013 08:46:22 GMT

I will secure approval from Frances for DNS changes - and keep GA on for this one.

hours, totalhours changed

chris — Thu, 25 Jul 2013 12:52:17 GMT

hours changed from 0.0 to 0.5
totalhours changed from 0.8 to 1.3

The script mentioned in ticket:550#comment:1 was found at /home/ttt/private/host-a.sh and it was run to update the copy of the site on wiki:ParrotServer.

This took longer than expected as the database is 798M.

The site at http://ttt.parrot.webarch.net/ has been updated and the DNS change has been made so we just need to wait for it to propagate.

hours, totalhours changed

chris — Thu, 25 Jul 2013 17:15:45 GMT

hours changed from 0.0 to 0.25
totalhours changed from 1.3 to 1.55

Regarding the comment above about the size, that was in relation to the database dump -- it was 798M. The files total 785M. The files are in /home and the database and it's backups are in / and this is the available space on wiki:ParrotServer:

df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/xvda2            9.9G  3.8G  5.7G  40% /
/dev/xvda3            8.9G  4.4G  4.1G  52% /home

So this isn't currently an issue.

Testing that the DNS has updated for all the domains:

dig transitiontowntotnes.org +short
81.95.52.43
dig www.transitiontowntotnes.org +short
81.95.52.43
dig transitiontowntotnes.org.uk +short
81.95.52.43
dig www.transitiontowntotnes.org.uk +short
81.95.52.43
dig transitiontowntotnes.co.uk +short
81.95.52.43
dig www.transitiontowntotnes.co.uk +short
81.95.52.43

And the web addresses:

That all seems fine.

Some info has been added to the wiki:TransitionTownTotnesWordPress page.

Still TODO:

Add Piwik tracking?
Check on the status of the code and plugins in terms of available updates.
Look at why the database is so huge.

chris — Fri, 15 Nov 2013 14:18:17 GMT

The site was updated to WordPress 3.6.1 on ticket:594.

Issues still outstanding:

Add Piwik tracking?
Look at why the database is so huge.
Agree what to do about the archived Drupal site, http://archive.transitiontowntotnes.org/

ed — Wed, 20 Nov 2013 15:27:46 GMT

Shall we skype about this? My answer to the archive is the same as ever - and theirs - bin it. No archiving.

chris — Wed, 20 Nov 2013 15:50:00 GMT

Replying to ed:

Shall we skype about this?

Sure, happy to talk.

My answer to the archive is the same as ever - and theirs - bin it. No archiving.

I very strongly disagree with this. I think it would be a huge mistake to delete all this history.

Did you see the fuss last week when the Tories deleted a decade of material from their website?

https://www.google.com/search?q=Conservative+party+deletes+archive+of+speeches+from+internet&tbm=nws

ed — Mon, 25 Nov 2013 14:17:40 GMT

archiving issue moved to #630

status changed; resolution set

chris — Wed, 02 Apr 2014 10:16:49 GMT

status changed from new to closed
resolution set to fixed