Announcement

Collapse
No announcement yet.

Backing up database

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

  • 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.

  • #2
    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

    Comment


    • #3
      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&

      Comment


      • #4
        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.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment

        Loading...
        Working...
        X