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.
Announcement
Collapse
No announcement yet.
Backing up database
Collapse
X
-
Originally posted by xiphoidPath 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
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&
Leave a comment:
-
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
Leave a comment:
-
Backing up database
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.Tags: None

Leave a comment: