+ Post New Thread
Results 1 to 9 of 9
How do you do....it? Thread, Backing up Apache2Traid in Technical; Hi guys & girls I am using symantec backup exec 11D to backup the school webserver. The server runs apche2triad. ...
  1. #1

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,826
    Thank Post
    875
    Thanked 1,675 Times in 1,458 Posts
    Blog Entries
    12
    Rep Power
    444

    Backing up Apache2Traid

    Hi guys & girls

    I am using symantec backup exec 11D to backup the school webserver. The server runs apche2triad. so far I have only been backing-up the apache2triad folder where all the websites and databases live. I am running Edugeek Joomla for the website, what happens if the server dies how can I get the database up and running again? Do I need to be backing something else up?

    Your advice is appreciated.

    z

  2. #2

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,826
    Thank Post
    875
    Thanked 1,675 Times in 1,458 Posts
    Blog Entries
    12
    Rep Power
    444
    ^^^bump^^^

  3. #3

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,114
    Thank Post
    403
    Thanked 619 Times in 566 Posts
    Rep Power
    180
    If you backup the database then you can restore the database again should you need to. You will however need a full backup of the database; I'm not sure what it is that you're backing up?

    Apache2Triad comes with phpMyAdmin so you could use this to create a complete backup of the database and then save this to an area on the webserver and then include this area in the backup that you make with Symantec.

  4. #4

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,826
    Thank Post
    875
    Thanked 1,675 Times in 1,458 Posts
    Blog Entries
    12
    Rep Power
    444
    The thing is I don’t want to keep doing it manually as I will forget plus I will be away for a month shortly so unable to do it. I would like it to be done automatically.

  5. #5

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,114
    Thank Post
    403
    Thanked 619 Times in 566 Posts
    Rep Power
    180
    If you use MySQL administrator then you can schedule database backups.

  6. Thanks to Edu-IT from:

    FN-GM (18th June 2008)

  7. #6
    SteveBentley's Avatar
    Join Date
    Jun 2007
    Location
    Yorkshire
    Posts
    1,431
    Thank Post
    119
    Thanked 263 Times in 189 Posts
    Rep Power
    72
    The command line mysqldump.exe will let you dump the whole lot to a text file, and that can called from a batch file and run as a scheduled task

  8. #7

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,826
    Thank Post
    875
    Thanked 1,675 Times in 1,458 Posts
    Blog Entries
    12
    Rep Power
    444
    Quote Originally Posted by SteveBentley View Post
    The command line mysqldump.exe will let you dump the whole lot to a text file, and that can called from a batch file and run as a scheduled task
    Please can you tell me the command please?

    thanks

  9. #8
    SteveBentley's Avatar
    Join Date
    Jun 2007
    Location
    Yorkshire
    Posts
    1,431
    Thank Post
    119
    Thanked 263 Times in 189 Posts
    Rep Power
    72
    My mysql instance is on a Mac, so this is the Unix variant, but it should be similar/identical

    mysqldump -u username --password=password --all-databases > path-to-file.sql

    The main gotcha is to make sure the username and password you supply have sufficient rights to be able to read everything, but not too many rights that you would be uncomfortable putting the password in plain text, ie don't use root!

  10. #9

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,826
    Thank Post
    875
    Thanked 1,675 Times in 1,458 Posts
    Blog Entries
    12
    Rep Power
    444
    Thanks for the comments i am going to try these tomorrow

SHARE:
+ Post New Thread

Similar Threads

  1. Backing up SIMS.net
    By training_needed in forum MIS Systems
    Replies: 22
    Last Post: 14th July 2008, 01:13 PM
  2. Replies: 7
    Last Post: 20th February 2008, 04:37 PM
  3. backing up
    By gwendes in forum How do you do....it?
    Replies: 7
    Last Post: 13th November 2007, 09:06 AM
  4. Backing up SQL database ?
    By Kyle in forum Windows
    Replies: 4
    Last Post: 8th June 2006, 09:36 PM
  5. Mac software for backing up DVDs
    By dagza in forum Mac
    Replies: 14
    Last Post: 23rd May 2006, 11:29 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •