[mythtv-users] New server problems

[Stephen Worthington]

On Wed, 22 Oct 2014 21:46:35 -0700, you wrote:

>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.

I have never done a partial restore, but from your description, the
problem might be that the schema is changed and the database needs to
be updated.  I found this in the mythconverg_restore.pl file:

------------
# $0 --partial_restore

Include the --with_plugin_data argument if you would like to keep the
data used by MythTV plugins.  Note that this approach cannot be used
to "merge" databases from different MythTV databases nor to import
recordings from other MythTV databases.

If you would like to do a partial/new-hardware restore and have
upgraded MythTV, you must first do a full restore, then start and exit
mythtv-setup (to upgrade the database), then create a backup, then
drop the database, then follow the instructions for doing a partial
restore with the new (upgraded) backup file.
------------

So I would suggest that you try following the instructions in the
second paragraph.