Error when attempting backup
 

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? :confused:

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

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.

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.

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() );