i can't backup my database

Discussion in 'vBulletin' started by adnanku, Sep 16, 2010.

  1. #1
    i can't find maintance > backup database in my administrator menu, why?
     
    adnanku, Sep 16, 2010 IP
  2. Chuckun

    Chuckun Well-Known Member

    Messages:
    1,161
    Likes Received:
    60
    Best Answers:
    2
    Trophy Points:
    150
    #2
    I have no answers for vBulletin (I don't use it), but you could just do a backup via phpMyAdmin >.< That is if nobody comes up with the solution you're after..

    It's just as easy too :)

    Chuckun
     
    Chuckun, Sep 16, 2010 IP
  3. adnanku

    adnanku Peon

    Messages:
    73
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    thanks, i'll try ...
     
    adnanku, Sep 16, 2010 IP
  4. -Aw-

    -Aw- Active Member

    Messages:
    319
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    80
    #4
    -Aw-, Sep 17, 2010 IP
  5. dragonbyte

    dragonbyte Peon

    Messages:
    98
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    If you are running vB4, the backup function is not there anymore.

    You can install MySQLDumper, it's easy, powerful and free ;)
     
    dragonbyte, Sep 18, 2010 IP
  6. dreamconception

    dreamconception Peon

    Messages:
    55
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Just use mysqldump in shell.

    Sometimes the dump is just too big for PHP to handle so it doesn't matter if you use vbulletin or phpMyAdmin. It will not work.

    Here's a link; tizag.com/mysqlTutorial/mysqlbackup.php

    Hope this can help you!
     
    dreamconception, Sep 18, 2010 IP
  7. scylla

    scylla Notable Member

    Messages:
    1,025
    Likes Received:
    33
    Best Answers:
    1
    Trophy Points:
    225
    #7
    no use mysqldumper, I have been telling people to use that since I first heard of it. Do not use phpmyadmin, I tried to restore a database that way and it failed. Thankfully I found mysqldumper before switching hosts. Many errors that you encounter via phpmyadmin like "wrong sytnax" blah blah blah... can all be avoided with mysqldumper, same backup was used on both mysqldumper & phpmyadmin. Phpmyadmin failed where mysqldumper did not, after that, it became the software of my choice.
     
    scylla, Sep 19, 2010 IP
  8. Chuckun

    Chuckun Well-Known Member

    Messages:
    1,161
    Likes Received:
    60
    Best Answers:
    2
    Trophy Points:
    150
    #8
    Phpmyadmin is perfect if you know what you're doing. As long as you export it correctly, and import it correctly then you'll have no problems.

    If you're not confident with it though, then I guess people're finding mysqldumper easier, so go for that :)
     
    Chuckun, Sep 19, 2010 IP
  9. dreamconception

    dreamconception Peon

    Messages:
    55
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #9
    Chuckun, you get problems when you have big databases, say 700 MB. phpMyAdmin simply can't handle that (because of limitations in PHP).

    I just use command line with mysqldump, however mysqldumper looks good from the quick overview.
     
    dreamconception, Sep 20, 2010 IP