Backup MySQL Database

[DrByte]

mysqldump Ver 6.6 Distrib 3.22.29, for sun-solaris2.7 (sparc)

You might ask them to upgrade your MySQL version.
v3.22 is very old.
I think the backup contribution was written based on v3.23 minimum, and is compatible thru to v5.x

[blag]

You might ask them to upgrade your MySQL version.
v3.22 is very old.
I think the backup contribution was written based on v3.23 minimum, and is compatible thru to v5.x

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

/usr/bin/mysqldump Ver 6.6 Distrib 3.22.29, for sun-solaris2.7 (sparc)

to the version of MySQL dump, rather than for the whole database?

[TheOracle]

to the version of MySQL dump, rather than for the whole database?

v3.22 for mySQL is said as is. Indeed, this is very old and would be recommended to send a support ticket to your web hosting service requesting an upgrade to the latest version released from mySQL manufacturer.

[blag]

v3.22 for mySQL is said as is. Indeed, this is very old and would be recommended to send a support ticket to your web hosting service requesting an upgrade to the latest version released from mySQL manufacturer.

I am sorry to appear to be really dense, but the host is adamant that my zen cart databse files are in a MySQL database and the version is 5.0.21.

Without wishing to be a pain - since they are adamant that this is the case - is the Distrib value of 3.22.29 referring to the mysqldump 'software'?

I have asked fo an 'upgrade' but I am unsure as to what I am sking to be upgraded!

bTW: It is worth noting that the Zen Cart server information enquiry output states that the mysQL version is 5.0.21!!

[TheOracle]

Perhaps this is about some kind of partial upgrade here since I don't see how a complete upgrade would contain two different version from one command file to another. All versions should be equally constant under each mySQL releases normally.

[DrByte]

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.

[bgroup99]

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

[bgroup99]

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