Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a program that keeps all data in a Derby database. The application itself has crashed but the company that supports the software has a utility that can sort of recover the database. I was sent a zip files containing one schema XML file and dozens of .DAT files which are the individual tables. Is there anyway to upload these into a working MySQL database or to convert the .DAT files into a readable format?

share|improve this question
add comment

1 Answer

up vote 0 down vote accepted

dat files have their own format - so you need to have a program that will read the files and export it into a text format(any type - csv, xml, tab separated etc).

it looks like you need to have as well the mysql schema done before importing the data so that calls for a program from your vendor or you can do it in house.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.