[mythtv-users] Mythsqlhotcopy restore
stan
stanlist at cox.net
Wed Oct 25 05:08:05 UTC 2006
> -----Original Message-----
> From: mythtv-users-bounces at mythtv.org
> [mailto:mythtv-users-bounces at mythtv.org] On Behalf Of William Munson
> Sent: Monday, October 23, 2006 7:19 PM
> To: Discussion about mythtv
> Subject: Re: [mythtv-users] Mythsqlhotcopy restore
>
> stan wrote:
> >> -----Original Message-----
> >> From: mythtv-users-bounces at mythtv.org
> >> [mailto:mythtv-users-bounces at mythtv.org] On Behalf Of
> William Munson
> >> Sent: Monday, October 23, 2006 3:06 PM
> >> To: Discussion about mythtv
> >> Subject: Re: [mythtv-users] Mythsqlhotcopy restore
> >>
> >> stan wrote:
> >>
> >>> I'm using the mythsqlhotcopy script to back up the mythTV
> >>>
> >> database. How do
> >>
> >>> you do a restore?
> >>>
> >>> The comments say to copy the files back, run a few mySQL
> >>>
> >> utilities for fix
> >>
> >>> up, and tell mySQL to use the restored files. Do you really
> >>>
> >> need to tell
> >>
> >>> mySQL to use the restored files, or is this done
> >>>
> >> automatically assuming you
> >>
> >>> stop the daemon before replacing the current files with the
> >>>
> >> backup versions?
> >>
> >>> --stan
> >>>
> >>>
> >>>
> >> I do my backups manually using mysqldump and I use the
> >> --add-drop-table
> >> option so for me its as simple as:
> >>
> >> mythbackend stop
> >> mysql -p mythconverg < /path/to/backup
> >> mythbackend start
> >> (restart frontends)
> >>
> >> Yours should be similar although you may have to manually
> >> drop the table.
> >>
> >> Can you post a url for that script? I would be interested in
> >> checking it
> >> out.
> >>
> >>
> >
> > Sure. There's a good discussion here, and the script (that
> needs a little
> > modification to point to your specific backup location,
> etc. it attached as
> > a text file to the referenced url).
> >
> >
> http://www.gossamer-threads.com/lists/mythtv/users/223965?sear
> ch_string=hotc
> > opy;#223965
> >
> > The script works well on my system. Backup time is under
> 30 seconds, and I
> > plan to run it once a day with anacron. I removed the
> section to mail the
> > cron output (since I'm using anacron), and I added -u and
> -p parms to each
> > of the mySQL calls so I could run it as root from anywhere.
> >
> > I think the restore method for hotcopy is different from
> the restore method
> > for dump because hotcopy seems to simply lock the tables
> and copy the raw
> > files. I'm still not clear on how to properly restore a
> hotcopy though.
> >
> > BTW, in debugging my mods to the script I tried to do a
> >
> > bash -x mysqlhotcopy_script | more
> >
> > That didn't work. Did the "bash -x" eat the " | more" or
> something? How do
> > you pipe bash -x output to more?
> >
> >
> I am no expert so I would try something like
>
> bash -x mysqlhotcopy_script > ./tmp.log && more ./tmp.log
>
Turns out, "bash -x" writes to stderr rather than stdout. So, I got it work
with
bash -x mysqlhotcopy_script 2>&1 | more
BUT, I still don't know how to restore a mysqlhotcopy_script backup. Does
anyone have experience with this?
--stan
More information about the mythtv-users
mailing list