View Full Version : Error when attempting backup
June 9th, 2005, 11:28 AM
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:
June 9th, 2005, 12:03 PM
Have you specified the path to mysqldump and the backup directory? Is mysql on the same server as photopost?
June 9th, 2005, 01:14 PM
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.
June 11th, 2005, 06:09 AM
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
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.
June 11th, 2005, 08:59 AM
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() );
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.