Hey there! any question in your mind? Ask It Now!.

Popular Categories

Error is coming while taking dump from MySQL.

+2 votes
asked in Programming by nitu (1,680 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!

1 Answer

+3 votes
answered by raghav (960 points)
edited by Himanshu
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.
commented by nitu (1,680 points)
Thanks sir after removing space between -p and my password I am able to take dump.
Thanks for help.

Related Questions

+12 votes
1 answer 238 views
+1 vote
1 answer 257 views
+1 vote
1 answer 1,398 views
+8 votes
1 answer 243 views
+8 votes
2 answers 222 views
+2 votes
1 answer 1,081 views

Not a Member yet?

Ask to Folks Login

My Account
325 Folks are online
0 members and 325 guest online
Your feedback is highly appreciated