Database backup mySQL can't restore

[DrByte]

Contribution has been updated to incorporate the above fix as well as remove the requirement to check the skip-lock-tables radio-button if your MySQL user doesn't have the required permissions. (It now traps that error and re-attempts the backup with the skip-locks parameters set.)

http://www.zen-cart.com/index.php?ma...products_id=81

[tvadpro]

Thanks, DrByte! I replaced the line around 123 ($dump_params) as you first indicated, but I got

Parse error: parse error, unexpected T_CASE in /hsphere/local/home/user/domain/admin/backup_mysql.php on line 207

when I tried running the mod. I then downloaded and unzipped the revised mod from your link, and compared revised files to the existing ones. Noticing you'd overhauled admin/backup_mysql.php in a big way, I installed the complete version 1.3.

Bravo! Works flawlessly with 1.3.7, at least in so far as it omits the LOCK_TABLES from new backups. Haven't tried restoring from backup yet; I'll install 1.3 on a non-productive site this weekend and do a restore from backup.

Again, many thanks and a round of coffee for the fix.

Sean

Contribution has been updated to incorporate the above fix as well as remove the requirement to check the skip-lock-tables radio-button if your MySQL user doesn't have the required permissions ...

[gxjenkins]

Hello,
I downloaded and installed Database Backup 1.3 today and I'm getting errors when I try to do a backup.

“Warning Result code: 2
Warning 0 => /usr/bin/mysqldump: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Warning 1 => /usr/bin/mysqldump: Character set '#33' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file
Warning 2 => /usr/bin/mysqldump: Got error: 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client when trying to connect”


I'm wondering if this is not working because I'm hosted with GoDaddy, or could it be something in the local setup. Any information would be appreciated.

I'm using cart version 1.3.7

Thanks.

[DrByte]

That sounds like it's a server config problem that is most likely a result of limitations GoDaddy has set on their server.
You might be able to get resolution via their tech support team (ask them to address the charset issues in their mysql configuration).
However, since your database sits on a server that is separate from your hosting server, you may have some limitations in using the server-side tool to do the backup.
You'll likely have to use phpMyAdmin instead, or some backup option offered by GoDaddy's control panel, if any.

[gxjenkins]

Thanks, I'll check with GoDaddy. I was warned of possible limitations but hadn't run into any until now.
Thanks.

[gxjenkins]

I'm on the phone now with Godaddy and it doesn't sound like they have a clue.

Is there anyone else using this Mod and hosted with Godaddy?

Thanks.

[tvadpro]

Sounds like the experience I had with GoDaddy web hosting several years ago. Sorry, I hadn't even heard of Zen-Cart back then. Their tech support was so inept, I haven't considered them for hosting since.

Wow. That sounded bitchy, even for me. (And off-topic.)

If it helps, you might forward the following from DrByte's readme to the GoDaddy tech support staff:

This tool does not work on servers running in strict safe_mode, or with open.basedir restrictions in effect, or with restrictions against
using "exec()" commands. There is no way to work around these limitations
without turning off the restrictions on your server. Contact your host for more information on such possibilities.

I'm on the phone now with Godaddy and it doesn't sound like they have a clue.