Batch Delete Comments for wordpress

The can use phpMyAdmin to execute this SQL

DELETE FROM wp_comments WHERE comment_approved = 0

Pan.baidu search engine

This is the best method to search for files that store within pan.baidu. Go To http://so.baiduyun.me/

Web Hosting Suggestions

Normal Hosting
1) www.servinio.com
2) www.inmotionhosting.com
3) www.hostgator.com
4) www.bluehost.com
5) www.hostwinds.com
6) www.stablehost.com
7) www.stablebox.com
8) www.site5.com
9) www.dreamhost.com
10) www.hawkhost.com
11) www.arvixe.com
12) www.ixwebhosting.com
13) www.servikus.com

Offshore
1) www.koddos.com
2) www.knownsrv.com
3) www.shinjiru.com
4) www.ccihosting.com
5) www.nextgenhost.net
6) www.panamaserver.com
7) www.alibabahost.com
8) www.hidemyhost.com
9) www.lunarvps.com
10) www.altushost.com
11) www.underhost.com

How to upload more than 50mb database?

1) Download BigDump from here

2) Make sure you have a copy of the large database you want to import in .sql or .gz format. Make sure when you export the database that you include the ‘drop table’ function and turn off ‘extended inserts’. - 

3) Open bigdump.php and change the database details to match your own. 

$db_server   = 'localhost'; //This is usually localhost

$db_name     = 'database_name'; //Your database name

$db_username = 'database_username'; //Your database username

$db_password = 'password'; //Your database password

4)  Upload bigdump.php to your website.

5)  Upload the .sql or .gz file to the same directory as bigdump.php.

6)  Access http://yourwebsite.com/bigdump.php

7)  Select the file you wish to import from the list that BigDump creates.

8)  Wait for the import to finish. BigDump will give you a status bar with details on the progress of the import.

9)  Once you’ve finished, remember to delete bigdump.php and your database file from your webspace!

Note:If you keep getting a timeout error when BigDump runs an import, try increasing the $linespersession.

How to check PHP memory limit?

1) Create a file called phpinfo.php :

<?php

phpinfo ();

?>

2) Check your domain
http://www.yourdomain.com/phpinfo.php

Finding The Correct Niche

Niche is a specific product/keyword is being focused.The  2 basic rules in finding the correct niche:1) min cpc: $1+2) 
Total monthly US exact match searches: 1000++

By having these 2 basic rules, we can know that our cpc is high and within serp 10.

Tips:By using emd/specify domain, we can have lower competitors but less audience. 
 Avoid high PA,PR,Backlinks competitors' niche.

How to estimate adsense earning?

          Total monthly visitor X CTR X CPC = Monthly Estimated Earning

E.g     1000 X 5% X $2 = $100 Per Month

CTR = Click-through rate (CTR) is a way of measuring the success of an online advertising campaign for a particular website as well as the effectiveness of an email campaign by the number of users that clicked on a specific link.

CPC = The cost-per-click (CPC) is the amount you earn each time a user clicks on your ad. The CPC for any ad is determined by the advertiser; some advertisers may be willing to pay more per click than others, depending on what they're advertising.