Thanks for ur suggestion.l created a backup.sql file and followed ur instructions. but I am getting the error after running shell script.
the Error is :" Access Denied For User: 'venus1@localhost' (Using Password:YES)
For granting privileges, I used the grant command like this:
grant all privileges on dbfirst.* to venus1@'localhost' identified by 'venus1' with grant option;