Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    1

    Unhappy Unanswered: Please help, otherwise I'll got fired !!

    All the database and tables in my MySql server is innoDB, but those link files ibd1*.... has been deleted from the mysql data directory. Now I cannot open any table to get the records. I have previously safed all the *.frm files, but still no luck. Everytime I tried to access the take, it will just said:

    Error 1016: Cannot open file "mytablename.innodb" (Errorno: 1)

    Please help me, I really need you all experts to help me, all I need is just to get all the data from the tables, I don't mind to recreate all the tables again. All I need is just the data. I've been reading the http://dev.mysql.com/doc/mysql/en/In..._datadict.html

    articles, but I have no clue on what it is talking about. Please try your best to help a poor man. Thanks a lot !!

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    Have you tried creating a new database/table structure and bringing the files into the database that way?

    Can you open the files in Word or some other such program and see if you can strip everything out except the data and re-import them as a .CSV file would be brought in?

Posting Permissions

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