Database Backup Manager or GoDaddy Problem?

[Stuff4Toys]

Database Backup Manager - MySQL 1.3
Zen-Cart 1.3.7.1 (installed from 1.3.7 not GoDaddy's script)
Host = GoDaddy
MySQL 5.0?

Is there any hope of getting this to work?

Result code: 2
0 => /usr/bin/mysqldump: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
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
2 => /usr/bin/mysqldump: Got error: 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client when trying to connect
Failure: The database has NOT been saved.

This has never worked for me from day one. And either way I chooze gZip or Pure SQL I get a 57 byte file with the gz prefix. I tried the Skip Lock Option and the download option with no effect. Installed on both www.bulklights.com and www.liberty-flag.com both GoDaddy servers. Have not tried it on www.stuff4toys.com on test server.

Thanks
JOhn ><>

[DrByte]

Is there any hope of getting this to work?

Not on GoDaddy shared hosting.

The problem is that the webserver your site runs on is different than the server where the database resides. And, the mysqldump binary application that this backup module uses requires an up-to-date mysql client on the webserver ... and it appears that GoDaddy doesn't have an up-to-date client on your webserver. You'll not likely convince them to change their server configuration.

This and many other issues are frequent problems with GoDaddy hosting.

You'll probably need to rely on phpMyAdmin to do database exports.

[Stuff4Toys]

Ratz, Ratz, Ratz

Can you define "Up to Date" mysql client?

[DrByte]

Can you define "Up to Date" mysql client?

Compatible with both the version and the configuration of MySQL on the database server.

If you're thinking of trying to get them to change things, keep in mind that there are likely additional challenges beyond just the software versions, such as communication methods and so on.

[Stuff4Toys]

Ratz again. So how do I uninstall. I would hate to have someone think they are getting a backup when at this point it will not work. I can delete the files, do database tables need a change?

JOhn ><>

[DrByte]

Ratz again. So how do I uninstall. I would hate to have someone think they are getting a backup when at this point it will not work. I can delete the files, do database tables need a change?

JOhn ><>

Removing the files is all that's required.

[skydealer]

Wouldn't this work if he upgraded to a GoDaddy Virtual Dedicated server? It's more expensive than the typical hosting packages but it's a lot more up to date.

Plus, he could monitor his client's accounts (and do SQL backups) from his Plesk login.

[DrByte]

Wouldn't this work if he upgraded to a GoDaddy Virtual Dedicated server? It's more expensive than the typical hosting packages but it's a lot more up to date.

Plus, he could monitor his client's accounts (and do SQL backups) from his Plesk login.

Well there's one way to find out ... but I won't be spending a penny on GoDaddy hosting, let alone their more expensive services. It's just not worth it.

If someone who uses their services wants to test and provide feedback, that's fine.

[skydealer]

DrByte,

I'm guessing that the "Database Backup Manager" the original post talks about is your design? I tried finding the plugin but there was just too many threads that you contributed to!

I have to play the noob card and ask where the plugin is located & I'll see if I can get it to work on a GoDaddy server.

I know the cheapie hosting packages that GoDaddy has is horrible for things that are database related.

But I'm leasing a virtual dedicated server (mainly for a tech site that needed a vbulletin forum) and so I have lots of added space to try out things, if it helps!

[DrByte]

It's under the Admin Tools section, "Backup MySQL"
http://www.zen-cart.com/index.php?ma...products_id=81

It basically runs the server's mysqldump binary (via php's exec() function) with applicable parameters, dumping the database to a text file and then zipping it, leaving it in the admin/backups folder.
It has to have access to the mysqldump binary, a working mysql client, and be able to authenticate against the specified mysql server. It does the rest automatically.