[mythtv-users] mythconverg database server migration

[Jason Hamilton]

I've always just restored through the regular mysql syntax like mysql -u
root -p mythconverg < mythconverg.sql.  I could be wrong on the syntax but
its along those lines :)

On Thu, Mar 30, 2017 at 7:57 AM, Erik Karlin <e_karlin at yahoo.com> wrote:

> On Thu, Mar 30, 2017 at 10:32:58AM +0000, Mark Perkins wrote:
> >
> > ..snip..
> > > It should have completed long ago.  Something is wrong with your system
> > > and/or MySQL configuration.  Even if you let it run to completion,
> you'll
> > > probably have terrible performance once it's loaded because whatever is
> > > slowing the restore will slow the DBMS, itself.  So you really need to
> identify
> > > and fix the configuration issue that's slowing your MySQL.
> > >
> > > The unfortunate thing is, though, that identifying the configuration
> issue is
> > > going to be a challenge (read, "will take lots of systematic trial and
> error--or a
> > > lucky guess by you or someone on list").
> > >
> > > Mike
> >
> >
> > Would something like mysqltuner.pl help diagnose? I don't recall the OS
> of the OP but I think it ships with Ubuntu so something like:
> > sudo apt-get install mysqltuner
> > sudo mysqltuner
> >
> > may generate something.
>
> I'm on an up-to-date debian jessie. I've since killed the database load
> but haven't had a chance to dig any further. I know I've not made any
> changes to the mysql configs but I do see mysqltuner in the debian repo.
> I will have a look at it. Hopefully it doesn't require a database
> already loaded to tune. Probably does though.
>
> Thanks for all the suggestions so far!
>
> _______________________________________________
> 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
>



-- 
Jason Hamilton

Webmaster of www.thefuzz4.net

We're going to be huge
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20170330/1eb89349/attachment.html>