Backup MySQL Database

blag:

Hi

I am puzzled by this: the database I created is defined by the host as being version 5.0.21 - I was given an option as to whether I wanted version 4 or version 5 of MySQL database, and chose version 5.

Is the reference to the version of MySQL dump, rather than for the whole database?> /usr/bin/mysqldump Ver 6.6 Distrib 3.22.29, for sun-solaris2.7 (sparc)[/QUOTE]
Yes, that was quoted from the utility's help text which you posted earlier. It has no reflection on the version of your database.

The contribution will backup v3.23, v4.x, and v5.x databases, as long as the mysqldump utility installed on the same webserver as your site matches the database engine version.

Perhaps ask your host two questions:

1. What versions of mysqldump are available on your server
2. What is the path where the mysqldump binary resides -- which matches the MySQL version your hosting plan is configured to use.
   (ie: maybe your host has multiple versions of MySQL installed, and the default path picked up by the plugin is grabbing the oldest one, thus causing you this trouble.)

If you cannot use the plugin because your server's resources are not up to date, you can easily do backups using phpMyAdmin instead.

How do I make a secure connection while using the "Download without storing on server* *(Safer via a secured HTTPS connection)" option?

Do I just type https: into the address bar instead of http:? Even when I do this I am still warned that I am sending info over an unencrypted connection.

Thanks,

Nate

One other dilemma: when I run the mod with the "No Compression (Pure SQL)" option selected I still get a gzipped file. Am I doing something wrong?

Thanks,

Nate

DrByte:

two possible causes:

1. your database server isn't localhost, and thus it cannot connect to remote server
2. your webserver's command-line configuration for mysql client isn't fully complete, hence the charset warnings etc.

These are common symptoms of clustered hosting setups where the server administrator hasn't considered the need for command-line tools to be available to access the database from the webserver.

Hopefully your host can handle the error and make the required corrections. You'll have to report the issue to them.

I am trying to use this Backup MySQL module on a shared hosting site on GoDaddy and getting the same error as Goshawk While the GoDaddy tech support team have tried to help me they seem to have run out of ideas.

1. MySQL 5.0 database is on a separate server. The server/version info tool reports the locations correctly, so ZenCart knows where the db resides.
2. the path to the MySQL client is shown as /usr/local/mysql-5.0/lib/. I tried putting that in the defines in admin/languages/english/backup_mysql.php. Same error.
3. I tried putting the base path /usr/local/mysql-5.0/lib/, and also /includes/ and /bin/ in place of /lib/, in the path search string in admin/backup_mysql.php. Same error.

What am I missing here? :frusty:

I've not yet seen a GoDaddy setup where this tool can be used, mostly because the client configuration doesn't seem to be able to talk to the database server -- typically a natural result of the database being hosted on a different computer.

Your best solution is to use phpMyAdmin and do database exports:
https://www.zen-cart.com/tutorials/index.php?article=103

qucik question regarding backup mysql plug in:
I have it installed and it backs up my database, but when I select pure sql, it still backs it up as sql.gz... why is this happening? is there a way I can backup pure sql incase I need ot restore?

I have removed the path information from the languages file and put it in the extra_datafiles/backup_mysql.php.
I assume this is ok?

Why?
I have two languages and so the defines were duplicated.
Since this info needs to be different on a local pc and a remote server, it was a bit annoying when (Beyond) Comparing folders and files of the language files between the two sites as it flagged up the difference in the language folder due to these language files.

I hope this add-on is core 2.0.

So, you've relocated it just so you have one less file to look at when comparing language files? And how often do you do language file comparisons on your site? Surely it's not daily, weekly, or even monthly!

Nevertheless, naturally you're free to customize your copy of the addon for your own purposes on your own sites.

Actually I am still customising my site and am continually comparing and uploading files from my local test pc to my server, and to a test remote server, and another version for developers to hack.

I would have thought the paths should be considered as configuration settings rather than a language variable.

torvista:

I would have thought the paths should be considered as configuration settings rather than a language variable.
Fair enough.
The addon was constructed with an intent to minimize the number of files involved. Most configurations never require any changes to those settings, so it's not really been an issue for the vast majority of users.

zen cart 1.3.9h
plugin v1-4
help please. after trying to run backup getting this error:

Result code: 2
Warning 0 => mysqldump: Got error: 1045: Access denied for user 'xxx'@'localhost' (using password: YES) when trying to connect
Error Failure: The database has NOT been saved.

thanks

I just moved a zencart to a new server. Now when I go to use the MySQL backup, I see the option to download as gzip is gone. I can only select pure SQL. Is this because of some different configuration on the new host or did something get broken during the move? (the pure sql option seems to have worked fine)

The gzip option is only presented if the feature is enabled on the server.

Ok, so they showed me how to enable it and they showed me that it is now working but it is still not an option on my backup.

Weird. If I back up to the server, I am getting a gzipped file even though the only button is for pure sql. But if I download to my computer then I am getting it as a pure sql and have no option for gzip.

So what I am really missing is the radio button to select the type I want, I guess. Anyone know why that would be?

Hello,

When backup, I'm gettin a message:

0 => Warning: mysqldump: Option '--set-variable' is deprecated. Use --variable-name=value instead.

How can I fix this?

BR, AR

 Result code: 137
 0 => Killed
 Failure: The database has NOT been saved.

MySQL error code 137: No more records (read after end of file) - from here -> http://rackerhacker.com/2007/08/09/mysql-error-codes/

This is a new one to me, ive been using this addon for 2+ years and never had an issue with it. Just upgraded to 1.4 and now Houston we have a problem.

Can anyone shed any light on this issue???

Cheers

Access denied for user 'xxxxxx'@'localhost' (using password: YES) when trying to connect

Get above error on one of my domains. I have couple other zencarts on same server, mod works without error.

Thoughts?

Thanks.

sph
https://www.prommart.com

Result code: 2
Warning 0 => mysqldump: Got error: 1045: Access denied for user 'xxx'@'localhost' (using password: YES) when trying to connect
Error Failure: The database has NOT been saved.
Having same exact issue here: :lamo:
-4 Zen Cart hosted on VPS
-2 of them upgraded from 1.3.8a to 1.3.9h
-1 has module installed and working just fine
-the other one is giving this error when I try to backup.

More related info:
PHP Version: 5.2.11 (Zend: 2.2.0)
Database Data Size: 6,912 kB
Database: MySQL 5.0.92-community
PHP Safe Mode: Off
MySql Version 5.0.92

I don't see the path to mysqldump on the info page, where can I see it? Even though I don't think that's the problem since the other site on same server is working just fine and I didn't change anything on the files.

If mysqldump is the problem, then it's ONLY a problem if it's an out-of-date version.

More likley your database user permissions are the problem. Your user doesn't have permissions to connect via 'localhost'.
Ask your host for help on solving the database-user credentials problem in MySQL.