Page 6 of 27 FirstFirst ... 4567816 ... LastLast
Results 51 to 60 of 265
  1. #51
    Join Date
    Jul 2006
    Posts
    144
    Plugin Contributions
    0

    Default Re: Backup MySQL Database

    The day I go "live", it will be on a window server, will it be "quote problems" you think ? Or is your addon "windows friendly" ?

    /T

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

    Default Re: Backup MySQL Database

    Ugh.

    "friendly" ... as friendly as "windows" is in a hosting environment

    Since every Windows server is configured differently, and since Windows has complicated security risks, it is a challenge to pre-anticipate every issue.

    Try it on your live host and when the time comes, we'll deal with it then.

    Keep in mind that if your host isn't willing to open up webserver access to cmd.exe, then this tool will most likely not work for you. Sorry... thank Bill.
    .

    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. #53
    Join Date
    Jul 2006
    Posts
    144
    Plugin Contributions
    0

    Default Re: Backup MySQL Database

    Quote Originally Posted by DrByte
    Try it on your live host and when the time comes, we'll deal with it then.
    Hi there !

    You were very right, when I put my shop on my live host, the backup part is working just like it suppose to. Thanx.

    /Typhoon

  4. #54
    Join Date
    Mar 2006
    Posts
    194
    Plugin Contributions
    0

    Default Re: Backup MySQL Database

    I am also getting this 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.



    Is there no way to install ZC on Windows XP for local testing purposes?

    I tried WAMP5 and got this error and now I have switched to XAMPP and get the same error. Anyone have a suggestion?

    Thank you.
    TheWindCutter.com
    Professional Microphone Windscreens
    Got wind noise? We've got you covered.

  5. #55
    Join Date
    Mar 2006
    Location
    Durham, UK
    Posts
    84
    Plugin Contributions
    0

    Default Re: Backup MySQL Database

    Quote Originally Posted by duncanad View Post
    One small bug I have found with the new version is that if I backup to the server and click the 'No compression' radio button I get a .gzip file rather than an uncompressed file. If, however, I tick the 'Download without storing on the server' box I get an uncompressed file as expected.

    Anyone else experienced this problem?
    Yep. Exactly the same problem here.
    Quote Originally Posted by Woodymon View Post
    Workaround: When I want to back up with compression off I just turn it off in Configuration > GZip Compression. Then I back up.
    Doesn't work for me
    Quote Originally Posted by duncanad View Post
    When I checked my configuration GZip compression was set to 'Off' so this setting does not appear to affect how the backup operates.
    Same here!
    Quote Originally Posted by Woodymon View Post
    The "No Compression (Pure SQL)" radio button in the BU mod dialog is defectively sticky ... I was the same way, not compressing the DB at first. But after many imports and exports I am now just fine with compressing.
    Still can't get it to work for me. Strange thing is that out of 20-odd attempts to backup without compression, 1 or 2 will work but the rest will be .gz.
    Quote Originally Posted by duncanad View Post
    By compresing the data there is a slight increase in the risk of corrupting the data. Larger backup files might be preferable to lost data. Anyway the engineer in me thinks if you are given the option then you should have that option.
    Me too! Intermittent faults are always the worst. It's just kindof unsettling when you know something doesn't work but you don't know why

  6. #56
    Join Date
    Oct 2006
    Posts
    51
    Plugin Contributions
    0

    Default Re: Backup MySQL Database

    I have a development site on my local machine. if i try to use the backup command, i get the following error.

    Result code: 1
    0 => 'c:/Program' is not recognized as an internal or external command,
    1 => operable program or batch file.

    I should point out that it does work on the live site. Can you please help with a fix for the local environment.

    Thanks

  7. #57
    Join Date
    Mar 2006
    Location
    Rosebud, Victoria, Australia
    Posts
    310
    Plugin Contributions
    2

    Default Re: Backup MySQL Database

    G'day,

    If you're thinking of using something like this to backup your MySQL databases, then you might want to check out the excellent mySQLdumper at www.mysqldumper.de/en/.

    mySQLdumper enables me to get regular backups of all of my MySQL databases sent via email or FTP file transfer.

    mySQLdumper works so as to overcome the limitations people often come up against when trying to backup and/or restore larger databases.

    It's pretty much a set and forget solution. Though I must admit it took me a while to set it up the first few times. I wrote myself a detailed step by step guide which you should be able to find either on the mySQLdumper forums, or on the forums at JaguarPC.

    Best Regards, Lloyd Borrett.
    Zen Cart 1.5.5e, PHP 5.3.29 MySQL 5.5.42

  8. #58
    Join Date
    Jun 2004
    Posts
    36
    Plugin Contributions
    0

    Default Re: Backup MySQL Database

    I am trying to upgrade my cart to 1.3.6, but I've decided to start from a vanilla version of the current codebase. I just tried to install the latest version of the excellent database backup utility on my windows xp sp2 test box and I get a similar problem as other windows users :-

    Warning 0 => 'c:/mysql/bin/mysqldump.exe" "--host' is not recognized as an internal or external command,
    Warning 1 => operable program or batch file

    However, I have an older version of this in contribution working on my 1.2.6 cart running, on the same windows test box. Any idea's ?.

  9. #59
    Join Date
    Oct 2006
    Posts
    51
    Plugin Contributions
    0

    Default Re: Backup MySQL Database

    It is pretty sad! I am a total beginner with no PHP, HTML, CSS, etc.
    I am learning as i go, but there doesn't seem to be a great deal of support from those with the knowledge.....

    The problem with this mode is: -

    mqsqldump: - (backup)

    Line 115, 116, 177, 129:

    Original
    $dump_params .= '" --host=' . DB_SERVER . '"';

    New
    $dump_params .= ' --host=' . DB_SERVER . '';

    The original only works on linux/unix (i guess) the quotes don't work on windows.

    Removes the quotes and the backup will function on both environments.


    Mysql; - (restore)
    Linux/Unix
    $load_params .= ' "--host=' . DB_SERVER . '"';

    Windows
    $load_params .= ' --host=' . DB_SERVER . '';

    Now i need your help! How do i make a switch to use quotes on linux/unix or no quotes on windows please.

  10. #60
    Join Date
    Oct 2006
    Posts
    51
    Plugin Contributions
    0

    Default Re: Backup MySQL Database

    I have successfully modified this mode to work on both linux and windows.

    The only issue i have with it now is to get it to use gzip for windows.
    I didn't seem to have much luck with that after many unsuccessful attempts.

 

 
Page 6 of 27 FirstFirst ... 4567816 ... LastLast

Similar Threads

  1. Backup MySQL Database vs using cPanel backup option?
    By IronMan101 in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 30 Jul 2007, 08:46 AM
  2. Database Backup Manager - MySQL
    By sicness in forum All Other Contributions/Addons
    Replies: 7
    Last Post: 7 Aug 2006, 09:42 PM
  3. Backup MySQL Database failure
    By JFD in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 3 Jun 2006, 06:55 AM

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