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 Gambar Use ScrapeBox to Monitor Your Competitor Image
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. Gambar Use ScrapeBox to Monitor Your Competitor Image

Now your next task is getting more backlinks Gambar Use ScrapeBox to Monitor Your Competitor Image