Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 11th May 2008, 07:50
Jrdgames Jrdgames is offline
Member
 
Join Date: Feb 2006
Location: USA East Coast
Posts: 71
Thanks: 11
Thanked 0 Times in 0 Posts
Default Backing up an ISPConfig server for OS reinstall

Hello I have a Ubuntu Breezy (I think) server which I have recently upgraded to Dapper (that wasn't easy). And I have been trying to use tightvnc so I can access the servers gui (installed gnome) without a user needing to be logged in at the console and now X (gnome? gdm?) won't start at all. So I was thinking with the new release of Hardy Heron 8.04LTS that I would backup all of the files needed by ISPConfig and then make a fresh install of Ubuntu and install all the new server packages and the new ISPConfig. The problem I have is that I know I need to backup:
/var/www (I remember reading something about needing the -p option when tarring this dir but I don't remember the whole command)
.shadow
.passwd

mysql dumps and more but if someone could give me a full list of directories, files and commands then I would be extremely grateful (I am not a very experienced command line user that is why I ask for the commands as well as the other info).

Also it's 12:50AM here so if I have omitted any necessary info please ask and I will try to get it for you.

Thank you in advance.
__________________
My Server Stats:
No servers currently working.
Reply With Quote
Sponsored Links
  #2  
Old 11th May 2008, 10:27
Leszek Leszek is offline
Senior Member
 
Join Date: Nov 2006
Location: Poland,Włocławek
Posts: 369
Thanks: 22
Thanked 42 Times in 35 Posts
Send a message via Skype™ to Leszek
Default

Have a look here: http://www.howtoforge.com/forums/showthread.php?t=2717
Reply With Quote
The Following User Says Thank You to Leszek For This Useful Post:
Jrdgames (15th May 2008)
  #3  
Old 11th May 2008, 19:07
Jrdgames Jrdgames is offline
Member
 
Join Date: Feb 2006
Location: USA East Coast
Posts: 71
Thanks: 11
Thanked 0 Times in 0 Posts
Default

Ok thanks I had seen that topic before but I was a little unsure as to where all the files without paths were but I believe I have found them now with some help from my second ispconfig server.

About the mysql dump, will this command:
Code:
mysqldump -h localhost -u [MySQL user, e.g. root] -p[database password] -c --add-drop-table --add-locks --all --quick --lock-tables [name of the database] > sqldump.sql
backup everything for ispconfig or do I need to run it for every database on the server? I would like to know because it says "[name of the database]".
__________________
My Server Stats:
No servers currently working.
Reply With Quote
  #4  
Old 12th May 2008, 20:45
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,752 Times in 2,582 Posts
Default

Quote:
Originally Posted by Jrdgames
About the mysql dump, will this command:
Code:
mysqldump -h localhost -u [MySQL user, e.g. root] -p[database password] -c --add-drop-table --add-locks --all --quick --lock-tables [name of the database] > sqldump.sql
backup everything for ispconfig or do I need to run it for every database on the server? I would like to know because it says "[name of the database]".
You need to run it for each database.
__________________
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
The Following User Says Thank You to falko For This Useful Post:
Jrdgames (15th May 2008)
  #5  
Old 13th May 2008, 01:06
Jrdgames Jrdgames is offline
Member
 
Join Date: Feb 2006
Location: USA East Coast
Posts: 71
Thanks: 11
Thanked 0 Times in 0 Posts
Default

Thank you, will the database users be preserved?(Probably a silly question but I just want to confirm)
__________________
My Server Stats:
No servers currently working.
Reply With Quote
  #6  
Old 13th May 2008, 12:49
Leszek Leszek is offline
Senior Member
 
Join Date: Nov 2006
Location: Poland,Włocławek
Posts: 369
Thanks: 22
Thanked 42 Times in 35 Posts
Send a message via Skype™ to Leszek
Default

No.They are stored in a different database (mysql) in a table called "user".
Reply With Quote
  #7  
Old 13th May 2008, 18:08
Jrdgames Jrdgames is offline
Member
 
Join Date: Feb 2006
Location: USA East Coast
Posts: 71
Thanks: 11
Thanked 0 Times in 0 Posts
Default

That would be db_ispconfig -> isp_isp_datenbank right? I see users and hashed passwords there, so with all of the databases backed up and all of the files in the linked post above backed up I shoul be able to safely re-install ubuntu right?
__________________
My Server Stats:
No servers currently working.
Reply With Quote
  #8  
Old 13th May 2008, 22:54
Leszek Leszek is offline
Senior Member
 
Join Date: Nov 2006
Location: Poland,Włocławek
Posts: 369
Thanks: 22
Thanked 42 Times in 35 Posts
Send a message via Skype™ to Leszek
Default

This is not enough because on a fresh installation of MySQL there will be only root user without users of databases that were created by ISPConfig.
Reply With Quote
  #9  
Old 14th May 2008, 00:13
Jrdgames Jrdgames is offline
Member
 
Join Date: Feb 2006
Location: USA East Coast
Posts: 71
Thanks: 11
Thanked 0 Times in 0 Posts
Default

Hmm, that makes sense, so where are the files I need to backup for the mysql users?
__________________
My Server Stats:
No servers currently working.
Reply With Quote
  #10  
Old 14th May 2008, 17:24
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,752 Times in 2,582 Posts
 
Default

It's the "mysql" database within the MySQL database.
__________________
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
The Following User Says Thank You to falko For This Useful Post:
Jrdgames (15th May 2008)
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
Post server reinstall can't access ISPConfig wxman Installation/Configuration 3 25th October 2007 15:37
subdomain and mail relay configuration aranthorn Installation/Configuration 24 3rd September 2007 23:53
Disable SSL on the ISPConfig Apache server lespaul49 Installation/Configuration 1 24th July 2007 15:15
Possible to install backup DNS or better backup whole ISPconfig server ? Snowman General 1 2nd May 2007 15:01
Web server and Mail server on 2 ispconfig adrenalinic Installation/Configuration 1 3rd September 2006 18:55


All times are GMT +2. The time now is 14:16.


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