Hurray, i am a premium member on DigitalPoint now ![]()
I want to buy sphinx search plugin for vbulletin from DigitalPoint so i have to be registered as premium member
MySQL Table “In Use” Repair
Recently when i optimized some mysql tables from phpmyadmin, some of the tables were “locked” and showed as “in use” on phpmyadmin. The tables could not be used, read, etc. So the script was stopped working.
I have tried to repair / check / analyze from phpmyadmin but i couldn’t repair it.
So i tried to repair the mysql tables from SSH.
Go to your database directory. Usually it is located on
/etc/var/lib/mysql/YOUR_DATABASE_NAME/
So use this command first
cd /etc/var/lib/mysql/YOUR_DATABASE_NAME/
Next, use this command
myisamchk --safe-recover --force YOUR_TABLE_NAME
And the MySQL table should be repaired now.
Use ScrapeBox to Monitor Your Competitor
ScrapeBox is one of useful SEO tools. One of its cool feature is you can use it to monitor your competitor’s backlink ![]()
Backlink is one of important factor on SEO. So by monitoring and knowing where your competitor’s backlinks are, you can try to compete with them and put more backlinks than theirs.
To do this, you can use ScrapeBox add-ons, called “Backlink Checker”. Just load your competitor URLs and ScrapeBox will show you where their backlinks are.
Now your next task is getting more backlinks
Quick Adsense Random Align
Quick Adsense is one of useful WordPress Plugin which can be downloaded here
http://wordpress.org/extend/plugins/quick-adsense/
It can insert ads to your post content automatically.
Here is a hack to make your ads to be aligned randomly left / right AND center / none :
Continue reading
April Fool Day
What did you do on April Fool Day? Did you do something? I did nothing on April Fool Day