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.
