Transition Town Totnes migration

[chris]

It has been agreed to migrate Transition Town Totnes, ​http://transitiontowntotnes.org/ to wiki:ParrotServer and this ticket has been created to record this process and the time spent on it and the documentation of the migration.

There is also an issue regarding what, if anything, to do with the old Drupal site at ​http://archive.transitiontowntotnes.org/

[chris]

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]

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

[chris]

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.

[chris]

Regarding the comment above about the size, that we 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:

• ​http://transitiontowntotnes.org/
• ​http://www.transitiontowntotnes.org/
• ​http://transitiontowntotnes.org.uk/
• ​http://www.transitiontowntotnes.org.uk/
• ​http://transitiontowntotnes.co.uk/
• ​http://www.transitiontowntotnes.co.uk/

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]

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]

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

[chris]

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]

archiving issue moved to #630