Backing up Mysql and PHPBB

Discussion in 'Web Design & Coding' started by Heeter, Feb 15, 2006.

  1. Heeter

    Heeter Overclocked Like A Mother

    Messages:
    2,732
    Hi Guys,

    What would be the best way to backup my Webserver tower? Should I just copy the C:/ directories into a backup folder on another drive? Or onto a DVD? Or is there proggies that do it?
    Thanks in advance,

    Heeter
     
  2. kcnychief

    kcnychief █▄█ ▀█▄ █ Political User Folding Team

    Messages:
    16,948
    Location:
    Massachusetts
  3. Heeter

    Heeter Overclocked Like A Mother

    Messages:
    2,732
    Mysql, Apache, PHP, PHPBBForums


    Heeter
     
  4. kcnychief

    kcnychief █▄█ ▀█▄ █ Political User Folding Team

    Messages:
    16,948
    Location:
    Massachusetts
    Is it a PHPBB forum, with all those technologies implemented?
     
  5. Heeter

    Heeter Overclocked Like A Mother

    Messages:
    2,732
    Yes it is a phpBB forums

    Heeter
     
  6. kcnychief

    kcnychief █▄█ ▀█▄ █ Political User Folding Team

    Messages:
    16,948
    Location:
    Massachusetts
  7. Heeter

    Heeter Overclocked Like A Mother

    Messages:
    2,732
    Thanks a million, Bud, This is really gonna help.

    Have been concerned about backing up my webserver.

    Right on, D

    Heeter
     
  8. kcnychief

    kcnychief █▄█ ▀█▄ █ Political User Folding Team

    Messages:
    16,948
    Location:
    Massachusetts
    Glad it helped, good luck with the forum :)
     
  9. Electronic Punk

    Electronic Punk Administrator Staff Member Political User Folding Team

    Messages:
    18,590
    Location:
    Copenhagen, Denmark
    When I work on my localhost, I just stop the mysql services (via services.msc) and copy the entire folder out.

    Obviously can't do that here so use " mysqldump --opt > backup.sql "
    (be damn careful with that <> basically the arrow points in the direction of data flow -- easy to remember)
     
  10. Heeter

    Heeter Overclocked Like A Mother

    Messages:
    2,732
    Great, Thanks, EP.

    I should use that as well. not just through phpBB options.

    Thanks again,

    Heeter
     
  11. kcnychief

    kcnychief █▄█ ▀█▄ █ Political User Folding Team

    Messages:
    16,948
    Location:
    Massachusetts
    Is the SQL all you need to back up for VB?
     
  12. Electronic Punk

    Electronic Punk Administrator Staff Member Political User Folding Team

    Messages:
    18,590
    Location:
    Copenhagen, Denmark
    oops mixed the syntax, but virtuanews and vbulletin share the same database as they use some of the same tables.
     
  13. kcnychief

    kcnychief █▄█ ▀█▄ █ Political User Folding Team

    Messages:
    16,948
    Location:
    Massachusetts
  14. Heeter

    Heeter Overclocked Like A Mother

    Messages:
    2,732
    Right on, D.

    Thanks a lot, Bud.


    right up my alley.


    Thanks again,

    Heeter
     
  15. kcnychief

    kcnychief █▄█ ▀█▄ █ Political User Folding Team

    Messages:
    16,948
    Location:
    Massachusetts
    No problem man, hope it helps :)