Latest LQ Deal: Linux Power User Bundle
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 07-01-2006, 05:35 PM   #1
Registered: Apr 2004
Distribution: mandrake
Posts: 116

Rep: Reputation: 15
help recovering database file in open office

Last night, I was using open office when it decided to stop responding, so I did xkill and reopened open office. the data recovery saved me three hours of work, (three hours was the last time I had saved).

but today I was working all day, and I didn't save since last night. now open office has frozen again. this time, if I do the same thing, it will set me back an entire day's work. Is there a way to recover the file... perhaps it's stored some where in a temp folder... anyone know?

It is an open office database file. I checked the .openoffice dir in my home directory, and didn't see a .bak file for the database.

help recovering files greatly appreciated!!!
Old 07-02-2006, 06:04 AM   #2
Registered: May 2001
Posts: 29,361
Blog Entries: 55

Rep: Reputation: 3547Reputation: 3547Reputation: 3547Reputation: 3547Reputation: 3547Reputation: 3547Reputation: 3547Reputation: 3547Reputation: 3547Reputation: 3547Reputation: 3547
If the process is still running it still could have files open. First thing is finding the pid(s) of the process(es) using ps, pgrep or pidof. Now you could check if any of the filedescriptors in /proc/PID/fd/ has the file opened. You could also try and find those with the standard "lsof" tool. "lsof -p PID" should show open files for that process, or if you know the file is in a tempdir or say "/home/mifan" you could also do "lsof +D /home/mifan" to get a list of all opened files there.
Old 07-06-2006, 06:18 PM   #3
Registered: Apr 2004
Distribution: mandrake
Posts: 116

Original Poster
Rep: Reputation: 15
thanks! I found the tmp file and saved it, but now I'm not sure how to add those back into the database...

I have a file with a bunch of lines that look like this:
INSERT INTO "Table1" VALUES(197,'name','DATA1')
INSERT INTO "Table1" VALUES(198,'name','DATA2')
... and so on.


database,, recovery

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Open a Microsoft Office Access database???? Ace2005 Linux - Software 7 07-03-2005 05:25 PM
can't see a swf file in open office CiScOh4x0r Ubuntu 1 06-03-2005 02:16 PM
Open Office File Association quo_vadis Linux - Newbie 1 04-20-2004 08:39 AM
How to open a wps file in open office 1.1 oneiric Linux - Software 4 04-15-2004 05:07 AM
Convert Open Office file to PDF file. liguorir Linux - Software 1 01-13-2004 01:44 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 10:00 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration