HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   General (http://www.howtoforge.com/forums/forumdisplay.php?f=25)
-   -   Urgent: Where is the mysql backup dump file? (http://www.howtoforge.com/forums/showthread.php?t=53146)

vaio1 20th June 2011 17:34

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?

till 20th June 2011 19:13

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.

vaio1 20th June 2011 19:14

Ok I have LOST ALL!

till 20th June 2011 19:16

Dont you run daily full server backups?

vaio1 20th June 2011 20:47

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?

falko 21st June 2011 09:48

Quote:

Originally Posted by vaio1 (Post 258629)
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

vaio1 21st June 2011 09:50

No I don't use OpenVz. I have 4 physical Severs machine

till 21st June 2011 10:53

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

http://www.howtoforge.com/forums/showthread.php?t=41609

vaio1 21st June 2011 11:01

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 ?

till 21st June 2011 12:25

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.


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

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