x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 8 replies
  • Answers 1 answer
  • Subscribers 60 subscribers
  • Views 3316 views
  • Users 0 members are here
Browse Forums
Announcements
78
topics
166
replies
General Discussion
5k
topics
16k
replies
Installation and Upgrades
983
topics
3k
replies
Inventory, Projects, and Departments
339
topics
1k
replies
Payables and Receivables
1k
topics
4k
replies
Payroll
1k
topics
3k
replies
Reconciliation and Banking
318
topics
997
replies
Reporting and Analytics
207
topics
401
replies
Soutien Technique - Français
634
topics
1k
replies
Year End Activities
224
topics
596
replies
jbost

Corrupt ibdata1 - RAID i/o error

SUGGESTED
Posted By

Simply Accounting 2012

Data stored on RAID 5 volume. 1 disk is failing, but working. Rebuilding array failed.

Last successful backup is a few months old. 

Database can be accessed and used, but ibdata1 cannot be copied due to the i/o error.

Question: Since Simply will run, is there a way to export ALL DATA going back ONLY until my last backup?

Plan of action:

1. Recover old backup copy to another machine

2. Export latest data form working Simply from date of backup to today

3. Import new data into the recovered backup database

4. Win?

Any thoughts on this?

Parents
  • 0

    I would try some of the command line COPY parameters, maybe  /B?   or XCOPY /C    and / or run one of the linux distros to boot from a USB to attempt to read the RAID outside the OS.  You might be able to read NTFS and copy it onto a FAT32 filesystem on a second USB.

    Odd that Sage 50 will run, but it's built-in backup / copy won't run - MySQL (at least used to) read ibdata1 and require a valid checksum before allowing the client to connect.  

Reply
  • 0

    I would try some of the command line COPY parameters, maybe  /B?   or XCOPY /C    and / or run one of the linux distros to boot from a USB to attempt to read the RAID outside the OS.  You might be able to read NTFS and copy it onto a FAT32 filesystem on a second USB.

    Odd that Sage 50 will run, but it's built-in backup / copy won't run - MySQL (at least used to) read ibdata1 and require a valid checksum before allowing the client to connect.  

Children
  • 0 in reply to RandyW

    I've been trying Robocopy a lot. I tried your suggestions with xcopy and copy, but no luck. I also tried rebuilding the RAID again and it failed. Thank you for the recommendations though!

    I contacted Dell, but at this point I'm not sure how much they can support. I'll try Sage first. It's possible that the checksum check isn't implemented in Simply 2012 which is what can currently access it.

    As for the Linux mounting and copying I might try that as a last resort. I did try Hiren's Boot CD and doing the same, but no luck. I know it's running a windows PE, but it was at least outside the OS on the drives. 

    One thing I was thinking, when I tried to rebuild the RAID twice I was using the hotspare without removing the damaged drive. I wonder if the PERC software was still trying to rebuild using data from the bad drive instead of focusing ONLY on the 2 good drives. So perhaps, I should be pulling the bad drive and trying to rebuild from the two good drives to the global hot spare. I know that's how you would do it on a hot-swappable server, but I figured, why pull the bad one if I already have a global hotspare in there? 

    That might be a question for Dell once I pay their $1100 for 2 hours of best attempt service :/

*Community Hub is the new name for Sage City