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 <mdyk...@gmail.com> 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 <triano...@gmail.com> 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" < > > luisforchesa...@gmail.com> het volgende geschreven: > > > > > How did you backed up the MySQL? > > > > > > Att. > > > Luis H. Forchesatto > > > > > > Em 08/09/2013 16:00, "Trianon33" <triano...@gmail.com> 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 > - mdyk...@gmail.com > > May the Source be with you. >
