Switch to upstream backup and restore scripts

Bug #469792 reported by Mario Limonciello
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
mythtv (Ubuntu)
Fix Released
Medium
Unassigned

Bug Description

Binary package hint: mythtv

<sphery> superm1: I heard you guys are using a *buntu-specific backup script. What do you think of adding --add-drop-table to the mysqldump options? Doing so should prevent the issues users are having when they restore a 0.21 schema version backup on top of a 0.22 schema database (the blank one installed by the packages)--which means they end up with 0.22 tables (because of the CREATE TABLE IF NOT EXISTS) with 0.21 data. (Or if you guys ...
<sphery> ... have a restore script, fix that so it checks to ensure the DB is empty before allowing the restore, like the one in programs/scripts/database does.)
<sphery> I'm considering adding --add-drop-table to the programs/scripts/database/mythconverg_backup.pl script.
<sphery> that way, even if they don't use the restore script, it will prevent issues
* rotorr has quit (Read error: 104 (Connection reset by peer))
* rotorr (<email address hidden>) has joined #mythtv
* Prost (<email address hidden>) has joined #mythtv
<superm1> sphery, well I think we are better switching to the upstream backup and restore scripts tbh
<superm1> it's a needless delta currently
<sphery> that would work, too... My main concern is getting the word out to users--I've seen this happen 4 times, now, and 2 of 3 hacked the schema 'til the upgrade completed, which means their data and schema is likely suspect)

MarcRandolph (mrand)
Changed in mythtv (Ubuntu):
importance: Undecided → Medium
milestone: none → lucid-alpha-1
status: New → Triaged
Revision history for this message
Mario Limonciello (superm1) wrote :

This has been fixed in the trunk packaging. It will be seen in the next 0.23 autobuilds trunk build available at http://www.mythbuntu.org/auto-builds. This bug will be automatically closed when a new build containing the fix is uploaded to the current development release (Lucid Lynx).

Changed in mythtv (Ubuntu):
status: Triaged → Fix Committed
milestone: lucid-alpha-1 → none
Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package mythtv - 0.23.0~trunk23567-0ubuntu1

---------------
mythtv (0.23.0~trunk23567-0ubuntu1) lucid; urgency=low

  * Bump builds to start with 0.23
  * debian/control:
    - Fix vcs-bzr
    - Update depends to include ttf-droid, ttf-liberation, and ttf-dejavu.
      (LP: #224114)
    - Drop quilt build-dep, it appears to be included w/ dh7
    - Bump standards version
  * Introduces stable pulseaudio support (In Theory! :)) (LP: #311328)
  * Print message to stdout for MythTV.pm (LP: #327406)
  * debian/patches:
    - Drop 16_hal_shutdown. No longer necessary after r23518.
  * Allow shutdowns when mythtv is running (LP: #174712)
    - Comes from upstream changeset r23455.
  * Mythbackend now supports the --user flag to drop permissions from
    upstream changeset r23521.
  * Use the upstart script from the upstream contrib directory instead.
    Now uses the --user flag to drop permissions. (LP: #445953)
  * Update 30_python26_transition for changes upstream.
  * mythtv-database.templates:
    - refer to the proper location for backups.
  * Switch to use the upstream backup scripts. (LP: #469792)
  * Helps with HDTV stuttering. (LP: #451394)
  * Drop old debian/myth-*.sh scripts since we now use dbus for shutdown
    and reboot etc.
  * Drop old debian/mythtv-backend.default. It's just available for upgrades.
  * Drop old debian/mythtv-backend.init initscript. We're only supporting
    upstart going forward with these builds.
  * Drop unnecessary patch, 02_settings_pro.dpatch
  * Drop unused patch, 23_video_device_symlinks.dpatch
  * Drop unused patch, 25_skiploop_option.dpatch
  * Convert packaging to dh7.
  * Convert packaging to source v3 (w/ quilt).
  * Add debian/README.source as a symlink to the quilt README.source
  * Convert all .files into .install.
  * Refresh patches as quilt format instead
  * Rewrite get-orig-source rules to parse the changelog for version info.
  * Drop any of the Top Secret Options build flags
  * Include a custom snippet for debian/rules mythtv packages in libmyth-dev.
  * Drop old, unused templates from debian/templates.
 -- Mario Limonciello <email address hidden> Tue, 16 Feb 2010 21:23:04 -0600

Changed in mythtv (Ubuntu):
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.