Another Domain Scam

LOL. I opened up my mailbox and got this email which wasn’t filtered as spam.

Dear lopau Team,

Good day to you

We received a formal application from Netlon Company are applying to register ” lopau ” as their website and internet brand name in European, American and Asian area on May 28th 2009. During our auditing procedure we find out that the alleged Netlon Company has no trade mark nor patent even similar to that word. Hence we need you confirmation for two things,

First of all, whether this alleged Netlon Company is your business partner or distributor in business world.

Secondly, whether you are interested in registering these domains and internet keyword.

(.eu/.asia/.cn/.com.cn/.com etc)

This is a letter for confirmation. If we haven’t receive your reply. We will automatically confirm application from Netlon Company after this audit procedure.

Yours Faithfully,

Robin

Registration Commissioner

China Anti-Cybersquatting Organization

‘Tel: +00852 8135 9416

Web: www.mwwgroup.org

Goodluck Robin! Batman’s not taking the bait.

No Renaming Tables feature in phpMyAdmin

Quick tip. The feature is not (yet) supported in phpMyAdmin but you can easily make the change by simply issuing this sql statement.

RENAME TABLE old_table TO new_table

Update On phpMyAdmin select a table then go to Operations, Under Table Options you would see Rename Table to feature.

Import sql dump using the MySQL client

This is useful if you don’t have access to phpmyadmin on your server but have access to ssh and ftp. Or you have a huge sql dump like 10MB or higher that you cannot import directly on phpmyadmin. In my case the phpmyadmin directory was password protected by Apache and I don’t have the right password.

First upload the .sql file on your server using an FTP client and remember the path.

eg.
For Linux
/home/lopau/mydump.sql

for Windows
C:/wamp/www/lopau/mydump.sql

Login to your server using an SSH client like Putty.

On the command line access MySQL
$> mysql -u username -p password

replace username and password with yours.

On the MySQL client command line access and use your database.
$> use lopaudb;

Now to import your dump;
$> source /home/lopau/mydump.sql;

If successful you should see
Query OK, 13 rows affected (0.00 sec)

That easy.