View Single Post
Old 18th May 2017, 8:08 PM   #5785
daehenoc
Member
 
daehenoc's Avatar
 
Join Date: Nov 2005
Location: Mt Gravatt E, BNE, QLD
Posts: 2,047
Default

Something was totally toasted, that was for sure.

I fixed my situation like this:
Blow away all the files in /var/lib/mysql
run: mysqld --initialize-insecure
Set up the blank mythtv db: mysql -u root < /usr/share/mythtv/sql/mc.sql
update the password for the mythtv sql user to match the password in the sql backup and restore said backup:
./mythconverg_restore.pl --drop_database --create_database --filename ../bladeblabla/mythconverg-1317-datestamp.sql.gz --verbose
reinstall the TZ data: https://www.mythtv.org/wiki/MySQL_Time_Zone_Tables

and I can now run $ sudo setup-mythtv

holy crap. going to bed, will see what I've got tomorrow afternoon

Thanks for the help, HyRax!
daehenoc is offline   Reply With Quote