• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1304
  • Last Modified:

MySQL ibdata1 file....

Hello, I have lost my Operating System.  I had to reinstall everything including MySQL.  No matter what I do , i can't get the ibdata1 file to open or to sinc up with the database.  I need to figure out a way that I can recover the information data that I have the file.  I once did get MySQL to sync up to it, however one of the myisam tables would not load.

Are there any utilities that would allow me to back up the content in this ibdata1 file?  Then i could use that to restore to a new database...

Bill.
0
wd006451
Asked:
wd006451
  • 4
  • 4
1 Solution
 
db2inst1Commented:

What are the error messages that you see in the error log?

for myisam tables. Do a check table <tablename> and repairing the table should resolve in most cases.

If you have a backup of the database before the crash restoring it would be your best option.

0
 
wd006451Author Commented:
Is there a utiltity that allows me to recover that file?
0
 
db2inst1Commented:
I really don't understand your problem. where are you trying to recover it from?
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
wd006451Author Commented:
from my file system, i have the file, however i can't get it working with mysql any longer.
0
 
db2inst1Commented:
again, what is the error message that you see in your error log? if you haven't specified any path it should be in the /data_directory/hostname.err
0
 
wd006451Author Commented:
at this point im not getting errors.
0
 
db2inst1Commented:
then why do you say that "from my file system, i have the file, however i can't get it working with mysql any longer."

are you able to logon to mysql and use the database?
0
 
Raynard7Commented:
I note that you mention you could get the ibdata1 file working, with the exception of one of your myisam tables, these are not actually stored in this file - only innodb tables are.
0
 
wd006451Author Commented:
Ohhh no..... ok.. thanks for the update...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now