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

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 20th June 2011, 16:34
vaio1 vaio1 is offline
Senior Member
 
Join Date: Jul 2007
Location: Italy
Posts: 664
Thanks: 77
Thanked 12 Times in 7 Posts
Unhappy Urgent: Where is the mysql backup dump file?

Hi guys,

I am desperated! I have lost the data from my production db and I need the mysql dump file of my website. I have set the backup task in the ISPConfig control panel but I cannot see the dump file of all db of my web profile.

I have already get the /var/backup/1232.zip but I don't see the mysql dump.

Where is it?
Reply With Quote
Sponsored Links
  #2  
Old 20th June 2011, 18:13
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,072
Thanks: 826
Thanked 5,396 Times in 4,240 Posts
Default

The backup function is a website file backup. There is no backup function for databases in ispconfig implemented yet, as databases are not associated to a website.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 20th June 2011, 18:14
vaio1 vaio1 is offline
Senior Member
 
Join Date: Jul 2007
Location: Italy
Posts: 664
Thanks: 77
Thanked 12 Times in 7 Posts
Default

Ok I have LOST ALL!
Reply With Quote
  #4  
Old 20th June 2011, 18:16
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,072
Thanks: 826
Thanked 5,396 Times in 4,240 Posts
Default

Dont you run daily full server backups?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 20th June 2011, 19:47
vaio1 vaio1 is offline
Senior Member
 
Join Date: Jul 2007
Location: Italy
Posts: 664
Thanks: 77
Thanked 12 Times in 7 Posts
Default

Quote:
Dont you run daily full server backups?
What do you mean with server backup? do you mean ISPConfig backup? Or something like Norton Ghost / Drive Image?
Reply With Quote
  #6  
Old 21st June 2011, 08:48
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Quote:
Originally Posted by vaio1 View Post
Or something like Norton Ghost / Drive Image?
Something like this. If you use OpenVZ, you can use vzdump to create full backups of your machine: http://www.howtoforge.com/clone-back...ms-with-vzdump
__________________
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
  #7  
Old 21st June 2011, 08:50
vaio1 vaio1 is offline
Senior Member
 
Join Date: Jul 2007
Location: Italy
Posts: 664
Thanks: 77
Thanked 12 Times in 7 Posts
Default

No I don't use OpenVz. I have 4 physical Severs machine
Reply With Quote
  #8  
Old 21st June 2011, 09:53
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,072
Thanks: 826
Thanked 5,396 Times in 4,240 Posts
Default

For physical servers you can use a script like this one:

http://www.howtoforge.com/forums/showthread.php?t=41609
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #9  
Old 21st June 2011, 10:01
vaio1 vaio1 is offline
Senior Member
 
Join Date: Jul 2007
Location: Italy
Posts: 664
Thanks: 77
Thanked 12 Times in 7 Posts
Default

I have a multiserver setup and that script works only for one server, I remember well.
Anyway I have lost few information, this is lucky, and I am not really happy of this.

1. Does exist a way to backup all main information of these 4 servers and restore them in 10 minutes?

2. Does exist a simple way to schedule a complete backup of one or more servers ?
Reply With Quote
  #10  
Old 21st June 2011, 11:25
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,072
Thanks: 826
Thanked 5,396 Times in 4,240 Posts
 
Default

It does not matter how many server you use. The backup has always to be installed on every system. I dont see a reason why the above script shall not work on multiserver systems.

1) The time required to restore a backup depends mostly on your hardware. If your hardware is able to load and uncompress the amount of data (which might be hundreds of gigabytes) in 10 minutes, then yes. Otherwise it will take longer.

2) See my link to the backup script above. Beside that, there are a lot of other backup solutions available for linux servers. There are also several tutorials available on howtoforge.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
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
[The Perfect Spamsnake Ubuntu 10.10] - No mail relay, just errors. itsnedkeren HOWTO-Related Questions 2 20th February 2011 10:45
adding mail boxes kwickcut Server Operation 20 11th August 2010 01:02
Can't access to my website - after install problem pallermo Installation/Configuration 18 4th June 2010 13:29
rewrite url not work apache2+mod_rewrite mohamedtah Installation/Configuration 1 31st January 2009 13:00
Chroot SSH + ISPConfig Norman Installation/Configuration 27 26th March 2007 03:40


All times are GMT +2. The time now is 08:55.


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