top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

restore problem with SQL

+1 vote
553 views

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.

posted Sep 8, 2013 by Sonu Jindal

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button
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.

1 Answer

+1 vote

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.

answer Sep 8, 2013 by Ahmed Patel
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)
Similar Questions
+2 votes

Is there a way I can clear my session data from the browser? This is for debugging when I change something. Currently no matter what I do short of exiting the browser, my session data is always retained. This makes testing very cumbersome. I am using PHP/MySQL for development.

+1 vote

Can anyone help me to run a rails application in a LAMP or WAMP server?

+1 vote

I have installed, de-installed and reinstalled this s/w and MySQL itself on my Win8 box. However, when I go to use it from a script, I get the following error:

"C:Python27libsite-packagesMySQLdb__init.py__", line 27 in  import _mysql
ImportError: DLL load failed: %1 is not valid Win32 application. 

I'm running Win8 which is 64-bit, Python 27, MySQL 5.5. Please help?

...