Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 1st June 2006, 09:48
mphayesuk mphayesuk is offline
Senior Member
 
Join Date: Sep 2005
Location: UK, East Midlands
Posts: 517
Thanks: 1
Thanked 3 Times in 3 Posts
Send a message via MSN to mphayesuk
Default My Backup List

I am running Suse 10 64bit and the following list is what I intend to backup on a daily basis for both standard backups and also a disaster recovery.

Disaster Recovery would be a total system crash and I re-install the system using the same passwords and configuration and then replace all files that I have modified.

List:

/etc/passwd
/etc/shadow
/etc/group
/srv/www
/home/admispconfig
/etc/apache2
/etc/proftpd.conf
/etc/proftpd_ispconfig.conf
/etc/ssh
/etc/postfix

Am I missing anything??

Thanks
Reply With Quote
Sponsored Links
  #2  
Old 1st June 2006, 10:32
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 36,373
Thanks: 833
Thanked 5,478 Times in 4,313 Posts
Default

I recommend to backup also:

/var/lib/mysql (your mysql databases)
/etc/gshadow (dont know if SuSE has this file too)

If you use mbox format for mail storage, backup also:

/var/spool/mail
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 1st June 2006, 11:11
mphayesuk mphayesuk is offline
Senior Member
 
Join Date: Sep 2005
Location: UK, East Midlands
Posts: 517
Thanks: 1
Thanked 3 Times in 3 Posts
Send a message via MSN to mphayesuk
Default

I use maildir so thats not a problem. Thanks for the information.

Will I need to temp stop any services in order to tar them. Like apache and ispconfig ect.... I thought I read in another post that you have to do some special commands to backup sql databases.

Thanks
Reply With Quote
  #4  
Old 1st June 2006, 17:23
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,743 Times in 2,577 Posts
Default

No, you don't need to stop services.

If you want to back up MySQL databases, I'd use this way: http://www.howtoforge.com/faq/6_3_en.html
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 1st June 2006, 23:15
sjau sjau is offline
Local Meanie
 
Join Date: Apr 2006
Location: Switzerland
Posts: 1,146
Thanks: 4
Thanked 55 Times in 51 Posts
Default

If you want to make backups for each individual mysql-db you can use that:

Quote:
#Dump new files
USER=root
PASSWORD=.........
HOST=localhost

for i in $(echo 'SHOW DATABASES;' | mysql -u$USER -p$PASSWORD -h$HOST|grep -v '^Database$'); do
mysqldump \
-u$USER -p$PASSWORD -h$HOST \
-Q -c -C --add-drop-table --add-locks --quick --lock-tables \
$i > /mysql_backup/$i.sql;
done;
Just alther the paramaters to what you need.
Reply With Quote
  #6  
Old 6th June 2006, 09:55
mphayesuk mphayesuk is offline
Senior Member
 
Join Date: Sep 2005
Location: UK, East Midlands
Posts: 517
Thanks: 1
Thanked 3 Times in 3 Posts
Send a message via MSN to mphayesuk
Default

Falko using the method described in your link, if I am reading it right this would require me to know the names of all the databases so if I have 100 customers each with 2 databases that would mean 200 mysql databases so I would need a method that would just backup all of them.....

I think the method left by sjau would do this without any human interaction ie if one night I have 200 databases then all of these would get backed up if on the next night there are 201 I dont need to alter any scripts the new database would get backed up. Am I right in thinking this???

Thanks
Reply With Quote
  #7  
Old 6th June 2006, 11:38
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,743 Times in 2,577 Posts
Default

Quote:
Originally Posted by mphayesuk
Falko using the method described in your link, if I am reading it right this would require me to know the names of all the databases so if I have 100 customers each with 2 databases that would mean 200 mysql databases so I would need a method that would just backup all of them.....
Yes, that right.

Quote:
Originally Posted by mphayesuk
I think the method left by sjau would do this without any human interaction ie if one night I have 200 databases then all of these would get backed up if on the next night there are 201 I dont need to alter any scripts the new database would get backed up. Am I right in thinking this???
That's also correct.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #8  
Old 6th June 2006, 11:55
mphayesuk mphayesuk is offline
Senior Member
 
Join Date: Sep 2005
Location: UK, East Midlands
Posts: 517
Thanks: 1
Thanked 3 Times in 3 Posts
Send a message via MSN to mphayesuk
Default

Do I need to backup /var/lib/mysql if I am going to include the code by sjau in my backup script.
Reply With Quote
  #9  
Old 6th June 2006, 12:33
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,743 Times in 2,577 Posts
Default

No, either back up using sjau's way, or back up /var/lib/mysql. Otherwise you back up the same data twice.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #10  
Old 6th June 2006, 12:35
mphayesuk mphayesuk is offline
Senior Member
 
Join Date: Sep 2005
Location: UK, East Midlands
Posts: 517
Thanks: 1
Thanked 3 Times in 3 Posts
Send a message via MSN to mphayesuk
 
Default

Are there any pros and cons of the two methods.

1) Will backing up /var/lib/mysql using tar and then restoring using tar get anything wrong corrupt data ect...

2) Which is the best method... what would you recommend.

Thanks
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Fedora Core 5 ISP, Major Problems jnolla HOWTO-Related Questions 33 6th June 2007 15:01
mail problem Mahir Installation/Configuration 16 24th April 2007 20:22
Logging in to isp config Jrdgames General 43 6th March 2006 19:04
ISPCONFIG installed :81 broke leadrescue Installation/Configuration 13 26th February 2006 16:59
Totally Confused?? :( kingtux Installation/Configuration 7 9th February 2006 22:14


All times are GMT +2. The time now is 12:51.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.