Backup MySQL Database

Quote:

---

Originally Posted by 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?

Quote:

---

/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

Quote:

---

Originally Posted by 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/i...hp?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.

Quote:

---

Originally Posted by 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.