[mythtv-users] mythconverg database server migration

[Michael T. Dean]

On 03/30/2017 04:18 PM, Erik Karlin wrote:
> So, it turned out to be much more basic...out of disk space on the new
> server. After moving /var/lib/mysql and binding a new mount the database
> loads in about 6 minutes from a drop/recreate db. Just for the record
>
> $ gzip -l /nas/backup/mythconverg-1317-20170330073640.sql.gz
>           compressed        uncompressed  ratio uncompressed_name
>            120660857           730397588  83.5% /nas/backup/mythconverg-1317-20170330073640.sql
>
>
> I did go ahead and look at https://www.mythtv.org/wiki/Tune_MySQL and
> mysqltuner but this was once again a stupid-user-mistake.

Glad you figured it out--and that it wasn't something that required 
making huge changes to configuration.  It is interesting, though, that 
the mysql client (or server), didn't just error out and tell you that 
there was no space on the disk...

Mike