+2 votes
217 views
in Programming by (1.7k points)
Hello guys I am trying to take backup of my database, For this I locked my table , Some how while taking dump getting this error : 1064 error on syntax .
See the command :
 
mysqldump -u admin -p password productdb
 
When I execute the same command in terminal there was a error message ''command not found" , Please suggest me what I am missing.
Thanks For Help!
closed

1 Answer

+3 votes
by (960 points)
edited by
 
Best answer
As we know mysqldump is used for taking back up of database,  Lets see your command :
 
 you have executed mysqldump -u admin -p password productdb
 
 Now Lets see the correct syntax :
 
 mysqldump -u <user_name> -p<user_password>
 
 We have found what you are missing here see you have an space between -p and your password while according to  correct syntax their should not be space between them.
 I hope you got my point.
by (1.7k points)
Thanks sir after removing space between -p and my password I am able to take dump.
Thanks for help.

Not a Member yet?

Ask to Folks Login

My Account

Your feedback is highly appreciated