Ticket #550 (closed maintenance: fixed)

Opened 4 years ago

Last modified 3 years ago

Transition Town Totnes migration

Reported by: chris Owned by: chris
Priority: major Milestone: Maintenance
Component: Parrot server Keywords:
Cc: ed Estimated Number of Hours: 1.0
Add Hours to Ticket: 0 Billable?: yes
Total Hours: 1.55

Description

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/

Change History

comment:1 Changed 4 years ago by chris

  • Add Hours to Ticket changed from 0.0 to 0.8
  • Total Hours 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

comment:2 Changed 4 years ago by ed

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

comment:3 Changed 3 years ago by chris

  • Add Hours to Ticket changed from 0.0 to 0.5
  • Total Hours 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.

comment:4 Changed 3 years ago by chris

  • Add Hours to Ticket changed from 0.0 to 0.25
  • Total Hours 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.
Last edited 3 years ago by chris (previous) (diff)

comment:5 Changed 3 years ago by chris

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

Issues still outstanding:

comment:6 follow-up: ↓ 7 Changed 3 years ago by ed

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

comment:7 in reply to: ↑ 6 Changed 3 years ago by 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?

comment:8 Changed 3 years ago by ed

archiving issue moved to #630

comment:9 Changed 3 years ago by chris

  • Status changed from new to closed
  • Resolution set to fixed
Note: See TracTickets for help on using tickets.