Urgent: Where is the mysql backup dump file?

Discussion in 'General' started by vaio1, Jun 20, 2011.

  1. vaio1

    vaio1 ISPConfig Developer

    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?
  2. till

    till Super Moderator

    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.
  3. vaio1

    vaio1 ISPConfig Developer

    Ok I have LOST ALL!
  4. till

    till Super Moderator

    Dont you run daily full server backups?
  5. vaio1

    vaio1 ISPConfig Developer

    What do you mean with server backup? do you mean ISPConfig backup? Or something like Norton Ghost / Drive Image?
  6. falko

    falko Super Moderator

  7. vaio1

    vaio1 ISPConfig Developer

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

    till Super Moderator

  9. vaio1

    vaio1 ISPConfig Developer

    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 ?
  10. till

    till Super Moderator

    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.

Share This Page