Hmmmm, this remark makes sense, thanks for reminding that. Since I have a backup in SQl format (it is readable statements), I was thinking on splitting the backup file in several separate restores and execute them manually in consecutive order.....
Hmmm, the idea attracts me. Wait for some results. BR. Op 8 sep. 2013, om 23:16 heeft Michael Dykman <mdyk...@gmail.com> het volgende geschreven: > 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
