Project

General

Profile

Feature #459

AutoBackup Database for Apps

Added by bigfoot65 almost 11 years ago. Updated almost 11 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
03/02/2010
Due date:
% Done:

0%

Description

This would be a feature to backup the database upon uninstall. This would allow for easier application upgrades. Currently it is being done via code in the install script. The example below is for Ampache.

INSTALL SCRIPT:
  1. Check for backup of old version database
    if [ -f /var/hda/web-apps/ampache.sql ]; then # Import old version database
    mysql -uampache -pampache ampache < /var/hda/web-apps/ampache.sql;
    else # Insert new version database
    mysql -uampache -pampache ampache < ampache.sql;
    fi
  2. New app install starts here

UNINSTALL SCRIPT:
mysqldump -uampache -pampache ampache > /var/hda/web-apps/ampache.sql;

History

#1 Updated by cpg almost 11 years ago

we should have a standard location for databases and perhaps a way to back them up with a timestamp (which could well become a separate feature - periodic backups).

i propose

/var/hda/db-backups

Also available in: Atom