managed to get it working finally. turns out the /usr/bin/php is not needed unless you are running a php script in your cron.
so if anyone else tries to achieve this, this is is what I have had to use:
mysql -u USERNAME -'PASSWORD' DBNAME < /home/domain/public_html/dump.sql