Announcement

Collapse
No announcement yet.

DB backup

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

  • DB backup

    I just backed up my DB doing a SQL dump and the file, saved as "vbulletin.sql" was only 1.6MB. My board has about 2,200 members and about 50,000 posts.

    Does that file seem about right or does it seem too small?

    This is my first backup so I just want to make sure it worked okay.

    Thanks.

  • #2
    Originally posted by Mr H
    I just backed up my DB doing a SQL dump and the file, saved as "vbulletin.sql" was only 1.6MB. My board has about 2,200 members and about 50,000 posts.

    Does that file seem about right or does it seem too small?

    This is my first backup so I just want to make sure it worked okay.

    Thanks.
    No, that sounds too small to me. I have around 500 members and 50,000 posts, and my database is 20 MB.

    Did you use phpMyAdmin (bad) or SSH (good)?
    --filburt1, vBulletin.org/vBulletinTemplates.com moderator
    Web Design Forums.net: vB Board of the Month
    vBulletin Mail System (vBMS): webmail for your forum users

    Comment


    • #3
      Originally posted by filburt1
      No, that sounds too small to me. I have around 500 members and 50,000 posts, and my database is 20 MB.

      Did you use phpMyAdmin (bad) or SSH (good)?
      phpMyAdmin. I'm not sure what I'd have to type to do it in SSH.

      Comment


      • #4
        Originally posted by Mr H
        phpMyAdmin. I'm not sure what I'd have to type to do it in SSH.
        Click the link.
        --filburt1, vBulletin.org/vBulletinTemplates.com moderator
        Web Design Forums.net: vB Board of the Month
        vBulletin Mail System (vBMS): webmail for your forum users

        Comment


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

          And here is some more info:

          http://www.webmasterbase.com/article/678
          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


          • #6
            TelNet is insecure, you definitely want to use SSH. You will need an SSH client (search on Google for "putty ssh" or something) and your host should be able to tell you the exact path to mysql on your server. I could be wrong but I believe phpMyAdmin is limited to 2mb for downloads. Most PHP applications time out before they can get any kind of decent DB transfer.

            Comment


            • #7
              Originally posted by Mikhailtech
              TelNet is insecure, you definitely want to use SSH. You will need an SSH client (search on Google for "putty ssh" or something) and your host should be able to tell you the exact path to mysql on your server. I could be wrong but I believe phpMyAdmin is limited to 2mb for downloads. Most PHP applications time out before they can get any kind of decent DB transfer.
              My host doesnt not offer SSH or telnet access...

              Comment


              • #8
                Then unfortunately you will not be able to make reliable backups. I'd suggest finding a more suitable host.
                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

                widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                Working...
                X