WordPress Permalink Manager Plugin: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 94: | Line 94: | ||
</syntaxhighlight><br /> | </syntaxhighlight><br /> | ||
* Bulk edit date of Media Files to update with this date: 1999-09-13 | *Bulk edit date of Media Files to update with this date: 1999-09-13 | ||
* phpMyAdmin: Query Database, Export (at bottom of query, not on Tab) to CSV | *phpMyAdmin: Query Database, Export (at bottom of query, not on Tab) to CSV | ||
SELECT ID FROM wp_posts WHERE post_date='1999-09-13*'; | SELECT ID FROM wp_posts WHERE post_date='1999-09-13*'; | ||
* Textpad: Remove " characters using ALT & Mouse OR Replace with nothing, Replace, Regular expression Checkbox, Find: \r (carriage return), Replace: , | *Textpad: Remove " characters using ALT & Mouse OR Replace with nothing, Replace, Regular expression Checkbox, Find: \r (carriage return), Replace: , | ||
* Clear Temporary Table | *Clear Temporary Table; | ||
* Save original SLUG Names; | |||
TRUNCATE TABLE LifeOfTheSaltonSea_org_WP.TT2; | |||
*Save original SLUG Names in Temporary Table; | |||
INSERT INTO LifeOfTheSaltonSea_org_WP.TT2 (ID, post_name) | INSERT INTO LifeOfTheSaltonSea_org_WP.TT2 (ID, post_name) | ||
| Line 111: | Line 114: | ||
WHERE post_date LIKE '1999-09-13%'; | WHERE post_date LIKE '1999-09-13%'; | ||
* Modify the SLUG (post_name) | *Modify the SLUG (post_name) | ||
UPDATE LifeOfTheSaltonSea_org_WP.wp_posts | UPDATE LifeOfTheSaltonSea_org_WP.wp_posts | ||
| Line 118: | Line 121: | ||
WHERE post_date LIKE '1999-09-13%'; | WHERE post_date LIKE '1999-09-13%'; | ||
* Use Permalink Manager (Permalink Manager, Tools, Regenerate / Reset, Mode); | |||
Mode: Use Original (Default) URLs as custom permalinks | |||
Select content type: N/A | |||
Select post types: Media | |||
Select post statuses: Published | |||
Select IDs: Use CSVs obtained | |||
Regenerate Button | |||
* Put original values from the Temporary Table back into the Permanent Table | |||
USE LifeOfTheSaltonSea_org_WP | |||
UPDATE wp_posts | |||
INNER JOIN TT2 ON (wp_posts.ID = TT2.ID) | |||
SET wp_posts.post_name = TT2.post_name; | |||
<br /> | <br /> | ||