ISSUE -- could not run the mysqldump -- throwing access denied error.
1. what was the issue
because I didn't have sufficient permission to create the out put file. in the specified path.
C:\Program Files\MySQL\MySQL Server 5.5\bin>mysqldump -u root -p --routines invoice_test >
invoice_test_Oct5.sql
2. what I did?
used the administator privileges to run the command (run the command prompt as admin!! ). and it worked :)
Note: to run the mysqldump command, one should be out of mysql prompt. just go to bin folder and execute the command and should not log in and execute !!!
1. what was the issue
because I didn't have sufficient permission to create the out put file. in the specified path.
C:\Program Files\MySQL\MySQL Server 5.5\bin>mysqldump -u root -p --routines invoice_test >
invoice_test_Oct5.sql
2. what I did?
used the administator privileges to run the command (run the command prompt as admin!! ). and it worked :)
Note: to run the mysqldump command, one should be out of mysql prompt. just go to bin folder and execute the command and should not log in and execute !!!
No comments:
Post a Comment