backup error result code: -1, database has not been saved

[wyns]

I thought I was doing backups, but there is no information contained in the backup. I get this error message when going through Tools/database backup.

I went to my hosting service to try to do a manual backup from there. Couldn't find a way.

Why am I getting this error message? What can I do to solve the problem?

We have not updated to the new version because we have some customization that we feared losing. Not sure which version we have, but copyright is 2003.

Thank you.

[DrByte]

When using the Database Backup-MySQL option from the Tools menu, and you click "Backup" to start a new backup, you are presented with a few checkboxes and another "backup" button.

When you're on that screen, before you click the "backup" button under the checkboxes, put &debug=ON in the URL of your browser, then press Enter, and then click Backup.

You should get some debug messages in the top line. What are they ?
(please XXXXXX out your password before posting the messages)

[wyns]

This is what I received (of course, I have taken out the username and password from this for security).

Checking Path: /usr/bin/

Checking Path: /usr/bin/

Checking Path: c:/mysql/bin/

Checking Path: d:/mysql/bin/

Checking Path: e:/mysql/bin/

Checking Path: /usr/local/bin/

Checking Path: c:/apache2triad/mysql/bin/

Checking Path: d:/apache2triad/mysql/bin/

Checking Path: e:/apache2triad/mysql/bin/



COMMAND FILES FOUND/SELECTED:
mysqlexe=mysql

mysqldumpexe=mysqldump


COMMAND: mysqldump --host=mysql15.webcontrolcenter.com --user=xxx --password=xxx --opt --complete-insert --result-file=D:\\\\\\\\\\\\\\\\inetpub\\\\\\\\\\\\\\\\instacode\\\\\\\\\\\\\\\\zencart/admin/backups/db_icodecart-20060609132624.sql icodecart 2>&1
valueA:
valueB:
Result code: -1
Failure: The database has NOT been saved.

I hope this helps.

[DrByte]

1. is your /admin/backups folder writable?
2. does a file get created in that folder, at all?
3. I'm guessing the problem is a result of the webservice not having rights to run the EXE's .... and usually the host doesn't like to give such access, for security reasons. IIS is especially crappy for that.

[DrByte]

Worst case you might be stuck with using phpMyAdmin.
http://www.zen-cart.com/forum/faq.ph...yadmin_backups

[dddmx3]

This is what solved my problem:

I click "restore" it says

"uploaded successfully
Result code: -1" or something like that...

Now that it was uploaded I clicked the file and click the restore button on the far-right and everything turned out good.

Database restored successfully!