[mythtv-users] New server problems

[Mike Carron]

I've been trying to get a new server running with Mythbuntu 14.04.1 for 
the last few days and seem to be caught in an endless loop.

First attempt I ran the backend-setup completely and after completing it 
I restored a backup of my old server. Everything seemed to run fine but 
when it was finished the new server had the old server's URL and DB 
password and I was not able to change them. Running 
mythconverg_restore.pl --change_hostname did nothing. When I started the 
backend-setup again the old URL and DB password were still there. It 
seemed to me that by restoring the database from the old server I 
essentially made the new server a clone of the old. That makes sense but 
it isn't what I want to do.

Further reading of the mythconverg_restore.pl material in --help --help 
convinced me that a partial restore was what I really wanted. I don't 
mind reconfiguring everything so long as I can retain my recording rules 
and recordings ( I already copied all my recordings to the new server). 
What was not clear was whether I should do the partial restore before or 
after running the backend-setup. I've tried it both ways with no luck. 
If I run mythconverg_restore.pl --partial_restore before running the 
backend-setup it complains that the database is empty and instructs me 
to run the setup. When I try to run the setup I get the country/language 
screen and when I escape from that I see that setup wants to upgrade the 
schema from 1307 to 1317. I re-installed the complete system from 
scratch and tried running the backend-seup first. After completing it I 
tried to run mythconverg_restore.pl --partial_restore and got the same 
result, the script said the database was empty and instructed me to run 
the backend-setup again. The backend-setup reverted to the 
country/language screen again and when I escaped it once again wanted to 
upgrade the schema from 1307 to 1317. I allowed it to do the upgrade but 
when it finished all the data I had entered was gone.

For what it's worth, in this distro If I try to run mysql -u root -p I 
get a permission denied message even though mysql supposedly does not 
have a default root password.

-- 
mike