Update aliases - /handbook to /documentation

We probably don't want to do this manually - there's 172 of them.

We can update the aliases like:

update url_alias set dst = replace(dst, 'handbook/', 'documentation/')where dst like 'handbook%';

I'm happy to run that. Tricker is how to create the redirects. We could either use path_redirect or a single redirect in the apache configuration (i.e. htaccess).

If someone wants to figure out the query to create these as redirects in the path_redirect table I'll be happy to qa/run the queries.

OR if someone wants to document the .htaccess change (and killes/nnewton/whomever are OK with an .htaccess redirect) I could review (but not implement) that.

It looks correct, although it's going to be pretty big so it may want to be tested first.

redirect field should be 'node/[nid]'

INSERT INTO `path_redirect` (`source`, `redirect`, `query`, `fragment`, `type`) SELECT ua.dst, replace(ua.dst, 'handbook/', 'documentation/'), '', '', 301 FROM `url_alias` ua WHERE ua.dst LIKE 'handbook/%';

I think we want the "redirect" field to be in the form of "node/NID" so I'm using ua.src instead of the replace business.

INSERT INTO `path_redirect` (`source`, `redirect`, `query`, `fragment`, `type`) SELECT ua.dst, ua.src, '', '', 301 FROM `url_alias` ua WHERE ua.dst LIKE 'handbook/%';

OK, I think this is ready to go but would like to at least give it enough time for folks in Europe to review.

I tested out the queries by limiting them to "handbook/blocks" instead of the % and they worked find for http://drupal.org/documentation/blocks

So, I plan to run these two queries on Monday:

INSERT INTO `path_redirect` (`source`, `redirect`, `query`, `fragment`, `type`) SELECT ua.dst, ua.src, '', '', 301 FROM `url_alias` ua WHERE ua.dst LIKE 'handbook/%';
UPDATE url_alias SET dst = replace(dst, 'handbook/', 'documentation/') WHERE dst LIKE 'handbook/%';

Edited to fix second query per jhodgdon so a copy and paste doesn't fail

Now done. It fixed 170 rows.