[mythtv-users] cannot restore database

[Philip Brady]

> Date: Sat, 21 Feb 2015 11:18:55 -0600
> From: keemllib at gmail.com
> To: mythtv-users at mythtv.org
> Subject: Re: [mythtv-users] cannot restore database
> 
> On 02/21/2015 10:53 AM, UB40D wrote:
> ...
> > I hate when they give you a relative path in the error message. Where the
> > hell is that ./mythconverg/ it can't rmdir? Is it that it can't rmdir
> > because it doesn't have permission to it, or because it's not there? If the
> > latter, what's the bit of database that still exists when the script fails
> > to create the database?
> >
> > find / -name mythconverg -print
> >
> > gives nothing (other than the usual annoying bunch of "permission denied"
> > on /proc etc)
> 
> Because the directory is owned and only read/write by user mysql. If you
> do a: sudo before the find, you'll see it. Or, the following will tell
> you where it is:
> 
>      $ cd /etc/mysql;grep datadir my.cnf conf.d/*
> 
>        my.cnf:datadir = /var/lib/mysql
> 
> -- 
> Bill
> ___
Do the database parameters
in ~/.mythtv/config.xml and /home/mythtv/.mythtv/config.xml match?

 

Did you try a database
repair first?

 

/usr/share/doc/mythtv-backend/contrib/maintenance/optimize_mythdb.pl

 

Where is your backup?   It might be specified in /home/phil/.mythtv/backuprc 

 

I stop backend first and specify
the directory like this:

 

sudo stop mythtv-backend

/usr/share/mythtv/mythconverg_restore.pl\

      --drop_database --create_database\

      --directory /var/lib/mythtv/db_backups\

      --filename
mythconverg-1214-20080626150513.sql.gz

sudo start mythtv-backend

 

Then run find_orphans.py

 

HTH

Phil
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20150221/f98d9171/attachment.html>