Results 1 to 5 of 5

Thread: Recovery of data from InnoDB table

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

  2. #2
    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 ).

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

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

  5. #5
    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!

Similar Threads

  1. Retrieve selected Data From a Table
    By samualres in forum Software Development
    Replies: 5
    Last Post: 30-01-2010, 09:04 AM
  2. How to Insert data into MySQL table
    By Mahendra varma in forum Software Development
    Replies: 4
    Last Post: 04-10-2009, 04:42 AM
  3. How to copy one table data into another table directly?
    By ComPaCt in forum Software Development
    Replies: 3
    Last Post: 22-09-2009, 03:54 PM
  4. need to show data in other html table for php
    By Quattro in forum Software Development
    Replies: 3
    Last Post: 02-07-2009, 11:44 PM
  5. [VB6 + Access] Recognizing table recovery using Ado or Adox
    By Gunner in forum Software Development
    Replies: 4
    Last Post: 23-02-2009, 09:22 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •