The problem seems to be in mysql.sock location. I found a solution from here:
One way to change the socket location is to edit the MAMP start and stop scripts so that the mysql.sock location is the default. This can be done by editing the following files:
How I solved the problem
drush ard -v
to see what was going on.
Executing: mysqldump --result-file /tmp/drush_tmp_1352892897_50a381e13a71d/... --no-autocommit --single-transaction --opt -Q ... --host=localhost --user=... --password=...
Database dump failed.
So I copied the mysqldump command and copied it to the command line and hit enter.
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect.
After this I tried several methods to solve the socket issue after I found the solution from www.razorsql.com.