RP 4.1: mysqldump error - adm-misc.php on line 684

[snoopy5]

Hi

RP 4.1 integrated with vb 3.82

I get an error when I try to make a backup in ACP/scan database/backup database:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /myabsolutepath/adm-misc.php on line 684

Both, Path to mysqldump: (/usr/bin/mysqldump) and directory to store backups is so correct.

Line 684 is:

while (list($table) = mysql_fetch_array($tables))

What can be the reason for this error?

[Chuck S]

Possibly your server does not allow this?

Content visible to verified customers only.

[snoopy5]

Originally Posted by Chuck S

Possibly your server does not allow this?

Content visible to verified customers only.

It does. I have many other photopost installations also integrated with vb on the sasme server and the backup works there..


When I click then nervertheless to do the backup, on the next screen I get the following error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /myabsolutepath/adm-misc.php on line 704
Command being used to execute dumps (specific tables are executed individually):

/usr/bin/mysqldump --opt -h mysql4.myname -udbmydatabase -pmypassword dbmydatabase

Results:


Warning: Invalid argument supplied for foreach() in /myabsolutepath/adm-misc.php on line 715

LIne 715 in admin-misc is

foreach($tables as $tablename)

[Chuck S]

I just did a complete database backup using the utility seems to work fine.

Your error seems to suggest an issue with that mysql_list_tables thing and the backup utility is the same exact backup utility in our other products no different has not changed since it was added.

I know the backup utility does not work on every last server.