Page 21 of 27 FirstFirst ... 111920212223 ... LastLast
Results 201 to 210 of 265
  1. #201
    Join Date
    Apr 2006
    Location
    Dark Side of the Moon
    Posts
    987
    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
    9,625
    Plugin Contributions
    123

    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. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  3. #203
    Join Date
    Apr 2006
    Location
    Dark Side of the Moon
    Posts
    987
    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
    9,625
    Plugin Contributions
    123

    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. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  5. #205
    Join Date
    Aug 2007
    Location
    Gijón, Asturias, Spain
    Posts
    2,571
    Plugin Contributions
    30

    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: Spanish Language Pack, Google reCaptcha, Structured Data, Multiple Copy-Move-Delete, Image Checker, BackupMySQL Admin/Auto...

  6. #206
    Join Date
    Jun 2007
    Location
    Texas, USA
    Posts
    1,400
    Plugin Contributions
    1

    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
    Location
    Texas, USA
    Posts
    1,400
    Plugin Contributions
    1

    Default Re: Backup MySQL Database

    It now works after password change.

  8. #208
    Join Date
    Aug 2008
    Location
    Abbottabad, Pakistan
    Posts
    60
    Plugin Contributions
    0

    Default Re: Backup MySQL Database

    I am getting this error when I try to create a backup

    0 => mysqldump: Got error: 1045: "Access denied for user 'anythingframedco_usman'@'localhost' (using password: NO)" when trying to connect

    How do i fix it?

  9. #209
    Join Date
    Jul 2012
    Posts
    16,719
    Plugin Contributions
    17

    Default Re: Backup MySQL Database

    Quote Originally Posted by mani View Post
    I am getting this error when I try to create a backup

    0 => mysqldump: Got error: 1045: "Access denied for user 'anythingframedco_usman'@'localhost' (using password: NO)" when trying to connect

    How do i fix it?
    For starters, please identify the version numbers for: this plugin, Zen Cart and PHP.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  10. #210
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,625
    Plugin Contributions
    123

    Default Re: Backup MySQL Database

    Quote Originally Posted by mani View Post
    I am getting this error when I try to create a backup

    0 => mysqldump: Got error: 1045: "Access denied for user 'anythingframedco_usman'@'localhost' (using password: NO)" when trying to connect

    How do i fix it?
    This means your database password, as specified in admin/includes/configure.php, has special characters in them. Change it to one without special characters and it will work.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

 

 
Page 21 of 27 FirstFirst ... 111920212223 ... 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