<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><br class=""><div><blockquote type="cite" class=""><div class="">On Sep 23, 2015, at 3:52 PM, John P Poet <<a href="mailto:jppoet@gmail.com" class="">jppoet@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class=""><div class="gmail_quote"><div dir="ltr" class="">On Wed, Sep 23, 2015 at 1:58 PM Paul Stillwell <<a href="mailto:bigboi@wackywombats.com" class="">bigboi@wackywombats.com</a>> wrote:<br class=""></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word" class="">Hi,<div class=""><br class=""></div><div class="">I’m trying to build a new backend system. I backed up the database and then saved it on an external drive. I then installed a new hard drive and installed Fedora 22 and then installed mythtv from RPMFusion. I read this link <a href="https://www.mythtv.org/wiki/Backend_migration#Building_a_new_backend_to_replace_an_existing_machine" target="_blank" class="">https://www.mythtv.org/wiki/Backend_migration#Building_a_new_backend_to_replace_an_existing_machine</a> which basically said all I need to do after installing myth is to restore the backup. I tried to restore the backup with <a href="http://mythconverg_restore.pl/" target="_blank" class="">mythconverg_restore.pl</a> and I get an ‘Unable to connect to database’ error. Do I need to run the restore command with the —create_database option or should I do something else?</div></div></blockquote><div class=""><br class=""></div><div class="">Yes, you would need to create the DB. Also, if you have not done so, you need to get mysql daemon up and running -- set the password, etc. before the restore script will be able to write to the DB.</div><div class=""><br class=""></div><div class="">For example:</div><div class="">mysql> create user 'mythtv'@'192.168.1.%' identified by 'mythtv';</div><div class="">mysql> set password for 'mythtv'@'192.168.1.%' = password('mythtv'); </div><div class="">mysql> grant all on mythconverg.* to 'mythtv'@'192.168.1.%' identified by 'mythtv';</div><div class="">mysql> flush privileges;</div><div class=""><br class=""></div><div class="">Also remember to run (at least for Fedora):</div><div class="">$ mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql --user=root -p mysql</div><div class="">to get the timezone configured correctly.</div><div class=""><br class=""></div><div class="">John</div><div class=""><br class=""></div></div></div></div></blockquote></div><div class=""><br class=""></div>John, thanks for the info! OK, just so I have the steps right, it would look like this:<div class=""><br class=""></div><div class="">1. Enable the mariaBD service</div><div class="">2. Start the mariaDB service</div><div class="">3. Create the initial database by doing this: mysql -u root < mc.sql</div><div class="">4. Do the SQL steps above by doing this:</div><div class=""><blockquote type="cite" class=""><div dir="ltr" class=""><div class="gmail_quote"><div class="">mysql> create user 'mythtv'@'192.168.1.%' identified by 'mythtv';</div><div class="">mysql> set password for 'mythtv'@'192.168.1.%' = password('mythtv'); </div><div class="">mysql> grant all on mythconverg.* to ‘mythtv’@'192.168.1.%' identified by 'mythtv';</div></div></div></blockquote><blockquote type="cite" class=""><div dir="ltr" class=""><div class="gmail_quote"><div class="">mysql> flush privileges;</div></div></div></blockquote></div><div class=""><div dir="ltr" class=""><div class="gmail_quote"><div class="">5. Run the mysql_tzinfo… to get the timezone info correct</div><div class="">6. Run mythconverg_restore.pl to restore the database</div><div class=""><br class=""></div><div class="">Do those sound like the right steps? Did I miss anything? When I googled for this info I get some slightly different steps from <a href="https://www.mythtv.org/wiki/User_Manual:Initial_Installation#MythTV_database_setup" class="">https://www.mythtv.org/wiki/User_Manual:Initial_Installation#MythTV_database_setup</a> and from <a href="https://www.mythtv.org/wiki/MythTV-HOWTO_-_0.27#Red_Hat_Linux_and_Fedora" class="">https://www.mythtv.org/wiki/MythTV-HOWTO_-_0.27#Red_Hat_Linux_and_Fedora</a></div><div class="">I’m not sure which of those should be consulted when doing this. This is one of those processes that I do so infrequently that I have to look around each time I do it.</div><div class=""><br class=""></div><div class="">Paul</div><div class=""><br class=""></div></div></div></div></body></html>