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
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() );
|All times are GMT -5. The time now is 04:29 AM.|
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0