Updating PR values of 1066 URLs in 30 minutes
This article is written more for myself so I remember how I do it the next time but probably a few people will also benefit from this for different uses and purposes.
Today I updated all the PR values for the directories listed on my directory list. I had to update each listing in the MySQL database but I found a fast way to do it. The previous time was a pain in the ***.
1. Log into PHPMyAdmin and get the URLs:
2. Export the query into a text file.
3. Clean the text file so that you only have the URLs. (I use EditPlus 2 for this to replace all. It costs $30)
And:
4. Use the PageRank Lookup Tool from SEO Chat and look up 100 URLs at a time and paste the findings in Excel (or OpenOffice Calc which is free).
5. Edit the excel sheet and place the columns of the PR values before the URLs.
6. Paste everything in a new EditPlus document and do specific replace all queries so that you get valid SQL code. (correct the first and last line).
And:
And:
7. Go back to PHPMyAdmin, paste and run the SQL code.
Done!
8. Export the whole database to keep as a new backup.
Jim Westergren is a company owner from Sweden who lives together with his wife and son. Some of his interests are SEO, web development, writing and
Why not just use the PR lookup script thats freely available? It queries google using php and can then write back to the DB.
I agree with mad4. What you are trying to do is easy to automate using a PHP script. The bits of code are already available around the web.
Pierre
I do something similar to this but I generally use excel to both get the basic urls and generate the mysql inserts.. You can use concatenate for the latter and some basic if then statements to get down to the basic urls. Of course I gotta wonder (since its already in a mysql db) why you didn’t just create the code for looking up the pr in php then have that access your mysql database and run through it.. This way you don’t have to take 30 minutes every time.. just access your pagerank updater page and it updates your list.
Ok ok, a PHP script is much better. But my knowledge with PHP is very limited. Any of you guys who knows where I can get such a script that also is easy to install?
Hi Jim,
I have one and you’re more than welcome to have it. These PR scripts only work on some servers, this one only works on one of my 6 servers and I have no idea why. I can usually update about 3k dirs in a few mins
You will need to customise it for your dir but it wouldn’t be too hard.
Email me if you want the script
Jim,
there is a PR update Mod for PHPLD which also works perfectly fine. (assumption that all the dir’s run PHPLD)
here it is
http://www.directoryspy.com/downloads/page-rank-update-tool-for-phpld/
Thanks a lot Dir critic but I am happy with this solution. 30 min every quarter is not that much.
Thanks Praveen. This was not for a directory but for a list but I will use that mod when I need it for one of my dirs, thanks.
Hope several tools available in online. Mr.Jim knows very well of it. seocompany.ca have such tools information.
Regards
Ms.Anitha
Jim, just wanted to say thanks for always posting screenshots and the code where applicable. One of the many reasons I’ve bookmarked your site.
Thank-you it worked great for me.
http://www.ftavip.com
thanxs again jim for the work. more then that thanxs for compiling the list of high pr directories. hope u updatse them as soon as next update is done .
Interesting stuff, though nowadays Google seems to have less of an interest in updating PRs.
Thats great..will try that.