Is the Backup MySQL Database contibution working in v1.3?
https://www.zen-cart.com/downloads.php?do=file&id=7
Printable View
Is the Backup MySQL Database contibution working in v1.3?
https://www.zen-cart.com/downloads.php?do=file&id=7
Yes. .Quote:
Originally Posted by rued
Ok, thanks. :)
File Is Now In The Downloads Area
https://www.zen-cart.com/downloads.php?do=file&id=7
Great, thank you DrByte - this saves the day. :)
Thanks for posting this. I installed it, but when I attempt the backup I get the error:
Result code: 127
Error ERROR: Could not locate the MYSQLDUMP backup utility. BACKUP FAILED.
But mysqldump is right where it should be on my dreamhost linux host at /usr/bin/mysqldump . Any ideas what to try for a fix?
You did not say... did you go thru the checklist in the readme? (see caveats & addendum).Quote:
Originally Posted by ts232
Woody
Yep, I went through the list. I don't know how to find out if the caveats are what is tripping me up. I just found out that my host has the mod_security apache module enabled by default. Perhaps that's screwing things up. I'm going to try disabling it temporarily and see if it works.Quote:
Originally Posted by Woodymon
Nope that didn't fix it. For now I'm using mysqldump from the shell. Can't find any info about the mentioned security restrictions being implemented on my host. If anyone has any ideas I am all ears, otherwise I'll stick with the shell approach.Quote:
Originally Posted by ts232
I use:
http://www.dagondesign.com/articles/...backup-script/
You can run it from root and backup all databases.
When you installed or upgraded Zen Cart the pre-flight check (install wizard) should have indicated some of this.Quote:
Originally Posted by ts232
Go to Admin > Tools > Server Info to observe your server configuration [same as phpinfo()] and a little bit more info.
Woody
Also I meant to mention that if you have any questions regarding security restrictions implemented by your host then by all means you should contact your hosting provider :wink2:Quote:
Originally Posted by ts232
Woody
Good tip, thanks for your help. Dreamhost has an install instructions for the wizard that informs us to just ignore the pre-flight check results. :blush: Here's what I pulled out from the Server Info that might be relevant (based on what the Caveats in the install were). The only mentioned caveat that I couldn't find info on was possible restrictions on exec(), so I will bug my host about that unless someone here knows a way to check that.Quote:
Originally Posted by Woodymon
open_basedir no value no value
safe_mode Off Off
safe_mode_exec_dir no value no value
TS-Quote:
Originally Posted by ts232
Since "Dreamhost" managed your Zen Cart installation you should be forward your questions on to them.
Myself I recommend storeowners avoid the canned script/one-click/Fantastico type installation service and instead install the "Zen Cart way" (via zc_install). With the zc_install step-by-step method you learn about all the configuration details required for installation, basic database configuration information, directory paths, server specifications and many other details you will need to know later to "upgrade" your cart and apply various modifications/customizations. And with such info at hand you will be able to answer many of your own questions that come up later and therefore won't need to rely on your host so much for support, and for that matter the Zen Cart forums. Also throughout the zc_install process you are pointed to webpages with much useful and easy to understand help documentation that is a MUST read. Especially security information!
With the canned script install process you miss all this and more.
"The pros and cons of hitchhiking" :wink2:
Woody
Woody, your points are well taken. In defense of the one-click install however, it was a low cost way for me to check out zencart and realize what a great product it is compared to my creaking old oscommerce shop. Had it not been for the one-click I probably would not have taken the time to try installing yet another ecommerce system. ;)Quote:
Originally Posted by Woodymon
TS- I certainly understand and no defense needed. That is why closed with: "The pros and cons of hitchhiking". Or I could have said "there is no free lunch". In other words there are "opportunity costs" to ALL choices we make (inlcuding a cost to not making a choice).Quote:
Originally Posted by ts232
Woody
Quote:
Originally Posted by ts232
Please keep me posted on anything you find as I'm also on Dreamhost and would like to get the backup command working. Just an easier cleaner method then doing it manually.
-Wayne
I turned on the debug mode and am poking around with it now. Here's the debug trace on the problem. The mysqldump and mysql execs are in place on the (linux) server where my zencart install resides (takspeed.com), but I am guessing the problem lies on the sql server mysql.takspeed.com . I don't seem to have shell access to that server (using dreamhost) to check on that. Any ideas for where to look beyond this?
Code:Checking Path: /usr/bin/
Warning
Warning COMMAND FILES SELECTED:
Warning mysqlexe="/usr/bin/mysql"
Warning mysqldumpexe="/usr/bin/mysqldump"
Warning COMMAND: "/usr/bin/mysqldump" "--host=mysql.takspeed.com" "--user=xxxxxx" "--password=xxxxxx" --opt --complete-insert "--result-file=/home/takspeed/takspeed.com/shop/tsadmin/backups/db_zentakspeed-20060602104016.sql" zentakspeed 2>&1
Warning Result code: 127
Error valueA:
Error valueB:
Error ERROR: Could not locate the MYSQLDUMP backup utility. BACKUP FAILED.
Here is the fragment of code where the error is tripped, the result of 127 branch is where it is happening:
Code:if (file_exists(DIR_FS_BACKUP . $backup_file) && ($dump_results == '0' || $dump_results=='')) { // display success message noting that MYSQLDUMP was used
$messageStack->add_session('<a href="' . ((ENABLE_SSL_ADMIN == 'true') ? DIR_WS_HTTPS_ADMIN : DIR_WS_ADMIN) . 'backups/' . $backup_file . '">' . SUCCESS_DATABASE_SAVED . '</a>', 'success');
} elseif ($dump_results=='127') {
$messageStack->add_session(FAILURE_DATABASE_NOT_SAVED_UTIL_NOT_FOUND, 'error');
} else {
$messageStack->add_session(FAILURE_DATABASE_NOT_SAVED, 'error');
}
Hmmm... so when I extract the mysqldump command from the php script and run it from the command line it works fine (see below). So the problem must lie in the script wrapper. I'm not a php expert, any ideas?
Code:/usr/bin/mysqldump --host=mysql.takspeed.com --user=xxxxxx --password=xxxx --opt --complete-insert --result-file=/home/takspeed/takspeed.com/shop/tsadmin/backups/db_zentakspeed-20060602104016.sql zentakspeed
It's likely that the path to the mysqldump binary may be causing it, and instead the path should perhaps be left out.
mysqldump
instead of
/usr/bin/mysqldump
Either that, or the way the command is being sent isn't properly separating the command from its parameters...
Hmmm.. that doesn't do it either. I have switched to a zencart certified host from dreamhost, and have the same problem on the new host.Quote:
Originally Posted by DrByte
Just a note that may apply. Previously after installing the BU plugin on v1.26, and later on 1.30, when I first ran the tool I received the same errors reported below (unable to find binary and backup failed). However the backup still worked (successfully backed up my database, both to the server and downloaded to my client). I successfully tested restoring my db's with the backups.
Later I had my domain account moved to an upgraded server and then I did a fresh install of 1.3.0.1. The plugin installed on 1.3.0.1 without those errors. And works fine.
Apologies if you've already responded to the questions below, but in case not...
What are permissions on your /admin/backups folder?
Do you see the same errors when backing up to the server versus downloading backup (choosing "Download without storing on server")? I don't normally backup to my client using this tool but useful for testing.
Do you see these same errors if GZIP is enabled or not (in Zen Cart admin - Configuration > GZIP)? (shouldn't apply but you never know).
Woody
Just downloaded and installed v 1.2.0.10a onto Zencart v 1.3.0.1
I had no problems installing - I've used previous versions on versions 1.2x of Zencart with no problems whatsoever.
One small bug I have found with the new version is that if I backup to the server and click the 'No compression' radio button I get a .gzip file rather than an uncompressed file. If, however, I tick the 'Download without storing on the server' box I get an uncompressed file as expected.
Anyone else experienced this problem?
Great tool b.t.w. I never install Zencart without it.
Regards,
Alan
Yep same for me too!
I've gone back to an earlier version (around sept 05) and it works as it should.
While a lot of other stuff was probably fixed, this small quirk was introduced.
Permissions are 777 on admin/backups, and I get the same error no matter which combination of settings I use. This is hosted on camelot-hosting, so there shouldn't be anything weird with their setup.Quote:
Originally Posted by Woodymon
I tried downloading a fresh version of the mod and reinstalling and everything works! Not sure if there was some weirdness when I originally installed it on my old host, or if I messed it up somehow. Thanks for all the suggestions.
Yes. I am running Zen Cart 1.3.0.1 with backup_mysql_admin_plugin-1.2.1.0 (not A).Quote:
Originally Posted by duncanad
I cannot disable the compression radio button, no matter if backing up to server or if download to remote client..
Workaround: When I want to back up with compression off I just turn it off in Configuration > GZip Compression. Then I back up.
But I have found no reason to disable GZip. Instead of a 20.5MB DB I get a 2MB DB. ;)
Woody
i just installed this contrib... i went to tools and database backup but all it has there is a warning about not using SSL and a restore button... am i missing something??
Reading some of the posts below and the caveats in the readme, did you observe any security restrictions in effect which may be contributing to your issues?Quote:
Originally Posted by GazLuvsStace
Woody
yep... there was only 1 i was unsure of which isQuote:
Originally Posted by Woodymon
"open_basedir /home/httpd/vhosts/domainname/httpdocs:/tmp"
having no idea what that is... or no knowledge of server side stuff??
You don't see the Restore and Backup buttons? The security settings should not have impact on rendering of the admin page.Quote:
Originally Posted by GazLuvsStace
Can you provide a screenshot?
Which version of the Backup mod is installed?
Latest is 1.2.10a (last updated by DrByte on 01-10-06)
Recommend re-uploading the four files:
/admin/backup_mysql.php
/admin/includes/boxes/extra_boxes/backup_mysql_tools_dhtml.php
/admin/includes/extra_datafiles/backup_mysql.php
/admin/includes/languages/english/backup_mysql.php
Woody
Im using that version... hmm this contrib is for the latest release of zencart isnt it??? pretty sure i read that it was :S.Quote:
Originally Posted by Woodymon
anyways here is a SS
REMOVED PER REQUEST
Sorry to take so long to respond to replies to my post. Although I'm subscribed to this thread I don't seem to be receiving email notifications of new posts.
Anyway thanks for the responses.
When I checked my configuration GZip compression was set to 'Off' so this setting does not appear to affect how the backup operates.Quote:
Originally Posted by Woodymon
I quite agree. However it depends on how critical your data is - and how paranoid you are! By compresing the data there is a slight increase in the risk of corrupting the data. Larger backup files might be preferable to lost data. Anyway the engineer in me thinks if you are given the option then you should have that option.Quote:
Originally Posted by Woodymon
Not a big issue - and still an indespensible contribution.
Thanks,
Alan
I'm running backup_mysql_plugin_1.2.10 dated Jan 10, 2006, on Zen Cart v1.3.0.1
The "No Compression (Pure SQL)" radio button in the BU mod dialog is defectively sticky, after the first time I selected I have never been able to unselect. I've deemed it a bug and just worked around it by disabling and enabling Gzip from the admin config menu.
I was the same way, not compressing the DB at first. But after many imports and exports I am now just fine with compressing.
Woody
DrByte,
I have a renamed admin folder - When I installed it would seem the MySQL plugin couldnt find my backups dir anymore. (It exists, just under my new admin location.) I searched the file, and couldnt find any hard references. I also looked in config.php in admin/includes.
My problem was not only should
define('DIR_WS_ADMIN', '/store/xxx/');
define('DIR_WS_HTTPS_ADMIN', '/store/xxx/');
be changed, but ALSO:
define('DIR_FS_ADMIN', '/var/users/xyz/abc/htdocs/store/xxx/');
I dont know if this info might be useful to stick in the docs you have for it...
Fantastic work, thanks for the plugin!!!
Thanks very much for posting the solution to your backups issue with a renamed /admin ... this will help others who also are following the suggestion to rename the /admin for security purposes ... :smile:
The instructions regards to above, plus many more important instructions, are located in /docs/important_site_security_recommendations.htmlQuote:
Originally Posted by theodin
i get the following message when trying to backup:
0 => 'c:/apache2triad/mysql/bin/mysqldump.exe" "--host' is not recognized as an internal or external command,
does this mean the server is running "in strict safe_mode,
or with open.basedir restrictions in effect, or with restrictions against
using "exec()" commands. "
I have been using this mod successfully for about two months. But today I went to admin to make a backup and when i click admin/tools/backup mysql I get a blank page. I've tried this in both IE and Firefox with the same result. Any ideas whats going on and how to fix?
Jason
This would appear to be an issue with Windows and needing/not-needing double-quotes around command-line names vs parameters.Quote:
Originally Posted by tekram
I don't see it being an issue with safe-mode or basedir restrictions or exec().
It doesn't appear to be the typical windows problem with not allowing access to CMD.EXE, since you're not running a Server O/S.
A sudden change would typically suggest a change on the server side, usually related to permissions.Quote:
Originally Posted by brimsjewelry
It could be related to permissions on the /admin/backups folder
It could be corruption to the admin/includes/languages/english/backup_mysql.php file
It could be corruption to the /admin/backup_mysql.php file
I have installed the backup according to instructions but I recieve this error:
Result code: 1
0 => 'c:/Program' is not recognized as an internal or external command,
1 => operable program or batch file.
Failure: The database has NOT been saved.
I have changed to correct map in /admin/includes/languages/english/backup_mysql.php but still the same.
I am using XP and running the shop on my computer, it's not live yet. ZC1.3.0.2 and the swedish language pack.
Please, need help...
/Typhoon
Hi again ! :D
I think I have solved the problem above. If I changed in /admin/backup_mysql.php the following, for the $pathsearch variable (taking out the last part only...)
$pathsearch=array(.............. '\'c:/Program Files/MySQL/MySQL Server 5.0/bin/\'', '\'d:\\Program Files\\MySQL\\MySQL Server 5.0\\bin\\\'');
to
$pathsearch=array(.............. '\"c:/Program Files/MySQL/MySQL Server 5.0/bin/\"', '\'d:\\Program Files\\MySQL\\MySQL Server 5.0\\bin\\\'');
... changing from ' to " after the \ solves the error message above. If I do the same change in /admin/includes/languages/english/backup_mysql.php nothing happens. I don't know why but it's probably one step closer to solution..
Now, I have another message when I'm trying to do a backup...
Result code: 1
0 => 'mysqldump" "--host' is not recognized as an internal or external command,
1 => operable program or batch file.
Failure: The database has NOT been saved. :(
As you can see, it's the same problem as tekram have but I can't see any solution to this problem... Any solutions ?
Regards,
/Typhoon
I hate this but... bump...
I have searched around in this forum for simular problem but I havn't found any solutions for my problem. Please, anyone have any tips ?
/Typhoon
Is this for offline development or live hosting of your site?
For the moment it's local, on my server. within a month it will be "live"...
/Typhoon
Does it work properly on your "live" server? Or is it too soon to test?
I don't have any possibility to try the shop on a "live" server for the moment. Do you think that's the problem ? Do you think it will work when it's live ?
/T
Most likely, especially if it's not hosted on a Windows server (yuck!)Quote:
Originally Posted by Typhoon
The day I go "live", it will be on a window server, will it be "quote problems" you think ? Or is your addon "windows friendly" ? :D
/T
Ugh.
"friendly" ... as friendly as "windows" is in a hosting environment :P
Since every Windows server is configured differently, and since Windows has complicated security risks, it is a challenge to pre-anticipate every issue.
Try it on your live host and when the time comes, we'll deal with it then.
Keep in mind that if your host isn't willing to open up webserver access to cmd.exe, then this tool will most likely not work for you. Sorry... thank Bill.
Hi there !Quote:
Originally Posted by DrByte
You were very right, when I put my shop on my live host, the backup part is working just like it suppose to. Thanx.
/Typhoon
I am also getting this error:
Result code: 1
0 => 'mysqldump" "--host' is not recognized as an internal or external command,
1 => operable program or batch file.
Failure: The database has NOT been saved.
Is there no way to install ZC on Windows XP for local testing purposes?
I tried WAMP5 and got this error and now I have switched to XAMPP and get the same error. Anyone have a suggestion?
Thank you.
Yep. Exactly the same problem here. Doesn't work for me :( Same here! Still can't get it to work for me. Strange thing is that out of 20-odd attempts to backup without compression, 1 or 2 will work but the rest will be .gz. Me too! Intermittent faults are always the worst. It's just kindof unsettling when you know something doesn't work but you don't know why :unsure:
I have a development site on my local machine. if i try to use the backup command, i get the following error.
http://localhost/zenadmin/images/icons/warning.gif Result code: 1
http://localhost/zenadmin/images/icons/warning.gif 0 => 'c:/Program' is not recognized as an internal or external command,
http://localhost/zenadmin/images/icons/warning.gif 1 => operable program or batch file.
I should point out that it does work on the live site. Can you please help with a fix for the local environment.
Thanks
G'day,
If you're thinking of using something like this to backup your MySQL databases, then you might want to check out the excellent mySQLdumper at www.mysqldumper.de/en/.
mySQLdumper enables me to get regular backups of all of my MySQL databases sent via email or FTP file transfer.
mySQLdumper works so as to overcome the limitations people often come up against when trying to backup and/or restore larger databases.
It's pretty much a set and forget solution. Though I must admit it took me a while to set it up the first few times. I wrote myself a detailed step by step guide which you should be able to find either on the mySQLdumper forums, or on the forums at JaguarPC.
Best Regards, Lloyd Borrett.
I am trying to upgrade my cart to 1.3.6, but I've decided to start from a vanilla version of the current codebase. I just tried to install the latest version of the excellent database backup utility on my windows xp sp2 test box and I get a similar problem as other windows users :-
Warning 0 => 'c:/mysql/bin/mysqldump.exe" "--host' is not recognized as an internal or external command,
Warning 1 => operable program or batch file
However, I have an older version of this in contribution working on my 1.2.6 cart running, on the same windows test box. Any idea's ?.
It is pretty sad! I am a total beginner with no PHP, HTML, CSS, etc.
I am learning as i go, but there doesn't seem to be a great deal of support from those with the knowledge.....
The problem with this mode is: -
mqsqldump: - (backup)
Line 115, 116, 177, 129:
Original
$dump_params .= '" --host=' . DB_SERVER . '"';
New
$dump_params .= ' --host=' . DB_SERVER . '';
The original only works on linux/unix (i guess) the quotes don't work on windows.
Removes the quotes and the backup will function on both environments.
Mysql; - (restore)
Linux/Unix
$load_params .= ' "--host=' . DB_SERVER . '"';
Windows
$load_params .= ' --host=' . DB_SERVER . '';
Now i need your help! How do i make a switch to use quotes on linux/unix or no quotes on windows please.
I have successfully modified this mode to work on both linux and windows.
The only issue i have with it now is to get it to use gzip for windows.
I didn't seem to have much luck with that after many unsuccessful attempts.
I've set up a cron job to schedule a daily backup (using backup_mysql.php?action=backupnow) and it's working but the backup is made in an uncompressed file format.
Does anybody know what parameter should be included in the cron job to invoke gzip compression (backup_mysql.php?action=backupnow 'parameter')?
I would like to have the backups gzipped for the obvious reason of reducing size. Strange thing is that a manual backup using the admin interface does produce a gzip file. Even stranger because at initially I only had the option 'No Compression (Pure SQL)' and still it produced a gzip file.
Looking for a parameter to invoke gzip compression using the cron job I ran across this post by Woodyman.
This seemed to be the same issue I was having and made me realize something was missing in my setup.
Found out that within admin/includes/init_includes/init_gzip.php there are four paths defined for gzip and zip configs. Within backup_mysql.php these paths are checked and, once found correct, options 'Use GZIP' and 'Use ZIP' are added to the admin interface.
In my case changing the paths to:
/bin/gzip
/bin/gunzip
/usr/bin/zip
/usr/bin/unzip
made the options appear. Check with your hosting provider if these settings don't work for you. Hope this helps.
hi...
i'm sure this is a dumb question:
i've just installed this mod for the first time... i'm quite thankful as i've often worried about not having a recent enough backup...
i haven't tried to create a backup yet, but the option is in the admin window and such, so i'm confident.
I would just like to know where it will save my backup
it says:
/home/content/(some removed)html/admin/backups/
but where is the 'home' folder...
like i said, i'm sure it's a dumb question...thanks in advance.
d'oh.
i figured it out...
thanks so much Dr. Byte!
Hi all,
I have just made a clean install of zencart 1.3.7 in a new MySQL (Client API version 5.0.18) database. After installing the "Backup MySQL" module (BACKUP_MYSQL Admin Tool v1.3) but I get the following error when trying to make a back-up using gzip:
Warning Result code: 2
Warning 0 => /usr/bin/mysqldump: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Warning 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
Warning 2 => /usr/bin/mysqldump: Got error: 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client when trying to connect
Error Failure: The database has NOT been saved.
Is there anything I can do to make it work?
Kind regards and many thanks for your help,
Goshawk.
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.
Thank you DrByte for your quick response. I will take it up with my host. :)
HI, I am using my local test server - WinXP with WAMP and MYSQL 5
When I try and run the backup I get from the Admin:
http://192.168.0.250/store/admin/ima...ns/warning.gif Result code: 1
http://192.168.0.250/store/admin/ima...ns/warning.gif 0 => 'C:\wamp\mysql\bin\/mysqldump.exe" "--host' is not recognized as an internal or external command,
http://192.168.0.250/store/admin/ima...ns/warning.gif 1 => operable program or batch file.
http://192.168.0.250/store/admin/images/icons/error.gif Failure: The database has NOT been saved.
I edited the backup_mysql.php
define('LOCAL_EXE_MYSQL', 'c:\wamp\mysql\bin\mysql.exe');
define('LOCAL_EXE_MYSQLDUMP', 'c:\wamp\mysql\bin\mysqldump.exe');
If the problem is that WinXP is not letting the guest user run CMD.exe. Can you give me the (mysqldump.exe ...) command string so I can run it as a local scheduled task?
Then when I get ZenCart up and running on a Linux server I can set it back to default.
THANKS
JOhn ><>
@LibertyFlag:
I'm unable to connect to your web site. Meaning, I cannot see the screenshots you have posted. Perhaps posting them as an attachment of your next message should facilitate others to visualize what might of had happened (and if this error has not been covered yet). :wink2:
Anyone ever have the issue of the backup that goes to 101% and finishes immediately without actually backing up anything?
Sorry,
a question about Database backup.:blink:
Which is the advantage of Installing this addon compared to do the backup from phpAdmin interface?
If I can use phpAdmin by now, is there a best way or something to pay attention to backup zen database in order to eventually recover it ?
thanks
This contribution allows you to do backups of much larger databases.
Using phpMyAdmin may encounter a timeout on larger databases which take a lengthy time to prepare backups with. That's the primary benefit.
Please take at look at this list of errors arising when I try to use the Backup MySQL database module
I don't suppose anyone out there can shed some light on what might be causing this problem - it's troubling me greatly, so any guidance would be much appreciated?Quote:
0 => /usr/bin/mysqldump: unrecognized option `--result-file=/xxx/xxx/xxx/xx/www.xxxx/htdocs/xxx/xxx/admin/backups/db_DB285429-20070614200830.sql'
1 => /usr/bin/mysqldump Ver 6.6 Distrib 3.22.29, for sun-solaris2.7 (sparc)
2 => By Igor Romanenko, Monty, Jani & Sinisa. This software is in public Domain
3 => This software comes with ABSOLUTELY NO WARRANTY
4 =>
5 => Dumping definition and data mysql database or table
6 => Usage: /usr/bin/mysqldump [OPTIONS] database [tables]
7 =>
8 => -a, --all Include all MySQL specific create options
9 => -#, --debug=... Output debug log. Often this is 'd:t:o,filename`
10 => -?, --help Display this help message and exit.
11 => -c, --complete-insert Use complete insert statements.
12 => -C, --compress Use compression in server/client protocol
13 => -e, --extended-insert Allows utilization of the new, much faster
14 => INSERT syntax
15 => --add-drop-table Add a 'drop table' before each create
16 => --add-locks Add locks around insert statements
17 => --allow-keywords Allow creation of column names that are keywords
18 => --delayed-insert Insert rows with INSERT DELAYED
19 => -F --flush-logs Flush logs file in server before starting dump
20 => -f, --force Continue even if we get an sql-error.
21 => -h, --host=... Connect to host.
22 => -l, --lock-tables Lock all tables for read.
23 => -t, --no-create-info Don't write table creation info.
24 => -d, --no-data No row information.
25 => -O, --set-variable var=option
26 => give a variable a value. --help lists variables
27 => --opt Same as --add-drop-table --add-locks --all
28 => --extended-insert --quick --lock-tables
29 => -p, --password[=...] Password to use when connecting to server.
30 => If password is not given it's solicited on the tty.
31 => -P, --port=... Port number to use for connection.
32 => -q, --quick Don't buffer query, dump directly to stdout.
33 => -Q, --quote-names Quote table and column names with `
34 => -S, --socket=... Socket file to use for connection.
35 => -T, --tab=... Creates tab separated textfile for each table to
36 => given path. (creates .sql and .txt files).
37 => NOTE: This only works if mysqldump is run on
38 => the same machine as the mysqld daemon.
39 => -u, --user=# User for login if not current user.
40 => -v, --verbose Print info about the various stages.
41 => -V, --version Output version information and exit.
42 => -w, --where= dump only selected records; QUOTES mandatory!
43 => EXAMPLES: "--where=user='jimf'" "-wuserid>1" "-wuserid<1"
44 => Use -T (--tab=...) with --fields-...
45 => --fields-terminated-by=...
46 => Fields in the textfile are terminated by ...
47 => --fields-enclosed-by=...
48 => Fields in the importfile are enclosed by ...
49 => --fields-optionally-enclosed-by=...
50 => Fields in the i.file are opt. enclosed by ...
51 => --fields-escaped-by=...
52 => Fields in the i.file are escaped by ...
53 => --lines-terminated-by=...
54 => Lines in the i.file are terminated by ...
55 =>
56 => Possible variables for option --set-variable (-O) are:
57 => max_allowed_packet current value: 25165824
58 => net_buffer_length current value: 1047551
http://www.hosiery-online.net/catalo...cons/error.gif Failure: The database has NOT been saved.
BTW: It would seem that backups via PHPMyAdmin work OK. The Unix server is running MySQL 5.0.21
Your server's mysqldump binary doesn't support some of the required parameters.
You'll have to use a different method to do your database backups, perhaps via phpMyAdmin instead.
You might ask them to upgrade your MySQL version.Quote:
mysqldump Ver 6.6 Distrib 3.22.29, for sun-solaris2.7 (sparc)
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 referenceto 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)
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.Quote:
to the version of MySQL dump, rather than for the whole database?
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!!
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.
Is the reference to the version of MySQL dump, rather than for the whole database?[/QUOTE]Quote:
/usr/bin/mysqldump Ver 6.6 Distrib 3.22.29, for sun-solaris2.7 (sparc)
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
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.
zen cart 1.3.9h
plugin v1-4
help please. after trying to run backup getting this error:
thanksQuote:
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.
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
MySQL error code 137: No more records (read after end of file) - from here -> http://rackerhacker.com/2007/08/09/mysql-error-codes/Code:Result code: 137
0 => Killed
Failure: The database has NOT been saved.
---
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
Get above error on one of my domains. I have couple other zencarts on same server, mod works without error.Quote:
Access denied for user 'xxxxxx'@'localhost' (using password: YES) when trying to connect
Thoughts?
Thanks.
sph
www.prommart.com
Having same exact issue here: :lamo:Quote:
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.
-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.