[mythtv-users] cannot restore database

[John Pilkington]

On 21/02/15 15:31, UB40D wrote:
>
>         # mysql -umythtv -p mythconverg -e "DROP DATABASE IF EXISTS
>         mythconverg;"
>
>
> This command freezes forever without producing output. This is at least
> consistent with this command...
>
> mythconverg_restore.pl <http://mythconverg_restore.pl/> --drop_database
> --create_database --verbose --filename
> mythconverg-1317-20150220033002.sql.gz
>
> ...also freezing after saying...
>
> Preparing initial database.
> Dropping database.
>
> Even just connecting to the database manually never gives me a prompt:
>
> mysql --user=mythtv --password=XXXXX mythconverg
>
>
> ...just outputs the following and locks up until I control-C:
>
>
> Reading table information for completion of table and column names
>
> You can turn off this feature to get a quicker startup with -A
>
>
> I got suspicious. I did
>
>   sudo service mysql restart
>
>
> and, after that, this command gave me a prompt:
>
>
> mysql --user=mythtv --password=XXXXX mythconverg
>
>
> Then I tried running the original restore command:
>
>
> mythconverg_restore.pl <http://mythconverg_restore.pl/> --drop_database
> --create_database --verbose --filename
> mythconverg-1317-20150220033002.sql.gz
>
>
> Again it froze at "dropping database".
>
>
> I did control-C and tried your
>
>
> mysql -umythtv -p mythconverg -e "DROP DATABASE IF EXISTS mythconverg;"
>
>
> and that also froze without output. What's stopping me from dropping the
> database? Maybe some higher-level mysql housekeeping table (e.g. one
> that says what databases are available) is also corrupted and needs
> repair before I can drop the mythconverg database?
>
>
> I confirm that mysql is running and that I can get in, with the same
> userid and password, and get a prompt.
>
>
> What now?

I'm still somewhat confused by the 'root' differences between *buntu and 
RH-based systems, which I have been using for much longer, but my sparse 
notes about setting up myth under kubuntu show that 'mysql -u root mysql 
-pmythtv' gave the mysql prompt and that I was afterwards able to run 
mythtv-setup; but I have my boxes set up as PCs that run myth in a 
desktop and my experience may well not be typical.

... and at that stage I didn't have an old DB that I didn't want to lose...

Have any hostnames been changed?