mysqldump access denied


  1. Posts : 2
    Windows 7/Slackware Linux
       #1

    mysqldump access denied


    Hi, I'm trying to do a mysql dump via the following procedure:


    1. Run cmd.exe as administrator
    2. Run "mysqldump -uroot -hlocalhost -ppassword --all-databases >%homepath%\Desktop"

    I get the following output:
    Access is denied.

    Why can't I write to my own desktop, even when I'm running the command as an administrator?
    What can I do to resolve this issue?
      My Computer


  2. Posts : 2
    Windows 7/Slackware Linux
    Thread Starter
       #2

    Problem solved. I was not giving the dump file an actual name. I needed to use:
    "mysqldump -uroot -hlocalhost -ppassword --all-databases >%homepath%\Desktop\backup.sql"

    opposed to:
    "mysqldump -uroot -hlocalhost -ppassword --all-databases >%homepath%\Desktop".
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 15:41.
Find Us