Error when attempting backup

[monkeyra]

When I attempt to backup the table using the Database->Backup Database option, I get this error:



Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/stdriver/public_html/gallery/adm-misc.php on line 1586

Have I screwed up my upgrade?

[Chuck S]

Have you specified the path to mysqldump and the backup directory? Is mysql on the same server as photopost?

[monkeyra]

I've just double checked with my hosts, and yep, path to mysqldump is correct: #

root@***** [~]# whereis mysqldump
mysqldump: /usr/bin/mysqldump /usr/share/man/man1/mysqldump.1.gz

And yep, the path to the backup directory is correct.

[monkeyra]

It now lets me click the backup function, then I get this:



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

/home/stdriver//usr/bin/mysqldump --opt -h localhost -ustdriver_photo -pPO11636 stdriver_gallery

Results:


Warning: Invalid argument supplied for foreach() in /home/stdriver/public_html/gallery/adm-misc.php on line 1614


You should double-check your .sql files to be sure the backup completed successfully.






Then I checked in the folder, but there wasnt a backup there.

[Chuck S]

Before lines 1585 and 1605 of adm-misc.php try adding this

$link = mysql_connect("$host:3306", "$mysql_user", "$mysql_password") or die ("I cannot connect to the PhotoPost database. [$php_errormsg]");
mysql_select_db("$database",$link)or die("Could not connect to PhotoPost database". mysql_error() );