List:General Discussion« Previous MessageNext Message »
From:Yves Goergen Date:November 9 2011 9:52pm
Subject:Re: Restore data from MySQL data files
View as plain text  
On 09.11.2011 21:58 CE(S)T, Reindl Harald wrote:
> Am 09.11.2011 21:46, schrieb Yves Goergen:
>> The old machine was an unknown MySQL version on Windows XP
> 
> pfff - unknown version? how comes?

The old MySQL installation doesn't run anymore because the OS is gone. I
could only backup the files.

>> The error log is attached to this mail. It all sounds like real bugs in
>> MySQL, at least it's standing in the file
> 
> there is no attachment
> so please CLEAR the log, try again restart and post the log here inline

Done, here it is:

> 111109 22:49:59 [Note] Plugin 'FEDERATED' is disabled.
> c:\xampp\mysql\bin\mysqld.exe: Table 'mysql.plugin' doesn't exist
> 111109 22:49:59 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade
> to create it.

(That's what I did.)

> 111109 22:49:59 InnoDB: The InnoDB memory heap is disabled
> 111109 22:49:59 InnoDB: Mutexes and rw_locks use Windows interlocked functions
> 111109 22:49:59 InnoDB: Compressed tables use zlib 1.2.3
> 111109 22:49:59 InnoDB: Initializing buffer pool, size = 16.0M
> 111109 22:49:59 InnoDB: Completed initialization of buffer pool
> 111109 22:49:59 InnoDB: highest supported file format is Barracuda.
> InnoDB: Resetting space id's in the doublewrite buffer
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> 111109 22:49:59  InnoDB: Error: trying to access tablespace 1 page no. 2,
> InnoDB: but the tablespace does not exist or is just being dropped.
> InnoDB: Error: Unable to read tablespace 1 page no 2 into the buffer pool after 100
> attempts
> InnoDB: The most probable cause of this error may be that the table has been
> corrupted.
> InnoDB: You can try to fix this problem by using innodb_force_recovery.
> InnoDB: Please see reference manual for more details.
> InnoDB: Aborting...
> 111109 22:49:59  InnoDB: Assertion failure in thread 6108 in file buf0buf.c line
> 2385
> InnoDB: We intentionally generate a memory trap.
> InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
> InnoDB: If you get repeated assertion failures or crashes, even
> InnoDB: immediately after the mysqld startup, there may be
> InnoDB: corruption in the InnoDB tablespace. Please refer to
> InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html
> InnoDB: about forcing recovery.
> 111109 22:49:59 - mysqld got exception 0xc0000005 ;
> This could be because you hit a bug. It is also possible that this binary
> or one of the libraries it was linked against is corrupt, improperly built,
> or misconfigured. This error can also be caused by malfunctioning hardware.
> We will try our best to scrape up some info that will hopefully help diagnose
> the problem, but since we have already crashed, something is definitely wrong
> and this may fail.
> 
> key_buffer_size=16777216
> read_buffer_size=262144
> max_used_connections=0
> max_threads=151
> thread_count=0
> connection_count=0
> It is possible that mysqld could use up to 
> key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 133447 K
> bytes of memory
> Hope that's ok; if not, decrease some variables in the equation.
> 
> Thread pointer: 0x0
> Attempting backtrace. You can use the following information to find out
> where mysqld died. If you see no messages after this, something went
> terribly wrong...
> 00496618    mysqld.exe!my_osmaperr()
> 004C1D85    mysqld.exe!my_osmaperr()
> 004C1D8E    mysqld.exe!my_osmaperr()
> 004C3692    mysqld.exe!my_osmaperr()
> 004D9504    mysqld.exe!my_osmaperr()
> 004C383B    mysqld.exe!my_osmaperr()
> 0048B5F5    mysqld.exe!my_osmaperr()
> 777222C6    ntdll.dll!RtlAllocateHeap()
> The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
> information that should help you find out what is causing the crash.


-- 
Yves Goergen "LonelyPixel" <nospam.list@stripped>
Visit my web laboratory at http://beta.unclassified.de
Thread
Restore data from MySQL data filesYves Goergen9 Nov
  • Re: Restore data from MySQL data filesReindl Harald9 Nov
    • Re: Restore data from MySQL data filesYves Goergen9 Nov
      • Re: Restore data from MySQL data filesJohan De Meersman10 Nov
        • Re: Restore data from MySQL data filesYves Goergen26 Nov