restore problem with SQL

Question

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: #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.

Comments

How did you backed up the MySQL?

---

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.

Answer 1

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.

Comments

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.....

---

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)