Method 1 (Long Method)

mysqldump -u USER -pPASSWORD DATABASE > filename.sql

copy the file to the new host and restore using

mysql -u USER -pPASSWORD DATABASE < filename.sql

Method 2 (short method)

mysqldump –opt –compress –user=USERHERE –password=PWHERE
–host=SOURCE.HOST.HERE SOURCE_DB_NAME | mysql –user=USERHERE
–password=PWHERE –host=TARGET.HOST.HERE -D TARGET_DB_NAME -C
TARGET_DB_NAME

I was installing ISPConfig to a Fedora Core 7 Installation but when I rebooted, it shows a black screen with a cursor that appears to be “busy”. Logging in remotely via ssh seems to be working but when I check out which process was “hanging” by issuing the “top” command, I see that gdmgreeter seems to be using up a lot of CPU resource. About 70% to 90%.

After searching google for “ISPconfig conflict” “ispconfig gdmgreeter” “ispconfig hang” and similar keywords, the solution I found that worked best was to create/edit the file called “/etc/sysconfig/desktop”

vi /etc/sysconfig/desktop

and add the following two lines to the file /etc/sysconfig/desktop

DESKTOP=”GNOME”
DISPLAYMANAGER=”KDE”
After reboot, everything works properly. I believe this solution also works for Fedora Core 8. Leave a comment if it worked for you.

I just got an email from paypal announcing a new feature which most of us would really be happy about. Now we can withdraw paypal funds directly to your Philippine Bank Account.

Previously, we can only withdraw to a credit/debit card but now, directly to your savings/current account.

There is no fees when withdrawing funds greater than PHP7,000.00 Anything less than that, there’s a PHP50 charge. Not bad if you ask me. PHP50 is still cheaper than remittance fees.

Here’s a rundown of the procedure and here’s a list of the 9digit bank codes you will need when you register.

I was reading about wikia and I found out that they will be having a beta launch on Jan 7. We’ll, it is already January 7 so I tried going to the site to check it out.

The search results seem pretty ok for me so I wondered if search engine spammers were already getting a hold of some pretty valuable keywords like “viagra”.

I then went to http://alpha.search.wikia.com/ and keyed in “viagra” and lo and behold, there was an image at the right side of the screen with a title “People Matching Viagra”. The guy looks very familiar to me and it looks like one of the famous people in the SEO community.

I then moved my mouse over the image and then it says “Matt Cutts”.

Geez! I don’t know if this is some prank or what but I think the search engine war between Google and Wikia has started!!!

I wonder how would Matt Cutts respond to this? Will he put Jimmy Whales photo in google images? (http://images.google.com/images?q=viagra)

Technorati Tags: wikia, viagra, matt cutts, seo, search engine, search engine war, matt, cutts, wikia search