Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

HOW TO: Bulk Add 301 Redirects to JoomSEF
(1 viewing) (1) Guest
Support forum for customers who have purchased JoomSEF 3 (Joomla 1.5 compatible). Archive only, no new post can be added.

NOTE: This category has been locked. If you have purchased paid version, please, use our Support Ticket system instead. If you are using free edition, please see the Community Support section.
  • Page:
  • 1

TOPIC: HOW TO: Bulk Add 301 Redirects to JoomSEF

HOW TO: Bulk Add 301 Redirects to JoomSEF 14 years, 6 months ago #8423

It would be nice if you could import 301 URLs in bulk but I could not find a way via the JoomSEF admin area.

I had tons of 301 redirects I needed to specify and entering them 1 by 1 via JoomSEF was too time consuming so I wanted to share how I accomplished this using a MySQL command.

I logged into PhpMyAdmin to access my Joomla database, clicked SQL and entered the following command:

 
INSERT INTO `jos_sefmoved` (old, new, lastHit) VALUES ('blog/designing-a-website', 'web-design/designing-a-website', '0000-00-00 00:00:00');
 
INSERT INTO `jos_sefmoved` (old, new, lastHit) VALUES ('general/designing-a-website', 'web-design/designing-a-website', '0000-00-00 00:00:00');
 
INSERT INTO `jos_sefmoved` (old, new, lastHit) VALUES ('blog/spam-traffic-increases', 'general/spam-traffic-increases', '0000-00-00 00:00:00');
 


I then clicked Go and above 3 entries were added as Rows within the table.
Last Edit: 14 years, 6 months ago by davetanguay.
The topic has been locked.
  • Page:
  • 1
User Login Empty