mysqldump error need help

Discussion in 'Databases' started by topso, Sep 16, 2011.

0
  1. #1
    i wanna take a backup of my forum ( vbulletin )


    one of my forum has 3M post


    i trying to take backup

    i get this error

    mysqldump: Error 1317: Query execution was interrupted when dumping table `thread` at row: 1561928
    Code (markup):
    how can i fix that ?
     
    topso, Sep 16, 2011 IP
  2. AnthonyG

    AnthonyG Well-Known Member

    Messages:
    114
    Likes Received:
    3
    Best Answers:
    2
    Trophy Points:
    135
    #2
    Run a repair on that table, whats it report?
     
    AnthonyG, Sep 16, 2011 IP
  3. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #3
    How are you backing it up? If you're using PHP, the backup could be timing out.
     
    Rukbat, Sep 16, 2011 IP
  4. sbsl

    sbsl Well-Known Member

    Messages:
    122
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    163
    #4
    mysqldump is a commmand external to mysql, just run it from the commandline
     
    sbsl, Sep 20, 2011 IP
  5. akumar2

    akumar2 Peon

    Messages:
    30
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    ;) use mysql administrator..
     
    akumar2, Sep 20, 2011 IP
  6. kmap

    kmap Well-Known Member

    Messages:
    2,215
    Likes Received:
    29
    Best Answers:
    2
    Trophy Points:
    135
    #6
    use ssh to dump the database

    Regards

    Alex
     
    kmap, Sep 20, 2011 IP