Results 1 to 10 of 10
  1. #1
    Join Date
    May 2007
    Location
    Florida
    Posts
    18
    Plugin Contributions
    0

    Default Backup MySql error

    Hi,
    On a fresh install of v1.3.8, I have the add on "Backup Mysql".
    I have used it on v1.3.7 for some time, but on v1.3.8, I am getting this when trying to make a backup .
    On a Windows server.
    Error:

    Result code: 1
    0 => 'mysqldump" "--host' is not recognized as an internal or external command,

    1 => operable program or batch file.

    Failure: The database has NOT been saved.

    Dr. Byte? Anyone can help?
    I really appreciate it.

  2. #2
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Backup MySql error

    You're on a Windows server. In the /admin/backup_mysql.php file, what is the OS_DELIM set to?
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    May 2007
    Location
    Florida
    Posts
    18
    Plugin Contributions
    0

    Default Re: Backup MySql error

    Hello!

    It looks exactly like this:
    define('OS_DELIM', '');

  4. #4
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Backup MySql error

    Try using this:
    Code:
    define('OS_DELIM', '"');
    (ie: add a double-quote between the two single-quotes)
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  5. #5
    Join Date
    May 2007
    Location
    Florida
    Posts
    18
    Plugin Contributions
    0

    Default Re: Backup MySql error

    worked perfectly with your fix.
    Thanks : ) : )

  6. #6
    Join Date
    Jun 2008
    Posts
    24
    Plugin Contributions
    0

    Default Re: Backup MySql error

    Quote Originally Posted by DrByte View Post
    Try using this:
    Code:
    define('OS_DELIM', '"');
    (ie: add a double-quote between the two single-quotes)
    having the same problem , changed to define('OS_DELIM', ' " ');but still getting same error

    Result code: 1
    0 => '"mysqldump"' is not recognized as an internal or external command,

    1 => operable program or batch file.

    Failure: The database has NOT been saved.

    can U help me Dr.Byte
    Ambra
    ---------------------------------

  7. #7
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Backup MySql error

    You have one or two problems ...

    a) You stated you changed the define, but what you posted includes extra spaces around the double-quote mark, which would cause a problem.
    b) It's very possible that the computer/server you're running it on doesn't even have the mysqldump binary/executable file on it. If you know that it does, you could try editing the /admin/includes/languages/english/backup_mysql.php file and set the actual path to it (instructions in the file). If it doesn't have the program on the server, then ... you can't use this addon until you install the mysql programs.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  8. #8
    Join Date
    Feb 2008
    Location
    by Nuremberg Germany
    Posts
    51
    Plugin Contributions
    0

    Default Re: Backup MySql error

    Dr. byte, good add on but you will be dealing with many problems. Woulds be better to write two contribs. One for the windows server and one for UNIX. This problem is going to haunt you...

  9. #9
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Backup MySql error

    Thanks for sharing your exceptionally astute insight. Too bad whatever you're trying to say doesn't make any sense.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  10. #10
    Join Date
    Nov 2007
    Location
    Woodbine, Georgia, United States
    Posts
    4,018
    Plugin Contributions
    61

    Default Re: Backup MySql error

    Quote Originally Posted by bigbadbob View Post
    Dr. byte, good add on but you will be dealing with many problems. Woulds be better to write two contribs. One for the windows server and one for UNIX. This problem is going to haunt you...
    Windows hosting is very particular and garbage IMO... So if we all did that there would be very little if any mods for Win servers... Then there would be complaints about that as well, I am sure.

    If you are using Windows hosting with all of it idiosyncrasies, then clearly these are your cross to bear. Remember that these modules and the resulting support are on a volunteer basis... also that most web hosting is Linux/Apache based... So logically speaking MOST of what you are going to get from said Zen Cart users is for the Unix platform.

    ~Melanie
    PRO-Webs, Inc. :: Recent Zen Cart Projects :: Zen Cart SEO – 12 Steps to Success
    **I answer questions in the forum, private messages are NOT answered. You are welcome to contact us via our website for professional engagements.

 

 

Similar Threads

  1. Replies: 1
    Last Post: 3 Dec 2012, 01:58 PM
  2. MYSQL Backup addon error
    By cadfc in forum All Other Contributions/Addons
    Replies: 56
    Last Post: 19 Nov 2010, 12:19 AM
  3. Backup MySql plugin error
    By jwurster in forum All Other Contributions/Addons
    Replies: 5
    Last Post: 29 Jun 2009, 07:56 PM
  4. After host change, mysql backup giving error 1045
    By canemasters in forum General Questions
    Replies: 12
    Last Post: 25 May 2008, 08:18 PM
  5. Backup MySQL Module error
    By oxicottin in forum General Questions
    Replies: 8
    Last Post: 16 May 2007, 02:38 PM

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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR