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
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/ ]
-
Daniel Germer -
Warren Keuffel