Backing up database

[hpisavagecom]

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.

[Floris]

Path is not correct I think.
Enter the pull path

When you login with your ftp client you are by default in the root of your home dir /

in here, mkdir backup, chmod 777 and then goto the admin control panel
instead of your path, enter
/home/savage/backup/forumbackup-02-17-2003.sql

[hpisavagecom]

Path is not correct I think.
Enter the pull path

When you login with your ftp client you are by default in the root of your home dir /

in here, mkdir backup, chmod 777 and then goto the admin control panel
instead of your path, enter
/home/savage/backup/forumbackup-02-17-2003.sql

I now get the following:

Warning: MySQL: Unable to save result set in /home/savage/public_html/forum/admin/db_mysql.php on line 93

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: SELECT * FROM adminlog
mysql error: Got error 127 from table handler

mysql error number: 1030

Date: Sunday 16th of February 2003 08:15:23 PM
Script: http://www.hpisavage.com/forum/forum/admin/backup.php
Referer: http://www.hpisavage.com/forum/admin...action=choose&

[Steve Machol]

First of all, the only reliable method of backing up and restoring a database is with shell access via telnet or ssh. Please see the instructions here:

http://www.vbulletin.com/manual/movingservers.html

Second, your adminlog table has crashed. Upload repair.php (it's in the 'extras' folder of the zip file) to your admin directory. Close your forums, then run it from your browser with this syntax:

http://www.yourdomain.com/forum/admin/repair.php?html=1&check=1

[Of course change the exact URL as appropriate for your forums.]

If everything reports 'Ok' then reopen your forums. If not, then run it again. The second time everything should report Ok. See if this fixes the problem.