Page 21 of 21 FirstFirst ... 11192021
Results 201 to 207 of 207
  1. #201
    Join Date
    Apr 2006
    Location
    Dark Side of the Moon
    Posts
    986
    Plugin Contributions
    1

    Default Re: Backup MySQL Database

    Quote Originally Posted by shrimp-gumbo-mmmhhh View Post
    Hello, I am using this plugin and have a VPS. This is working fine on one of my accounts but is not working on another. Here is the error messages: Running V1.56a works fine on one site but not this one. Any suggestions or thoughts? When I get on phpAdmin from this account this is the database server it is showing:

    Server: localhost:3306 same as the working backup site.

    Server: lo
    Result code: 2
    0 => mysqldump: Got error: 1045: "Access denied for user 'website'@'localhost' (using password: YES)" when trying to connect

    Failure: The database has NOT been saved.

    I'm have the exact same problem. Installed and working on one VPS but not working on another. Both on same hosting provider. Zencart 1.5.6a, php 7.3

  2. #202
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    6,336
    Plugin Contributions
    253

    Default Re: Backup MySQL Database

    I suspect the issue you are seeing is that on the site where it doesn't work, your password has shell metacharacters. Create a new password without these, update your configure.php files, and try again.

    I thought I solved this problem but further testing showed that my fix was incomplete.

    Google "shell metacharacters" if you don't know what these are, or just use numbers and letters (upper and lower case) in your new password.
    That Software Guy, Plugin Moderator. Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Contributions: Quantity Discounts, Better Together, SMS on Sale, Gift Wrap at Checkout, and more.

  3. #203
    Join Date
    Apr 2006
    Location
    Dark Side of the Moon
    Posts
    986
    Plugin Contributions
    1

    Default Re: Backup MySQL Database

    Ha! I just spent about 30 minutes working with my host and turns out, as you also just suggested, that it does not like certain characters. In this case, it was my use of the semi-colon ";" ... Once I removed that, everything worked as it should.

    Thanks for the reply. Hopefully this will help others that stumble into this problem!

  4. #204
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    6,336
    Plugin Contributions
    253

    Default Re: Backup MySQL Database

    I'll do some more testing and see if I can figure out a way to make this work. I think @mc12345678 also had some ideas on how to fix this problem so maybe he will chime in.
    That Software Guy, Plugin Moderator. Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Contributions: Quantity Discounts, Better Together, SMS on Sale, Gift Wrap at Checkout, and more.

  5. #205
    Join Date
    Aug 2007
    Location
    Gijón, Asturias, Spain
    Posts
    1,957
    Plugin Contributions
    29

    Default Re: Backup MySQL Database

    Long ago I did extensive testing with passwords and odd characters on Windows and Unix, and decided they needed different delimiters. I extensively modified this plugin, you may have more luck with that. It's in my Github.
    Steve
    github.com/torvista: Apsona (php7), BackupMySQL Admin/Auto, CEON URI Mapping (php7), Product Listing Sorter, Redsys payment module, Spanish Language Pack and more...

  6. #206
    Join Date
    Jun 2007
    Posts
    1,098
    Plugin Contributions
    0

    Default Re: Backup MySQL Database

    Quote Originally Posted by swguy View Post
    I suspect the issue you are seeing is that on the site where it doesn't work, your password has shell metacharacters. Create a new password without these, update your configure.php files, and try again.

    I thought I solved this problem but further testing showed that my fix was incomplete.

    Google "shell metacharacters" if you don't know what these are, or just use numbers and letters (upper and lower case) in your new password.
    Yes, the working one is only letters and numbers while the nonworking may have a 1 or 2 shell metacharacters in it.

  7. #207
    Join Date
    Jun 2007
    Posts
    1,098
    Plugin Contributions
    0

    Default Re: Backup MySQL Database

    It now works after password change.

 

 
Page 21 of 21 FirstFirst ... 11192021

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