Cara Pindah File antar Server menggunakan putty (SSH)

Download putty disini:

http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html

– Buka Putty.exe, masukkan Host Name or IP Address Port diisi 22
– Tekan Open, kemudian masukkan user login, Enter
– Masukkan Password, tekan enter
– Muncul user@domain.com [~]#
– Ketik “dir” (tanpa tanda petik), untuk melihat directori apa aja yg ada dalam server
– ketik cd public_html [artinya change directory to public_html]
– ketik wget http://tempatdonlot.com/blablabla.zip , klik enter, untuk medonlot file tersebut ke server kita
– Beresss…

Remove Duplicate From WordPress Quickly

Remove Duplicate From WordPress Quickly,
This is simple, Login to cpanel, and the go to phpmyadmin
Select your Blog’s mySQL database Account, (You will see a list of tables within that database). Click on SQL
Copy-past below given SQL command and click on Go:

DELETE bad_rows.*
from wp_posts as bad_rows
inner join (
select post_title, MIN(id) as min_id
from wp_posts
group by post_title
having count(*) > 1
) as good_rows on good_rows.post_title = bad_rows.post_title
and good_rows.min_id <> bad_rows.id

Now Just wait for about a few minutes and All your Duplicate Posts will be removed magically.