[support] Bulk update of page titles & URL Alias?

[Warren Keuffel]

That will work nicely. After I posted my last response it occurred to me that there might be a way to do this in drush as well. But this is good.

Thanks, people. I appreciate all your suggestions.

-WK


On Jan 24, 2012, at 10:58 PM, Daniel Germer wrote:

> I suggest that you do this not via phpMyAdmin but with a simple SQL
> query, via ssh.
> alternatively you can also do in in phpMyAdmin.
> I would prepare a query that does it in one run
> If you are afraid of fumbly fingers or not: first backing up your
> database is always the way to go!
> 
> The fields to change are
> 
> node.title WHERE node.nid = '##'
> url_alias.alias WHERE source="node/"'node.nid'
> 
> 
> (UPDATE node , url_alias SET ...
> 
> You can create a list of your node-ID, url_alias, node-TITLE in a
> texteditor like vim,
> and then replace each line with regex to the needed SQL code.
> 
> run this for testing purposes on some test-nodes and then apply it to
> the full list.
> 
> the advantage is that you don'T have to install a module with
> side-effects and additional server load and you can easily record and
> repeat the steps
> -- 
> [ Drupal support list | http://lists.drupal.org/ ]