Differences

This shows you the differences between two versions of the page.

--- 301-redirect-update-mysql [2025/05/07 21:53] – guidebeacon
+++ 301-redirect-update-mysql [2025/05/07 21:58] (current) – guidebeacon
@@ Line 1: / Line 1: @@
 Redirect and update MySQL database
+go to Website Owners Manual for a more detailed information with screen shots,
+This example is when the website page location was changed 1st in Access then the following has to be changed in MySQL database manually.
+Original Path Location:  https://www.beacontechnology.com/dock-equipment/loading-dock-safety/forklift-bridge
+New Path Location: https://www.beacontechnology.com/industrial-ramps/forklift-bridge/
+Screenshots are from SQLyog community edition.  Similar changes could be made from phpMyAdmin in cPanel.
+On 5/7/2025 4:22 PM, Scott Brinker wrote:
+To move a product to new URL and create 301 redirect:
+url_cats table in mysql database must be updated to match new path
+After:
+New entries must be made in mysql db to handle 301 redirects.
+intercept_404 table:
+Run this link in admin:
+Run after Access upload (connects drilldown to product page - MySQL database) (also runs the below)