Setting Up Automatic Database Backup Through Cron Job
by Parv, under PHP, Web Development. 
Email this article to a friend
Just run the following mysql command in command text box in your hosting account’s cron job manager -
mysqldump –opt -Q -h {your_domain_name} -u{your_username} -p{your_password}
{your_database_name} | gzip
> {full_path_of_your_backup_directory}/auto_backup_`date +\%Y\%m\%d\%H\%M\%S`.sql.gz
Just replace {your_domain_name},{your_username},{your_password},{your_database_name} and {full_path_of_your_backup_directory} with appropriate values.
Example:
mysqldump –opt -Q -h myserver.com -ubob -p123456 bob_db | gzip > /home/bob/public_html/auto_backup_`date +\%Y\%m\%d\%H\%M\%S`.sql.gz
No Comments
How To Enable Gzip Compression From htaccess
by Parv, under PHP, Web Development. Email this article to a friend
Simply add the following code in your .htaccess file and you are done.
#Gzip AddOutputFilterByType DEFLATE text/text text/html text/plain text/xml text/css application/x-javascript application/javascript #End Gzip
No Comments
PHP Script To Bulk Change Collation Of All The Tables In A MySQL Database
by Parv, under PHP, Web Development. Email this article to a friend
Sometimes we run into a requirement where we need to add the support for multiple languages in our application and you may find out that your database collation is ‘latin1_swedish_ci‘, which does not support multibyte languages like Chinese, Japanese etc.. In this situation you will need to change your database collation to ‘utf8_general_ci‘.
This simple script below will let you change the collation of all your database tables in bulk. Just create a new PHP file and paste the code below into that file. Run the file and you are done.
No Comments
PayPal Integration Scenarios To Be Checked While Integrating Paypal Into An Application
by Parv, under PHP, Web Development. Email this article to a friend
Below are common scenarios that need to be checked while integrating PayPal into an application/website. These can be utilized it while integrating in your projects. If I’ve missed something, you can also suggest more in the comment section below.
No Comments
List of Spam IP Addresses
by Parv, under Web Development. Email this article to a friend
Last Updated on 28 November, 2011
Just want to share this list of spam IP addresses to help webmasters prevent their sites with automated spam attacks. The IP addresses in this list have been captured after they were used to either register an account automatically or visit the websites automatically through spam bots on the various websites I manage. In case you don’t know, the automated registrations and visits are achieved with the help of scripts running on various dedicated and virtual servers. You can block or ban these IP addresses whichever way you find it suitable. I hope you will find it helpful.
This list is updated regularly so keep yourself updated with the latest additions of spam IP addresses.
2 Comments
A Quick Overview Of Twitter
by Parv, under Social Media, Twitter. Email this article to a friend
Twitter is an online social media website. Anyone can use Twitter, as long as they have Internet access and an email account for sign up. There are many aspects that make this site interesting and quite unique from other forms of socialization. Twitter is much like a quick wave to a neighbor, to let them know what you are up to, but instead of being person to person contact, it is done online. Twitter is growing by leaps and bounds, due to the number of news organizations, online gurus and celebrities that have taken to it.
No Comments
What Makes People Unfollow On Twitter ?
by Parv, under Social Media, Twitter. Email this article to a friend
The goal of Twitter is to interact with other people. It goes without saying that you do need to follow at least a few people so that you could interact with them. But, there comes a time when you may be hitting the un-follow link more often than you had hoped. The reasons for this are quite simple most of the time. You just do not like the person. There are two things to consider here. First, consider why you should un-follow people on Twitter. Second, determine what you should avoid doing so that people do not stop following you for those actions.
No Comments
What Do You Wish to Accomplish Using Twitter?
by Parv, under Internet Marketing, Social Media, Twitter. Email this article to a friend
Twitter may seem like a simple tool used only to communicate with others in a passing method. Yet, it can be used in various ways. Many people have set out to use Twitter with specific goals. They want to accomplish one thing or another by posting the short, 140 character messages about what they are doing. Some of the best bloggers and Internet marketers are noticing that Twitter is actually quite capable of helping individuals to accomplish various things.
No Comments
How To Use Twitter To Increase Traffic To Your Affiliate Programs
by Parv, under Internet Marketing, Making Money Online, Social Media, Twitter. Email this article to a friend
One way to use Twitter is as a tool for promoting your affiliate program. An affiliate program is a method of making money online. Individuals sign up with selected companies and promise to do the marketing for the company. They promote the product, service or the company in general to the public. To do so, they are giving a website or link to use. Anytime there is a purchase made through their link, for example, the affiliate marketer is able to earn a small commission. This automated system works over and over again, creating a strong wealth stream for the everyday Internet marketer.
No Comments
How To Use Twitter To Direct Traffic
by Parv, under Internet Marketing, Social Media, Twitter. Email this article to a friend
Twitter is a tool used for many purposes, or just a few. It is up to you to use Twitter as it fits your personal and business needs. Many people find that Twitter is so flexible that it can be easily used for any need, large or small. It seems that one of the most important ways to use Twitter is as a tool to direct traffic to blogs, websites or retail outlets online. It does no matter what your online business is, what you are promoting, or what you are selling. Twitter is an ideal tool for traffic movement.
Hi, I'm Parv - a young entrepreneur, web developer, blogger and the author behind this blog.... 
Loading ...