TransWikia.com

Can't Backup Database - "Failed with exit code 1" (WAMP Server)

Craft CMS Asked by theAdhocracy on September 4, 2021

I’m running Craft 3 on a local windows machine, but every time I try to update certain plugins (or Craft itself) I get a message “Couldn’t back up the database. How would you like to proceed”.

The logs give the following:

[error][craftcontrollersUpdaterController::actionBackup] Error backing up the database: The shell command "mysqldump ..." failed with exit code 1.

(I’ve removed most of the error code for the actual query, let me know if that would be useful).

I’m aware there are well documented hurdles with mysqldump and localhost, but I’ve already tried the proposed solutions here, here and here.

The global (not local, though I’ve tried both) PATH env has been set with the root of my MySQL folder (“C:wamp64binmysqlmysql5.7.26bin”) and I’ve restarted my machine, server etc. but still get the same error. I’ve also confirmed mysqldump is running and available in a normal terminal.

I’ve also tried the official guide to get MAMP working, tweaked as best I could for Windows (though I’m far from experienced so could have done something wrong) and that did nothing either.

I’m running Windows 10 (if that helps).

Any idea what exit code 1 means?

EDIT: See the comments below, but I’ve almost cracked this. My remaining issue is that I can’t find any examples of the my.cnf file. Doesn’t seem to be present on any Craft installs I have access to (though only this one has this issue), which means I can’t manually generate it and Craft seems to be failing to do so. Any ideas?

One Answer

Following up on your last comment:

So I guess my final question is: how can I either manually create the required file (which is missing) or amend the query?

You can completely override Craft's default backup command by specifying it in the backupCommand config setting.

Craft will attempt to execute whatever is in there when it goes to perform a backup.

Answered by Brad Bell on September 4, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP