<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On Aug 5, 2018, at 10:03 AM, Daryl McDonald <<a href="mailto:darylangela@gmail.com" class="">darylangela@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">Greetings Mythizens, I've rebuilt after a drive failure, and I'm having trouble restoring the database. I downloaded the back-up and restore files<div class=""><br class=""></div><div class=""><div class="">daryl@trieli:~$ chmod a+x <a href="http://mythconverg_backup.pl/" class="">mythconverg_backup.pl</a> <a href="http://mythconverg_restore.pl/" class="">mythconverg_restore.pl</a></div><div class="">daryl@trieli:~$ <a href="http://mythconverg_restore.pl/" class="">mythconverg_restore.pl</a> --drop_database --create_database --filename mythconverg-1344-20180804112717.sql.gz</div><div class=""><a href="http://mythconverg_restore.pl/" class="">mythconverg_restore.pl</a>: command not found</div><div class="">daryl@trieli:~$ <a href="http://mythconverg_restore.pl/" class="">mythconverg_restore.pl</a> --directory/home/daryl --drop_database --create_database --filename mythconverg-1344-20180804112717.sql.gz</div><div class=""><a href="http://mythconverg_restore.pl/" class="">mythconverg_restore.pl</a>: command not found</div><div class="">daryl@trieli:~$ cd /home/dary/</div><div class="">bash: cd: /home/dary/: No such file or directory</div><div class="">daryl@trieli:~$ cd Home</div><div class="">bash: cd: Home: No such file or directory</div><div class="">daryl@trieli:~$ ls -al</div><div class="">total 52180</div><div class="">drwxr-xr-x 18 daryl daryl 4096 Aug 5 09:40 .</div><div class="">drwxr-xr-x 4 root root 4096 Aug 5 09:21 ..</div><div class="">-rw------- 1 daryl daryl 146 Aug 5 08:37 .bash_history</div><div class="">-rw-r--r-- 1 daryl daryl 220 Aug 5 07:36 .bash_logout</div><div class="">-rw-r--r-- 1 daryl daryl 3771 Aug 5 07:36 .bashrc</div><div class="">drwx------ 18 daryl daryl 4096 Aug 5 08:39 .cache</div><div class="">drwx------ 16 daryl daryl 4096 Aug 5 08:50 .config</div><div class="">drwxr-xr-x 2 daryl daryl 4096 Aug 5 07:59 Desktop</div><div class="">drwxr-xr-x 2 daryl daryl 4096 Aug 5 07:59 Documents</div><div class="">drwxr-xr-x 2 daryl daryl 4096 Aug 5 08:50 Downloads</div><div class="">-rw-r--r-- 1 daryl daryl 8980 Aug 5 07:36 examples.desktop</div><div class="">drwx------ 2 daryl daryl 4096 Aug 5 08:27 .gconf</div><div class="">drwx------ 3 daryl daryl 4096 Aug 5 08:32 .gnupg</div><div class="">-rw------- 1 daryl daryl 636 Aug 5 08:32 .ICEauthority</div><div class="">drwxr-xr-x 7 daryl daryl 4096 Aug 5 08:51 .kodi</div><div class="">drwx------ 3 daryl daryl 4096 Aug 5 07:59 .local</div><div class="">drwx------ 5 daryl daryl 4096 Aug 5 08:33 .mozilla</div><div class="">drwxr-xr-x 2 daryl daryl 4096 Aug 5 07:59 Music</div><div class="">-rw-r--r-- 1 daryl daryl 53170263 Aug 4 11:27 mythconverg-1344-20180804112717.sql.gz</div><div class="">-rwxrwxr-x 1 daryl daryl 59103 Aug 5 09:39 <a href="http://mythconverg_backup.pl/" class="">mythconverg_backup.pl</a></div><div class="">-rwxrwxr-x 1 daryl daryl 68814 Aug 5 09:40 <a href="http://mythconverg_restore.pl/" class="">mythconverg_restore.pl</a></div><div class="">drwxr-xr-x 2 daryl daryl 4096 Aug 5 07:59 Pictures</div><div class="">drwx------ 3 daryl daryl 4096 Aug 5 08:39 .pki</div><div class="">-rw-r--r-- 1 daryl daryl 675 Aug 5 07:36 .profile</div><div class="">drwxr-xr-x 2 daryl daryl 4096 Aug 5 07:59 Public</div><div class="">-rwxrwxr-x 1 daryl daryl 1107 Oct 23 2014 shortlog.sh</div><div class="">-rw-r--r-- 1 daryl daryl 0 Aug 5 08:01 .sudo_as_admin_successful</div><div class="">drwxr-xr-x 2 daryl daryl 4096 Aug 5 07:59 Templates</div><div class="">drwxr-xr-x 2 daryl daryl 4096 Aug 5 07:59 Videos</div><div class="">-rwxrwxr-x 1 daryl daryl 555 Sep 24 2016 wakeup_test.sh</div><div class="">-rw------- 1 daryl daryl 51 Aug 5 08:31 .Xauthority</div><div class="">-rw------- 1 daryl daryl 82 Aug 5 08:31 .xsession-errors</div><div class="">-rw------- 1 daryl daryl 1228 Aug 5 08:31 .xsession-errors.old</div></div></div></div></blockquote><div><br class=""></div><div>You can run this by doing perl mythconverg……… </div><div><br class=""></div><div> the ‘errors’ you are seeing is that your home directory is NOT in your path. The rest of the commands look fine.</div><div><br class=""></div><div><br class=""></div><div><br class=""></div><br class=""><blockquote type="cite" class=""><div class=""><div dir="ltr" class=""><div class=""><div class="">daryl@trieli:~$ <a href="http://mythconverg_restore.pl/" class="">mythconverg_restore.pl</a> --drop_database --create_database --filename mythconverg-1344-20180804112717.sql.gz</div><div class=""><a href="http://mythconverg_restore.pl/" class="">mythconverg_restore.pl</a>: command not found</div><div class="">daryl@trieli:~$ ./<a href="http://mythconverg_restore.pl/" class="">mythconverg_restore.pl</a> --drop_database --create_database --filename mythconverg-1344-20180804112717.sql.gz</div><div class=""><br class=""></div><div class="">ERROR: DBBackupDirectory not specified, stopped at ./<a href="http://mythconverg_restore.pl/" class="">mythconverg_restore.pl</a> line 773.</div><div class="">daryl@trieli:~$ ./<a href="http://mythconverg_restore.pl/" class="">mythconverg_restore.pl</a> --drop_database --create_database --directory ~ --filename mythconverg-1344-20180804112717.sql.gz</div><div class="">DBI connect('host=:database=mythconverg','',...) failed: Access denied for user 'daryl'@'localhost' (using password: NO) at ./<a href="http://mythconverg_restore.pl/" class="">mythconverg_restore.pl</a> line 933.</div><div class="">DBI connect('host=','',...) failed: Access denied for user 'daryl'@'localhost' (using password: NO) at ./<a href="http://mythconverg_restore.pl/" class="">mythconverg_restore.pl</a> line 933.</div><div class=""><br class=""></div><div class="">Unable to connect to database.</div><div class=""> database: mythconverg</div><div class=""> host: </div><div class=""> username: </div><div class="">To see the password used, please re-run the script with the --verbose</div><div class="">argument.</div><div class=""><br class=""></div><div class="">Please check your configuration files to verify the database connection</div><div class="">information is correct. The files that are used to retrieve connection</div><div class="">information are prefixed with "parsing" in the "Parsing configuration files"</div><div class="">section of the --verbose output.</div><div class=""><br class=""></div><div class="">Also note that any [client] or [mysql] password specified in the MySQL options</div><div class="">file (/etc/my.cnf or /etc/mysql/my.cnf or ~/.my.cnf) will take precedence over</div><div class="">the password specified in the MythTV configuration files.</div><div class=""><br class=""></div><div class="">ERROR: Unable to connect to database.</div></div><div class=""><br class=""></div><div class="">I would appreciate any help getting this fixed. Daryl</div></div>
_______________________________________________<br class="">mythtv-users mailing list<br class=""><a href="mailto:mythtv-users@mythtv.org" class="">mythtv-users@mythtv.org</a><br class="">http://lists.mythtv.org/mailman/listinfo/mythtv-users<br class="">http://wiki.mythtv.org/Mailing_List_etiquette<br class="">MythTV Forums: https://forum.mythtv.org<br class=""></div></blockquote></div><br class=""></body></html>