Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

MySQL ibdata1 file....

Posted on 2006-11-15
9
1,287 Views
Last Modified: 2008-01-09
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
Comment
Question by:wd006451
  • 4
  • 4
9 Comments
 
LVL 7

Expert Comment

by:db2inst1
ID: 17951005

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
 
LVL 1

Author Comment

by:wd006451
ID: 17951905
Is there a utiltity that allows me to recover that file?
0
 
LVL 7

Expert Comment

by:db2inst1
ID: 17951909
I really don't understand your problem. where are you trying to recover it from?
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
LVL 1

Author Comment

by:wd006451
ID: 17951921
from my file system, i have the file, however i can't get it working with mysql any longer.
0
 
LVL 7

Expert Comment

by:db2inst1
ID: 17952114
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
 
LVL 1

Author Comment

by:wd006451
ID: 17952960
at this point im not getting errors.
0
 
LVL 7

Expert Comment

by:db2inst1
ID: 17953068
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
 
LVL 35

Accepted Solution

by:
Raynard7 earned 500 total points
ID: 17953196
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
 
LVL 1

Author Comment

by:wd006451
ID: 17953208
Ohhh no..... ok.. thanks for the update...
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question