URL Aliasis Serious Problem
I have currently got a HUGE problem
My Drupal site has been using the pathauto module for some time. It works well and allows new content published by my users to be given an appropriate name.
This morning however, after installing the 'nofollowlist' module and the 'retease' module (in order to re-save all my content to effect the changes of the 'nofollowlist' module.. I ran the retease module without considering the effect that this would have on the pathauto module.
Now ALL of my URLs have been changed, this is terrible news because obviously now all of my pages indexed by the search engines have moved location. I am currently considering how to get my urls back to their original names as soon as possible. I am aware that I could do this manually by looking at the pages which google has indexed, finding them on my site and renaming the url according... But this will take AGES.
Is there a quicker way. I created a backup of my drupal database just yesterday, but I dont know how to revert to this backup. (I would if I could). Is there a section of this backup that contains the URL aliasis that I could upload? I really am nervous about touching the database.
Has anyone any ideas that could help me out of this bad situation or is my best option to manually rename all my URLS? 500+
Thanks
Reverting the database is to
Reverting the database is to delete the exsisting database and Installing your old one. All the changes done since the backup will be gone . Make sure you delete all conflicting module before you restore database.
What type of backup you have and does your hosting have a controlpanel?
Alternatively you can delete the table url_alias in the database and install the table from your back up.
Whichever option you are going for , I suggest you do it fast before search engines index your site again with new urls.
Onesimpleman
Hello. Yes my hosting has a
Hello.
Yes my hosting has a control panel. I also have access to PHPmyadmin
I would very much like to go for the option of just uploading the backup copy of the table url_alias.
The backup I have is, a .sql file.
How would I go about finding the url_alias table in it and then uploading it?
Would there be any negative effects?
Thanks
Very much look forward to your response.
Bulk generate aliases
Pathauto has a feature that lets you regenerate aliases. Check out Starting Over - Clearing your Aliases Completely Or Selectively in the pathauto documentation. Could be an alternative to restoring your database.
Thanks. Unfortunately
Thanks. Unfortunately however if I regenerate the URLS on bulk their names will not all match what the search engines have indexed. I gave many of the urls names manually..
Thank you for your input.
Easiest thing to do will be
Easiest thing to do will be to log into phpmyadmin, find the database .. back it up and then check all tables and drop them.
Now click import tab and find the backup you have and install it.
You will have to manually do the changes since the last backup.
I Did this and it
I Did this and it worked.
Thank you very much. Thank goodness for the backup! :)