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

Popular Categories





Error is coming while taking dump from MySQL.

+2 votes
120 views
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 126 views
+1 vote
1 answer 198 views
+1 vote
1 answer 1,070 views
+8 votes
1 answer 120 views
+8 votes
2 answers 132 views
+7 votes
7 answers 1,501 views
0 votes
0 answers 466 views
+1 vote
0 answers 117 views
+2 votes
1 answer 877 views
+7 votes
8 answers 7,422 views

Not a Member yet?

Ask to Folks Login

My Account
443 Folks are online
2 members and 441 guest online
Your feedback is highly appreciated