topic Re: data file editor in Operating System - HP-UX

data file editor

Steve_3 — Fri, 17 Nov 2000 00:08:18 GMT

I have a corrupted data file that i want to edit. when i do a strings on that data file i see garbages and the data i need. how can i fixed this data file.

Thanks.
steve

Re: data file editor

Elizabeth_2 — Fri, 17 Nov 2000 00:56:33 GMT

Hi Steve!

Are you sure that the the file is actually corrupted? Is this file a binary file? I don't doubt that you are seeing strange characters, however because the strings(1) command is looking for ASCII strings if it iss run on a binary file, it is normal for some strange characters. (This is why you may also see strange characters when you do a strings on your /etc/lvmtab).

The strings command is just a way to "cheat" and see info. It leverages how strings pulls ascii characters out of unformated files.

So, the best help that I can offer is not to trust strings. If you are looking at a binary file double check that the file is actually corrupt.

Elizabeth

Re: data file editor

Steve_3 — Fri, 17 Nov 2000 01:01:15 GMT

It is a database file so when you do file {nameof file} you get data file. Is there a tool I can edit this data file?

Thanks,
steve

Re: data file editor

Elizabeth_2 — Fri, 17 Nov 2000 01:06:25 GMT

Hi Steve,

I don't know much about database files- but what database are you running? Have you tried to vi the file?

Re: data file editor

Patrick Wallek — Fri, 17 Nov 2000 04:26:35 GMT

If it is a database file, I would highly recommend NOT messing with it. Binary/data files are very hard, if not impossible, to edit. With it being a database file, you really risk royally messing up the file -- even more than it is now.

My recommendation would be to try to restore the file, or possibly the whole database, from a backup.

Re: data file editor

Dan Hetzel — Fri, 17 Nov 2000 05:18:18 GMT

Steve,

As it looks to be a database data file, you shouldn't even try editing it.
The risk is that you could be facing a total data loss.

If you want to restore that file from a backup, you should restore the whole database (all files) to maintain integrity.

First of all, are you sure that this file is corrupted? Is the database complaining ? Don't trust unix because the operating system has no idea of the file formatting.

Best regards,

Dan

Re: data file editor

Paula J Frazer-Campbell — Fri, 17 Nov 2000 09:02:17 GMT

Steve
I only way to edit a database file is to use the database itself to edit/fix it.

Most database have inbuilt data integrety testing software.

What database does it belong to.

Paula

Re: data file editor

Steve_3 — Fri, 17 Nov 2000 18:37:00 GMT

Thanks for all your advice. There is no way to edit the database file. They are planning to rebuild the database.

Thanks
steve