Solved

MySQL ibdata1 file....

Posted on 2006-11-15
9
1,289 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
[X]
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
  • 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

Suggested Solutions

Title # Comments Views Activity
MySQL Error Code 2 27
FrontEnd tools to create web database application 7 93
Display images from mysql blob type (Not working) 9 53
MySQL-Design Help 12 44
Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

730 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