Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Recovery of data from InnoDB table

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 08-12-2009
Member
 
Join Date: Nov 2009
Posts: 47
Recovery of data from InnoDB table
  

I had mysql on a server that has crashed. I recover the hard disk, it contains the whole directory of mysql: the engine data. How do I do to recover data from a table that is probably InnoDB? For though I copy it with other databases, when I try to see its contents with phpmyadmin, it says there is no table.

Reply With Quote
  #2  
Old 08-12-2009
Member
 
Join Date: Nov 2008
Posts: 1,192
Re: Recovery of data from InnoDB table

If your tables use the default MyISAM engine, you will just have to paste the folder back to your base where it was before crash (/var/lib/mysql/ usually on Linux).

If you know by using the InnoDB engine (which is excellent for receiving foreign keys) and you have not saved properly (using MySQL DUMP or phpMyAdmin tool backup or other) data, you may not find that the structure of tables by pasting the directory of your database and the data will probably be lost as stored in another file (/var/lib/mysql/idbdata on Linux + log files ib_logfileX ).
Reply With Quote
  #3  
Old 08-12-2009
Member
 
Join Date: Nov 2009
Posts: 47
Re: Recovery of data from InnoDB table

OK, I dig myself thinking about the same, then I changed my mind in preferring to create a new database. Because I happen to have the files "idbdata" and "ib_logfileX" but I do not know how to retrieve data from there on windows.
Reply With Quote
  #4  
Old 08-12-2009
Member
 
Join Date: Nov 2008
Posts: 1,192
Re: Recovery of data from InnoDB table

Since it is after a crash, I suppose the new server is empty of data and want to restore what was on the former.

What I would try:
1) Stop MySQL service on the new server

2) Save the current data directory of MySQL on the new server.
While in principle it is nearly empty but if there are config, the manip may completely crash the MySQL server, so be cautious.

3) Put in place the data directory from the old server.

4) Restart the MySQL service and see if the data is retrieved.
If it is planted, redo the manip reverse.

But before all that, even when I throw a look at the MySQL doc.
Reply With Quote
  #5  
Old 08-12-2009
Member
 
Join Date: Nov 2009
Posts: 47
Re: Recovery of data from InnoDB table

I searched a lot on this, I found nothing to InnoDB, only for MyISAM. I searched the net with InnoDB crash, then Reovery InnoDB crash recovery and InnoDB. But I find nothing under Windows system, can I get help? According to me Google is vast already but still a bit empty!
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Recovery of data from InnoDB table"
Thread Thread Starter Forum Replies Last Post
Retrieve selected Data From a Table samualres Software Development 5 30-01-2010 10:04 AM
How to Insert data into MySQL table Mahendra varma Software Development 4 04-10-2009 05:42 AM
How to copy one table data into another table directly? ComPaCt Software Development 3 22-09-2009 04:54 PM
need to show data in other html table for php Quattro Software Development 3 03-07-2009 12:44 AM
[VB6 + Access] Recognizing table recovery using Ado or Adox Gunner Software Development 4 23-02-2009 10:22 AM


All times are GMT +5.5. The time now is 12:35 PM.