Hello,
I am trying to recover an old mySQL database.
I have a copy of all the files of a database from mysql 4.1
structure looks something like this
data
-mysql(filled with <tablename>.FRM, <tablename>.MYD, <tablename>.MYI files for all tables I need)
-DBname (filled with <tablename>.FRM, <tablename>.MYD, <tablename>.MYI files for all tables I need)
-ib_logfile0
-ib_logfile1
-ibdata1
-<compname>.err
-<compname>.pid
I tried to move these files into my C:\ProgramData\MySQL\MySQL Server 5.5\data
but when I try to connect to the DB after this I get the following error messages
FROM C:\ProgramData\MySQL\MySQL Server 5.5\Data\COSPWS-INTERN4.err:
2014-07-23 11:35:10 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2014-07-23 11:35:10 [Note] Plugin 'FEDERATED' is disabled.
2014-07-23 11:35:10 InnoDB: The InnoDB memory heap is disabled
2014-07-23 11:35:10 InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-07-23 11:35:10 InnoDB: Compressed tables use zlib 1.2.3
2014-07-23 11:35:10 InnoDB: Initializing buffer pool, size = 105.0M
2014-07-23 11:35:10 InnoDB: Completed initialization of buffer pool
2014-07-23 11:35:10 InnoDB: highest supported file format is Barracuda.
2014-07-23 11:35:11 InnoDB: Waiting for the background threads to start
2014-07-23 11:35:12 InnoDB: 5.5.38 started; log sequence number 6801804300
2014-07-23 11:35:12 InnoDB: Starting shutdown...
2014-07-23 11:35:12 InnoDB: Shutdown completed; log sequence number 6801804300
additionally if i copy all the <tablename>.FRM, <tablename>.MYD, <tablename>.MYI files into the same location (with out the -ib_logfile0, ib_logfile1, ibdata1 , <compname>.err, <compname>.pid) I can start the server, the only problem is some of the necessary tables that only have a .FRM cannot be queried (its as if they dont exist).
Thanks in adcance for any help.