buwp 3.6.1 zips files OK. Errors out on mysqldump: ('mysql' is not recognized)

  • Resolved AccountantQLD

    (@accountantqld)


    7 years, 10 months ago

    Hi –

    Have been using wp + buwp both hosted and via Win7 XAMPP dev for years with no problem. Terrific tool. Today I stood up a cleanskin xampp v5-6-21 + wp v4-5-2 + buwp v3-6-1. Everything works as normal, except buwp – It’s able to zip the files, but fails on the mysqldump. Here:

    “BackUpWordPress detected issues with your last backup.

    Mysqldump: ‘mysql’ is not recognized as an internal or external command,
    operable program or batch file.

    IMysqldump: Connection to mysql failed with message: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it.

    php: ZipArchive::close(): Renaming temporary file failed: Invalid argument, C:\xampp\htdocs\va\wp-content\plugins\backupwordpress\classes\backup\class-backup-engine-file-zip-archive.php, 46″

    I can import and export via MySQL Workbench:
    “mysqldump.exe is version 5.7.9, but the MySQL Server to be dumped has version 10.1.13. <snip>
    Running: mysqldump.exe –defaults-file=”c:\users\jd\appdata\local\temp\tmpl4kn34.cnf” –user=root –host=127.0.0.1 –protocol=tcp –port=3308 –default-character-set=utf8 –skip-triggers “verveacc_vacomau”
    21:50:16 Export of D:\Users\JD\Documents\MySQL Backups\Dump20160610.sql has finished”

    In my environment the only thing that’s different this time is that I’m not using the default ports for MySQL and Apache due to conflicts with the MS http.sys ecosystem/noise. I have MySQL on 3308 and Apache on 8085.

    e.g. http://www.verveaccounting.dev:8085/wp-admin/admin-ajax.php?action=hmbkp_run_schedule&hmbkp_schedule_id=1465542789&hmbkp_run_schedule_nonce=a3db822a92

    Thoughts?

    Regards,
    JD

    EDIT: for a point of comparison I tested buwp on current hosted production (hoster: zuver.com.au) which is wp v4-2-8, buwp v3-4-3, mysql v5-6-30, php v3-2-21. Runs OK. So I upgraded buwp to v3-6-1 in production and ran another backup. Also works OK.

    https://wordpress.org/plugins/backupwordpress/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter AccountantQLD

    (@accountantqld)

    7 years, 10 months ago

    EDIT2: Out of curiosity I ran another files+database buwp v3-6-1 backup against the local xampp site. This time it didn’t throw any errors at all, and the backup completed and generated a zip backup file. However, the zip file only contains the filesystem files component – there is no database .sql in there. The buwp settings were set for database+files and that’s what the “backups completed” list indicates in the buwp backups listing.

    Thread Starter AccountantQLD

    (@accountantqld)

    7 years, 10 months ago

    EDIT3: Again, of curiosity, restored a production backup to the local XAMPP enivronment and executed a buwp backup using the production version of wp and buwp (i.e. wp v4-2-8, buwp v3-4-3).

    Once again, the files were backed up OK, and the SQL backup failed.

    This time however, the files in the buwp zip were from the XAMPP root (i.e. all websites and the xampp application istelf) rather than the wp root.

    i.e. buwp zipped everything from c:\xampp\htdocs\ down rather than just c:\xampp\htdocs\va\

    Plugin Contributor Katrina “Kat” Moody

    (@katmoody)

    7 years, 10 months ago

    I am going to run this ticket by one of the developers – I don’t use XAMPP so I’m not familiar with the nuances you might need. It sounds like you might need to set your root directory and potentially set where the MySQLDump is installed, but I’d like them to weigh in. We’ll have a chance to chat on this next week and I’ll update afterwards!
    Kat

    Gangsar Swapurba

    (@gangsarswapurba)

    7 years, 8 months ago

    hi mate,

    i also got
    IMysqldump: Connection to mysql failed with message: SQLSTATE[HY000] [2002]

    and then, i adjust my DB_HOST constant to
    define('DB_HOST', '127.0.0.1:3306');
    in wp-config.php file

    now it works!

    it’s not bad to give it a try 🙂

    Plugin Contributor Katrina “Kat” Moody

    (@katmoody)

    7 years, 8 months ago

    Hey there @accountantqld – are you able to try what the last user suggested? Defining who your DB Host is in your wp-config? Try that and see if it works for you. And @gangsar.swapurba thank you so much for sharing!

    If that doesn’t still work and you’d like to continue working through some troubleshooting please just comment back here.

    Since it’s been a month since hearing from you, I will go ahead and mark this as resolved for now as outdated. Just let me know if you’re still having trouble.

    Thanks,
    Kat

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘buwp 3.6.1 zips files OK. Errors out on mysqldump: ('mysql' is not recognized)’ is closed to new replies.