When I try to backup my database ready for a move to a new server I receive the following error message:
Warning: fopen("./backup/forumbackup-02-16-2003.sql", "w") - No such file or directory in /home/savage/public_html/forum/admin/backup.php on line 264
DROP TABLE IF EXISTS access; CREATE TABLE access ( userid int(10) unsigned NOT NULL, forumid smallint(5) unsigned NOT NULL, accessmask smallint(5) unsigned NOT NULL, KEY userid (userid,forumid) );
Warning: fwrite(): supplied argument is not a valid File-Handle resource in /home/savage/public_html/forum/admin/backup.php on line 268
Dumping access
DROP TABLE IF EXISTS adminlog; CREATE TABLE adminlog ( adminlogid int(10) unsigned NOT NULL auto_increment, userid int(10) unsigned NOT NULL, dateline int(10) unsigned NOT NULL, script varchar(20) NOT NULL, action varchar(20) NOT NULL, extrainfo varchar(200) NOT NULL, ipaddress varchar(15) NOT NULL, PRIMARY KEY (adminlogid) );
Warning: MySQL: Unable to save result set in /home/savage/public_html/forum/admin/db_mysql.php on line 93
Any ideas on why?
I created a backup folder outside of my public_html, did a chmod 777 to the backup folder.
Used option 2 "Save data to file on server:" and entered the following:
./backup/forumbackup-02-16-2003.sql
Yet, I get the errors above.
Warning: fopen("./backup/forumbackup-02-16-2003.sql", "w") - No such file or directory in /home/savage/public_html/forum/admin/backup.php on line 264
DROP TABLE IF EXISTS access; CREATE TABLE access ( userid int(10) unsigned NOT NULL, forumid smallint(5) unsigned NOT NULL, accessmask smallint(5) unsigned NOT NULL, KEY userid (userid,forumid) );
Warning: fwrite(): supplied argument is not a valid File-Handle resource in /home/savage/public_html/forum/admin/backup.php on line 268
Dumping access
DROP TABLE IF EXISTS adminlog; CREATE TABLE adminlog ( adminlogid int(10) unsigned NOT NULL auto_increment, userid int(10) unsigned NOT NULL, dateline int(10) unsigned NOT NULL, script varchar(20) NOT NULL, action varchar(20) NOT NULL, extrainfo varchar(200) NOT NULL, ipaddress varchar(15) NOT NULL, PRIMARY KEY (adminlogid) );
Warning: MySQL: Unable to save result set in /home/savage/public_html/forum/admin/db_mysql.php on line 93
Any ideas on why?
I created a backup folder outside of my public_html, did a chmod 777 to the backup folder.
Used option 2 "Save data to file on server:" and entered the following:
./backup/forumbackup-02-16-2003.sql
Yet, I get the errors above.
Comment