I’ve decided to post an images article rather than the usual programming stuff. Here is a great collection of Graffiti photos in the city which i gathered them from Flickr. Have fun!

Recently, I wanted to upload a 10GB SQL file to MySQL using PhpMyAdmin. unfortunately, it didn’t work properly. the fields were created in the database but with no records. It seemed to be a memory and PHP configuration issue. After that i made some searches. And eventually, figured out that there is a script called BigDump is made for this purpose.

To restore the very large backup of your mySQL database (or a part of it) into the new or the same mySQL database. You can’t access the server shell and you can’t import the dump using phpMyAdmin or any other scripts due to hard memory resp. runtime limit of the web server. -ozerov.de/bigdump.php

alright, so now all what you gotta do is to follow these steps:

• Download the script (10 KB ZIP archive).
• open BigDump.php with any text editor. Edit your MySQL connection information.

$db_server   = '';
$db_name     = '';
$db_username = '';
$db_password = '';

• Upload the script (bigdump.php) to your server.
• Upload the SQL (.sql) file to your server.
• Go to http://www.mywebsite.com/bigdump.php and from there you can start the process.

• Click on Start Import and you are done! Congrats.

For more information and detailed steps, you can visit BigDump homepage.

Informing search engines that your site content has been updated is an important task. Google downloads your site-map automatically every few days, or even few hours If you are running a big website. However, Webmasters like to ping Search Engines automatically after every update on the website. Here are few links for several search engines that you may want to ping.

1. Google

http://www.google.com/webmasters/tools/ping?sitemap=http://site.com/sitemap.xml

2. Yahoo

http://search.yahooapis.com/SiteExplorerService/V1/updateNotification?appid=YahooDemo&url=http://site.com/sitemap.xml

3. Bing

http://www.bing.com/webmaster/ping.aspx?siteMap=http://site.com/sitemap.xml

4. Ask

http://submissions.ask.com/ping?sitemap=http://site.com/sitemap.xml

If you are using WordPress, All-In-One-Seo does this every time you publish a new post. I have made a function if you don’t want to make the ping request manually.

File Name: pinger.php

<?php

function pingSE($url){
@file_get_contents("http://www.google.com/webmasters/tools/ping?sitemap=" . $url);
@file_get_contents("http://search.yahooapis.com/SiteExplorerService/V1/updateNotification?appid=YahooDemo&amp;url=" . $url);
@file_get_contents("http://www.bing.com/webmaster/ping.aspx?siteMap=" . $url);
@file_get_contents("http://submissions.ask.com/ping?sitemap=" . $url);
}

// using the function..

pingSE("http://site.com/sitemap.xml");

?>

Nobody wants to see their own articles being copied and used without permission. So what are you going to do if you face a situation like that? Simply, if you don’t know whether your website/blog content is being copied or not, you can use CopyScape to determine this. CopyScape is a web service that find published pages on the internet that match with your content.  If you find that someone has copied anything that belongs to you and you want them to remove it, there are some solutions that you may want to follow.

1. Contacting The Website Owner

Contacting the website owner is the best solution. You can reach them directly by finding any method of contacting in their website. If you can’t find the contact information there, you may find the domain registrar email and send them a removal request. Because most of the time it is the same person who runs the website. To find the domain registrar email, go to Domain Tools. and search for the desired domain and then you will get the information you need.

2. Reporting The Website To Google Webmaster Tools

If you have contacted the website owner and didn’t respond to your message or even if you couldn’t find any way to reach the them and you believe it is necessary to remove that content or at least not to appear in search results. You may want to report this website to Google. Because duplicate content is against Google’s Terms Of Service. as it said:

If you find that another site is duplicating your content by scraping (misappropriating and republishing) it, it’s unlikely that this will negatively impact your site’s ranking in Google search results pages. If you do spot a case that’s particularly frustrating, you are welcome to file a DMCA request to claim ownership of the content and request removal of the other site from Google’s index.

Conclusion

There maybe several other methods to stop content theft in your blog such as reporting the website to Google Adsense because it’s perceived as breaking their Terms Of Service too. But I believe that the mentioned ways are better than anything else. Share your ideas in the comments section.

I would like to announce that Google has updated the Page Rank today October 30, 2009. The last update was in August 2009. So if you own a website you can go and check your new PR. Vidiame has not been affected by this recent update because it is a brand new website. Please note that this is just news, and we know that Google Page Rank is not the only factor in SERP. Here are two handy tools to get your accurate page rank.

1. DigPageRank

DigPageRank is an instant page rank checker tool. You can check you page rank in 700+ Google Data Centers as i said. Also it checks if the page rank is valid or not.

2. PaRaMeter

Do you want to scan multiple websites for page rank? and even their internal pages? This is what you need. PaRaMeter is a program that crawls your website to get the pages and then scan every single page to show the result in a list.