Solved

MySQL ibdata1 file....

Posted on 2006-11-15
9
1,282 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
 
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

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…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

867 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now