Announcement

Collapse
No announcement yet.

Backing up database

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Steve Machol
    replied
    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.

    Leave a comment:


  • hpisavagecom
    replied
    Originally posted by xiphoid
    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&

    Leave a comment:


  • Floris
    replied
    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:


  • hpisavagecom
    started a topic Backing up database

    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.
Loading...
Working...
X