[mythtv-users] db restore

[Daryl McDonald]

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 mythconverg_restore.pl
daryl at trieli:~$ mythconverg_restore.pl --drop_database --create_database
--filename mythconverg-1344-20180804112717.sql.gz
mythconverg_restore.pl: command not found
daryl at trieli:~$ mythconverg_restore.pl --directory/home/daryl
--drop_database --create_database --filename
mythconverg-1344-20180804112717.sql.gz
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
-rwxrwxr-x  1 daryl daryl    68814 Aug  5 09:40 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
daryl at trieli:~$ mythconverg_restore.pl --drop_database --create_database
--filename mythconverg-1344-20180804112717.sql.gz
mythconverg_restore.pl: command not found
daryl at trieli:~$ ./mythconverg_restore.pl --drop_database --create_database
--filename mythconverg-1344-20180804112717.sql.gz

ERROR: DBBackupDirectory not specified, stopped at ./mythconverg_restore.pl
line 773.
daryl at trieli:~$ ./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
line 933.
DBI connect('host=','',...) failed: Access denied for user 'daryl'@'localhost'
(using password: NO) at ./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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20180805/13a7c42f/attachment.html>