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.

[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.

[skydealer]

Thanks.

Plugin was just installed into admin dir via CuteFTP.

Backup dir CHMOD to 777 (defaulted).

Results:
Result code 127
ERROR: Could not locate the MYSQLDUMP backup utility. BACKUP FAILED.

(PHP safe mode was on)





I went into Plesk and turned off PHP safe mode and I was able to do a proper dump. The SQL file opened nice in wordpad and I was able to mod things and then upload it. I changed a manufacturer name and then uploaded it & it updated the database fine!

I'm kind of paranoid about operating a site with php safemode disabled though. I hunt down spam kings and they tend to attack my sites every now and then, so I use ScanAlert to monitor my IPs and they freak out on the safe mode being turned off.

Nice mod! It took about 5 seconds to install. This may actually prove to be an easier workaround for me to populate fields in the database.

So it does work on a Godaddy VDS.

That may be an overkill for the original poster though, as GD's virtual dedicated servers are kind of expensive & not needed for the majority of ecommerce requirements. I lease one mainly for the wait_timeout requirements of a forum website.

[DrByte]

Some would say having to run a server in safe mode suggests poor security practices are in place, thus "requiring" safe mode as a catch-all. Definitely needed with systems that don't take security seriously though. Zen Cart will operate with it on or off, but some advanced functions will be crippled with it on. This backup plugin is one example.

Try turning safe mode on again and run the module in debug mode:
- click Backup
- now you have the sidebox that has another Backup button below the checkboxes.
- edit the URL and add &debug=ON to it, and press Enter
- now click Backup in the sidebox
- what new debug info is shown next to the error message ?

[skydealer]

Here's what was displayed when I ran it in debug mode with safemode back on. I edited the post to remove database names and passwords:
Checking Path: /usr/bin/
Checking Path: /usr/bin/mysql/
Checking Path: /usr/bin/
Checking Path: /usr/local/bin/
Checking Path: /usr/local/mysql/bin/
Checking Path: c:/mysql/bin/
Checking Path: d:/mysql/bin/
Checking Path: e:/mysql/bin/
Checking Path: c:/apache2triad/mysql/bin/
Checking Path: d:/apache2triad/mysql/bin/
Checking Path: e:/apache2triad/mysql/bin/
Checking Path: c:/server/mysql/bin/
Checking Path: c:/Program Files/MySQL/MySQL Server 5.0/bin/
Checking Path: d:\Program Files\MySQL\MySQL Server 5.0\bin\
Checking Path: c:/Program Files/MySQL/MySQL Server 4.1/bin/
Checking Path: /

COMMAND FILES SELECTED:
mysqlexe="mysql"
mysqldumpexe="mysqldump"

COMMAND: "mysqldump" "--host=localhost" "--user=**removed by skydealer**" "-- password==**removed by skydealer**" --opt --complete-insert "--result-file=/var/www/vhosts/=**removed by skydealer**.com/httpdocs/admin/backups/db_=**removed by skydealer**-20070831114545.sql" =**removed by skydealer** 2>&1
Result code: 127
valueA: valueB:
ERROR: Could not locate the MYSQLDUMP backup utility.
BACKUP FAILED.


----------------------------------
So it also looks in local directories for a mysqldump utility?