[mythtv-users] db restore

Sun Aug 5 14:19:47 UTC 2018

> On Aug 5, 2018, at 10:03 AM, Daryl McDonald <darylangela at gmail.com> wrote:
> 
> 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
> 
> daryl at trieli:~$ chmod a+x mythconverg_backup.pl <http://mythconverg_backup.pl/> mythconverg_restore.pl <http://mythconverg_restore.pl/>
> daryl at trieli:~$ mythconverg_restore.pl <http://mythconverg_restore.pl/> --drop_database --create_database --filename mythconverg-1344-20180804112717.sql.gz
> mythconverg_restore.pl <http://mythconverg_restore.pl/>: command not found
> daryl at trieli:~$ mythconverg_restore.pl <http://mythconverg_restore.pl/> --directory/home/daryl --drop_database --create_database --filename mythconverg-1344-20180804112717.sql.gz
> mythconverg_restore.pl <http://mythconverg_restore.pl/>: command not found
> daryl at trieli:~$ cd /home/dary/
> bash: cd: /home/dary/: No such file or directory
> daryl at trieli:~$ cd Home
> bash: cd: Home: No such file or directory
> daryl at trieli:~$ ls -al
> total 52180
> drwxr-xr-x 18 daryl daryl     4096 Aug  5 09:40 .
> drwxr-xr-x  4 root  root      4096 Aug  5 09:21 ..
> -rw-------  1 daryl daryl      146 Aug  5 08:37 .bash_history
> -rw-r--r--  1 daryl daryl      220 Aug  5 07:36 .bash_logout
> -rw-r--r--  1 daryl daryl     3771 Aug  5 07:36 .bashrc
> drwx------ 18 daryl daryl     4096 Aug  5 08:39 .cache
> drwx------ 16 daryl daryl     4096 Aug  5 08:50 .config
> drwxr-xr-x  2 daryl daryl     4096 Aug  5 07:59 Desktop
> drwxr-xr-x  2 daryl daryl     4096 Aug  5 07:59 Documents
> drwxr-xr-x  2 daryl daryl     4096 Aug  5 08:50 Downloads
> -rw-r--r--  1 daryl daryl     8980 Aug  5 07:36 examples.desktop
> drwx------  2 daryl daryl     4096 Aug  5 08:27 .gconf
> drwx------  3 daryl daryl     4096 Aug  5 08:32 .gnupg
> -rw-------  1 daryl daryl      636 Aug  5 08:32 .ICEauthority
> drwxr-xr-x  7 daryl daryl     4096 Aug  5 08:51 .kodi
> drwx------  3 daryl daryl     4096 Aug  5 07:59 .local
> drwx------  5 daryl daryl     4096 Aug  5 08:33 .mozilla
> drwxr-xr-x  2 daryl daryl     4096 Aug  5 07:59 Music
> -rw-r--r--  1 daryl daryl 53170263 Aug  4 11:27 mythconverg-1344-20180804112717.sql.gz
> -rwxrwxr-x  1 daryl daryl    59103 Aug  5 09:39 mythconverg_backup.pl <http://mythconverg_backup.pl/>
> -rwxrwxr-x  1 daryl daryl    68814 Aug  5 09:40 mythconverg_restore.pl <http://mythconverg_restore.pl/>
> drwxr-xr-x  2 daryl daryl     4096 Aug  5 07:59 Pictures
> drwx------  3 daryl daryl     4096 Aug  5 08:39 .pki
> -rw-r--r--  1 daryl daryl      675 Aug  5 07:36 .profile
> drwxr-xr-x  2 daryl daryl     4096 Aug  5 07:59 Public
> -rwxrwxr-x  1 daryl daryl     1107 Oct 23  2014 shortlog.sh
> -rw-r--r--  1 daryl daryl        0 Aug  5 08:01 .sudo_as_admin_successful
> drwxr-xr-x  2 daryl daryl     4096 Aug  5 07:59 Templates
> drwxr-xr-x  2 daryl daryl     4096 Aug  5 07:59 Videos
> -rwxrwxr-x  1 daryl daryl      555 Sep 24  2016 wakeup_test.sh
> -rw-------  1 daryl daryl       51 Aug  5 08:31 .Xauthority
> -rw-------  1 daryl daryl       82 Aug  5 08:31 .xsession-errors
> -rw-------  1 daryl daryl     1228 Aug  5 08:31 .xsession-errors.old

You can run this by doing perl mythconverg………   

 the ‘errors’  you are seeing is that your home directory is NOT in your path.  The rest of the commands look fine.

> daryl at trieli:~$ mythconverg_restore.pl <http://mythconverg_restore.pl/> --drop_database --create_database --filename mythconverg-1344-20180804112717.sql.gz
> mythconverg_restore.pl <http://mythconverg_restore.pl/>: command not found
> daryl at trieli:~$ ./mythconverg_restore.pl <http://mythconverg_restore.pl/> --drop_database --create_database --filename mythconverg-1344-20180804112717.sql.gz
> 
> ERROR: DBBackupDirectory not specified, stopped at ./mythconverg_restore.pl <http://mythconverg_restore.pl/> line 773.
> daryl at trieli:~$ ./mythconverg_restore.pl <http://mythconverg_restore.pl/> --drop_database --create_database --directory ~ --filename mythconverg-1344-20180804112717.sql.gz
> DBI connect('host=:database=mythconverg','',...) failed: Access denied for user 'daryl'@'localhost' (using password: NO) at ./mythconverg_restore.pl <http://mythconverg_restore.pl/> line 933.
> DBI connect('host=','',...) failed: Access denied for user 'daryl'@'localhost' (using password: NO) at ./mythconverg_restore.pl <http://mythconverg_restore.pl/> line 933.
> 
> Unable to connect to database.
>            database: mythconverg
>                host: 
>            username: 
> To see the password used, please re-run the script with the --verbose
> argument.
> 
> Please check your configuration files to verify the database connection
> information is correct.  The files that are used to retrieve connection
> information are prefixed with "parsing" in the "Parsing configuration files"
> section of the --verbose output.
> 
> Also note that any [client] or [mysql] password specified in the MySQL options
> file (/etc/my.cnf or /etc/mysql/my.cnf or ~/.my.cnf) will take precedence over
> the password specified in the MythTV configuration files.
> 
> ERROR: Unable to connect to database.
> 
> I would appreciate any help getting this fixed. Daryl
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20180805/1bc9a8ca/attachment.html>