List:General Discussion« Previous MessageNext Message »
From:Andrew Moore Date:September 8 2013 9:26pm
Subject:Re: restore problem
View as plain text  
I would suggest making a physical backup. Shutdown MySQL on source, copy
datadir and start on the the destination server. (observe configuration
differences between the two machines)

*Benefits;* consistent backup of non-transactional files.
*Drawbacks;* downtime required.


On Sun, Sep 8, 2013 at 10:16 PM, Michael Dykman <mdykman@stripped> wrote:

> I would suggest that you test your backup file on another full-featured
> server to determine that it is a valid first.  I have done a little work
> with the raspberry pi and I doubt that the mysql distribution for that
> platform comes with all the features your server-class ubuntu does, so it
> is quite possible that you backup file is trying to take advantage of some
> facilities available on the source host that are not available on your
> lightweight target.
>
>
>
> On Sun, Sep 8, 2013 at 3:05 PM, Trianon33 <trianon33@stripped> wrote:
>
> > Hello,
> >
> > Thanks for your quick reply.
> >
> > I use WEBMIN and within the Webmin modules you can make simply a SQL
> > backup, which is in fact a flat file consisting of MYSQL commands.
> >
> > Explains this enough?
> >
> > Thanks, BR
> >
> >
> >
> > Op 8 sep. 2013, om 21:02 heeft "Luis H. Forchesatto" <
> > luisforchesatto@stripped> het volgende geschreven:
> >
> > > How did you backed up the MySQL?
> > >
> > > Att.
> > > Luis H. Forchesatto
> > >
> > > Em 08/09/2013 16:00, "Trianon33" <trianon33@stripped> escreveu:
> > > Hello all,
> > >
> > > As this is my first post to this list (though reading for some time
> > yet), I maybe not complete in asking my question. Apologies for that.
> > >
> > > On the other hand, this is not a prio 1 problem, so if it takes some
> > mailing, that's ok.
> > >
> > > I have a website on my private webserver, which consist of some kind of
> > a LAMP-server on a raspberry. Previously it ran on a laptop with Ubuntu
> and
> > the same kind of LAMP-server.
> > >
> > > I'm trying to restore the SQL-backup from the old machine to restore
> > with the raspberry. While finding the file and starting the restore is no
> > problem, I get the following message and a full stop:
> > >
> > > SELECT MAX( version )
> > > FROM `phpmyadmin`.`pma_tracking`
> > > WHERE `db_name` = 'bbz'
> > > AND `table_name` = 'wp_links VALUES'
> > > AND FIND_IN_SET( 'INSERT', tracking ) >0
> > >
> > > MySQL retourneerde: <b_help.png>
> > >
> > > #1100 - Table 'pma_tracking' was not locked with LOCK TABLES
> > >
> > > Since I do a full restore I'm processing the younameit.SQL file
> > >
> > > I'm bad in interpreting the error messag, don't understand what it
> > exactly mens and what I can do to cure this problem.
> > >
> > > Anyone a suggestion?
> > >
> > > Thanks in advance, BR
> >
> >
>
>
> --
>  - michael dykman
>  - mdykman@stripped
>
>  May the Source be with you.
>

Thread
restore problemTrianon338 Sep
Re: restore problemTrianon338 Sep
  • Re: restore problemMichael Dykman8 Sep
    • Re: restore problemTrianon338 Sep
    • Re: restore problemAndrew Moore8 Sep