[mythtv-users] mythconverg_restore.pl problem

Mike McMullin mmcmullin at cogeco.ca
Tue May 25 03:09:44 UTC 2010

On May 24, 2010 12:12:10 pm Michael T. Dean wrote:
> On 05/24/2010 11:29 AM, Mike McMullin wrote:
> > On May 23, 2010 07:37:19 pm Nick Rout wrote:
> >> On Mon, May 24, 2010 at 9:03 AM, Michael T. Dean wrote:
> >>> On 05/23/2010 04:46 PM, Mike McMullin wrote:
> >>>>    Exactly so.  BTW, what is the mythtv_0.23.0.sql file for?
> >>>> mc.sql sizes at 320 but that file sizes at 164534.
> >>>
> >>> That's a DB backup--likely created by some distro script.  Or it may be
> >>> some "blank" DB that they've customized with certain values to make
> >>> initial setup work better with their tools.
> >>
> >> on *buntu its part of the package mythtv-database
> >>
> >> nick at media:~$ dpkg -S /usr/share/mythtv/sql/mythtv_0.23.0.sql
> >> mythtv-database: /usr/share/mythtv/sql/mythtv_0.23.0.sql
> >
> >    So is this the file to use as opposed to the mc.sql file?
> No.  That backup is not an empty database schema.  You can only do a
> full restore if you have an empty (no tables or data of any sort) database.
> Since no one can figure out how to do this properly and since distros
> aren't modifying mc.sql to work properly with their configuration of
> MySQL, I'm doing an update to the restore script that doesn't use mc.sql
> and will likely have it done in the next day or 2.
> It will be available for download by anyone on any version of MythTV (as
> described at the top of
> http://www.mythtv.org/wiki/Database_Backup_and_Restore ), but it will
> likely only go into trunk.

  This is a big problem that I had with oS, bad tweaks that were not properly 
debugged.  Right now I have a number of issues with the upgrade and will work 
through them as fast as I can, and of course ask for some thought when I get 
lost.  Do you want a copy of that file sent to you directly so you can have a 
look at it?

More information about the mythtv-users mailing list