• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1296
  • 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
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

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

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