MYSQL Backup addon error

[pfabrick]

Thank you for your update. We actually have a dedicated server which is hosting this Zen Cart and the data base resides on this server as well. We have other Zen Carts on this server which are using this mod successfully, we just can't get this one to work.

As we can back up via phpMyAdmin, it's just nicer to use this mod in the admin.

[linnx]

My Backup button disappeared. This was a great util. Any idea why the button would disappear? The restore button is still there.

Thanks

[DrByte]

If the backup folder isn't writable, the button won't be shown.

[linnx]

It is writable. chmod 777 on it. And I double checked.

Thanks

[DrByte]

Okay, then either your server has PHP Safe Mode enabled, or the PHP exec() command has been disabled by the server administrator, or the backup directory specified in your admin configure.php file doesn't match the directory you think it's supposed to be using and therefore it sees that the specified directory doesn't exist.
Or the backup button image is corrupt and not displaying, and needs to be re-uploaded.

[Elijah]

ZC 1.3.7

I am getting an error as well when attempting to do a backup. I get "result code: 127" on the first line and "ERROR: Could not locate the MYSQLDUMP backup utility. BACKUP FAILED." on the second line.

I read "Note that LOCAL_EXE_MYSQL and LOCAL_EXE_MYSQL_DUMP are defined in the /admin/includes/languages/backup_mysql.php file." I don't, however, have a "backup_mysql.php" file in the languages folder. Should this have been created during the install of the mod or is this something that I need to create?

Thanks for your help.

[linnx]

Well I forwarded all the details to the host and he says it should work... he has no clue why it doesn't. I re-uploaded all the files.

[fourbit]

Howdy Doc,

I have been checking this site and couldn't find any problem with the backup directory or any of the settings on the server (checked with host).

I started looking at the code in the file backup_mysql.php .

Seems that this section is causing the issue.

// now let's display the backup/restore buttons below filelist

?>

              <tr>

                <td class="smallText" colspan="3"><?php echo TEXT_BACKUP_DIRECTORY . ' ' . DIR_FS_BACKUP; ?></td>

                <td align="right" class="smallText">

                    <?php if ( ($action != 'backup') && (isset($dir)) && !get_cfg_var('safe_mode') && $dir_ok == true ) {

                             echo '<a href="' . zen_href_link(FILENAME_BACKUP_MYSQL, 'action=backup'.(($debug=='ON')?'&debug=ON':'')) . (($tables_to_export!='')?'&tables='.str_replace(' ',',',$tables_to_export):'') . '">' .

                                   zen_image_button('button_backup.gif', IMAGE_BACKUP) . '</a>&nbsp;&nbsp;';

                          }

                          if ( ($action != 'restorelocal') && isset($dir) ) {

                             echo '<a href="' . zen_href_link(FILENAME_BACKUP_MYSQL, 'action=restorelocal'.(($debug=='ON')?'&debug=ON':'')) . '">' .

                                   zen_image_button('button_restore.gif', IMAGE_RESTORE) . '</a>';

                          } ?>

                </td>

              </tr>

With this code in particular " !get_cfg_var('safe_mode')" .

I changed it to " !ini_get('safe_mode')" . and all works fine.

Now, I'm not familiar with these two commands much. So, I'm still researching. But, all works fine, now.

Paul

[DrByte]

That suggests that you have safe-mode set to on in the server's default php.ini setting, but you're overriding it to turn it off via a localized domain-specific php.ini or .htaccess directive.

[fourbit]

Yep. Thanks Doc.

Safe_ mode is off Locally but, it is still on at the Master level. I always just look at the local values. Figuring that it's all well and good.

Don't have any idea why that host would want build the server with safe_mode on.

Anyhow, thanks again.

Paul