SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Addict frankiehots's Avatar
    Join Date
    Jan 2002
    Location
    U.S.A. *Blue State*
    Posts
    289
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Problem doing mysqldump

    I am trying to set up an automatic MySQL database backup, but for starters I can't even get the mysqldump command to work.

    When I run the following command:
    Code:
    mysqldump --user usernamehere --password=passwordhere databasehere | gzip > /httpdocs/mydatabase.gz
    I get the following message:
    -sh: /httpdocs/mydatabase.gz: No such file or directory
    mysqldump: Got errno 32 on write

    I can provide more info if necessary. Any ideas?

  2. #2
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    apparently, httpdocs is not in the root directory. try a relative path instead of an absolute path, or provide the correct absolute path.

  3. #3
    SitePoint Addict frankiehots's Avatar
    Join Date
    Jan 2002
    Location
    U.S.A. *Blue State*
    Posts
    289
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    A big DUH on my part. That was the problem. Thanks longneck!

  4. #4
    SitePoint Wizard Hammer65's Avatar
    Join Date
    Nov 2004
    Location
    Lincoln Nebraska
    Posts
    1,161
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by longneck View Post
    apparently, httpdocs is not in the root directory. try a relative path instead of an absolute path, or provide the correct absolute path.
    I am having the same problem, only I have tried numerous paths including /tmp/mytable.sql and /dev/shm/mytable.sql and nothing works.
    Visit my blog
    PHP && Life
    for technology articles and musings.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •