[mythtv-users] db restore
Daryl McDonald
darylangela at gmail.com
Sun Aug 5 15:01:39 UTC 2018
On Sun, Aug 5, 2018 at 10:48 AM, Daryl McDonald <darylangela at gmail.com>
wrote:
>
>
> On Sun, Aug 5, 2018 at 10:19 AM, Jay Harbeston (ISeePeople) <
> jharbestonus at gmail.com> wrote:
>
>>
>>
>> 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 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-2018080411271
>> 7.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
>>
>>
>> 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 --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-2018080411271
>> 7.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
>>
>>
> I'm still getting nowhere:
> daryl at trieli:~$ ./mythconverg_restore.pl --create_database --directory ~
> --filename mythconverg-1344-20180804112717.sql.gz --verbose
>
> Configuring environment:
> - username: daryl
> - HOME: /home/daryl
> - MYTHCONFDIR: /home/daryl/.mythtv
>
> Parsing configuration files:
> - checking: /home/daryl/.mythtv/config.xml
> - checking: /usr/local/share/mythtv/mysql.txt
> - checking: /usr/share/mythtv/mysql.txt
> - checking: /usr/local/etc/mythtv/mysql.txt
> - checking: /etc/mythtv/mysql.txt
> - checking: /home/daryl/.mythtv/mysql.txt
> - checking: mysql.txt
> - checking: /home/daryl/.mythtv/mysql.txt
> - checking: /home/daryl/.mythtv/backuprc
>
> Applying command-line arguments.
>
> Checking configuration.
>
> WARNING: DBName not specified. Using mythconverg
>
> WARNING: DBHostName not specified.
> Assuming it is specified in the MySQL options file.
>
> WARNING: DBUserName not specified.
> Assuming it is specified in the MySQL options file.
>
> WARNING: DBPassword not specified.
> Assuming it is specified in the MySQL options file.
>
> Database Information:
> DBHostName:
> DBPort: -1
> DBUserName:
> DBPassword:
> DBName: mythconverg
> DBSchemaVer:
> DBBackupDirectory: /home/daryl
> DBBackupFilename: mythconverg-1344-20180804112717.sql.gz
> drop_database: no
> create_database: yes
>
> Executables:
> mysql_client: mysql
> uncompress: gzip -d
>
> Miscellaneous:
> partial_restore: no
> restore_xmltvids: no
> change_hostname: no
>
> Checking database.
> DBI connect('host=:database=mythconverg','',...) failed: Access denied
> for user 'daryl'@'localhost' (using password: NO) at ./
> mythconverg_restore.pl line 933.
>
> Preparing initial database.
> 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:
> password:
>
> 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.
>
None of the config files exist (listed under parsing) how do I create
those?
>
> _______________________________________________
>> 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
>>
>>
>>
>> _______________________________________________
>> 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/bc7917b5/attachment.html>
More information about the mythtv-users
mailing list