Complete backup mysql

Discussion in 'MySQL' started by livewirerules, Sep 20, 2006.

0
  1. #1
    i need to backup my forum database.Im using phpbb as my forum.When i login to my phpbb APC it shows that the size of my database is 8mb but when i bankup my database through phpmyadmin i get only 5.43mb and loads of tables are missing.i tried to backup through the phpbb ACP but no use the database size is reduced to 2mb.
    What is the problem and how can i get a complete backup of my forum??

    i have moded my forum with hacks. and im running phpbb 2.0.21
     
    livewirerules, Sep 20, 2006 IP
  2. Galaxyrover

    Galaxyrover Well-Known Member

    Messages:
    179
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    103
    #2
    I used this nice shell scripts to backup and restore full site with mysql database.
    http://drupal.org/node/59369
    Works fine for me.
    But you will need SSH access to your host to launch the script.
     
    Galaxyrover, Sep 20, 2006 IP
  3. noppid

    noppid gunnin' for the quota

    Messages:
    4,246
    Likes Received:
    232
    Best Answers:
    0
    Trophy Points:
    135
    #3
    noppid, Sep 20, 2006 IP
    onlinedude likes this.
  4. livewirerules

    livewirerules Active Member

    Messages:
    276
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    58
    #4
    my hosting does not support SSH access. :( Is there any other way i can backup?
     
    livewirerules, Sep 20, 2006 IP
  5. noppid

    noppid gunnin' for the quota

    Messages:
    4,246
    Likes Received:
    232
    Best Answers:
    0
    Trophy Points:
    135
    #5
    Two posts up which includes how to execute the mysql backup commands from a cron job if you do not have ssh access.
     
    noppid, Sep 20, 2006 IP