[mythtv-users] MYSQL problems on upgrade to ubuntu 16.04

[Jack McGee]

On 08/30/2016 07:54 AM, Justin Alcorn wrote:
> What are the file sizes on those files? (ls -l)
>
> -- 
> Justin B. Alcorn
> PGP Fingerprint A36D D691 C5B0 BE15 5A2A AF49 AA1C 372C
>
> On Tue, Aug 30, 2016 at 8:35 AM, Jack McGee <jack at greendesk.net 
> <mailto:jack at greendesk.net>> wrote:
>
>     I believe MYSQL is installed correctly now and is running.
>
>
>     Now on database restore I get an error:
>
>     mythuser at amethi:/usr/share/mythtv$ perl mythconverg_restore.pl
>     <http://mythconverg_restore.pl>
>
>     ERROR: The specified backup file is empty or is not a file.
>     /mnt/media3/backups/mythtv/mythconverg-20160830021401.sql
>
>     and
>
>     mythuser at amethi:/usr/share/mythtv$ ls /mnt/media3/backups/mythtv/
>     mntmedia3backups mythconverg-1317-20160822074111.sql.gz
>     mythconverg-1317-20160826021401.sql.gz
>     mythconverg-1317-20160820021401.sql.gz
>     mythconverg-1317-20160823021401.sql.gz
>     mythconverg-1317-20160827021401.sql.gz
>     mythconverg-1317-20160821021401.sql.gz
>     mythconverg-1317-20160824021401.sql.gz
>     mythconverg-1317-20160828021401.sql.gz
>     mythconverg-1317-20160822021401.sql.gz
>     mythconverg-1317-20160825021401.sql.gz mythconverg-20160830021401.sql
>
>
>

I realized I needed to drop database first, since I reinstalled mythtv 
on this machine along the way.


mythuser at amethi:/usr/share/mythtv$ perl mythconverg_restore.pl 
--drop_database --create_database --filename 
mythconverg-1317-20160828021401.sql.gz

Successfully restored backup.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20160830/03c8cea0/attachment.html>