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. ...
14th June 2008, 12:28 AM #1
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.
IDG Tech News
18th June 2008, 10:05 PM #2
18th June 2008, 10:54 PM #3
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.
18th June 2008, 11:05 PM #4
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.
18th June 2008, 11:49 PM #5
If you use MySQL administrator then you can schedule database backups.
19th June 2008, 10:24 AM #6
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
20th June 2008, 01:17 AM #7
Please can you tell me the command please?
Originally Posted by SteveBentley
20th June 2008, 09:52 AM #8
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!
3rd July 2008, 12:45 AM #9
Thanks for the comments i am going to try these tomorrow
By training_needed in forum MIS Systems
Last Post: 14th July 2008, 02:13 PM
By HodgeHi in forum Windows
Last Post: 20th February 2008, 05:37 PM
By gwendes in forum How do you do....it?
Last Post: 13th November 2007, 10:06 AM
Last Post: 8th June 2006, 10:36 PM
Last Post: 23rd May 2006, 12:29 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)