LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
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.

Notices

Reply
 
LinkBack Search this Thread
Old 07-01-2006, 04:35 PM   #1
mifan
Member
 
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, 05:04 AM   #2
unSpawn
Moderator
 
Registered: May 2001
Posts: 26,519
Blog Entries: 51

Rep: Reputation: 2598Reputation: 2598Reputation: 2598Reputation: 2598Reputation: 2598Reputation: 2598Reputation: 2598Reputation: 2598Reputation: 2598Reputation: 2598Reputation: 2598
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, 05:18 PM   #3
mifan
Member
 
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:
/*C1*/SET SCHEMA PUBLIC
CONNECT USER SA
DELETE FROM "Table1" WHERE "ID"=197
INSERT INTO "Table1" VALUES(197,'name','DATA1')
INSERT INTO "Table1" VALUES(198,'name','DATA2')
... and so on.
 
  


Reply

Tags
database, openoffice.org, 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
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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


All times are GMT -5. The time now is 08:16 PM.

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