Database partly destroyed

Creating and using forms

Database partly destroyed

Postby pm-c » Fri Feb 10, 2012 5:18 pm

When I tried to open a database with approx. 160 posts which I use every morning to store medical data, suddenly I was presented for a form where I should choose ASCII filters, character sets etc. The only way to procede was to press the OK botton. Then I got a writer document, 37 pages each holding very few caracters.
I am running Windows 7 and at c:\users\me\AppData\Roaming\OenOffice\3\user\backup there is a backup file covering 2/3 of the original table.
How do I get back the entire database tabel?
How do I avoid this problem in the furture?
pm-c
OpenOffice 3.3.0 on Windows 7
pm-c
 
Posts: 3
Joined: Fri Feb 10, 2012 4:21 pm

Re: Database partly destroid

Postby Villeroy » Fri Feb 10, 2012 5:47 pm

Tools>Options>OpenOffice.org>Paths
Note the path for temporary files.
There you may find some directory named like "sv8im.tmp" and a similarly named file within that directory. Copy that file to a save place.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26974
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Database partly destroyed

Postby DACM » Fri Feb 10, 2012 6:46 pm

pm-c wrote:How do I get back the entire database?

Try: Database corruption remedies
See also: Data recovery service

pm-c wrote:How do I avoid this problem in the future?

You have several options:

Automated database backups WITH an internet connection:
    Utilize a cloud-sync'd folder with "versioning" (file history) like: Dropbox, Wuala, SpiderOak, Google Drive, SkyDrive and many others. These services generally offer a few gigabytes for free and allow you to recover previous versions of your database. For instance, SugarSync keeps the last 5 versions indefinitely (in the free service). Wuala keeps ten versions. Google Drive keeps 100 versions for 30 days each while granting 15GB for free. Dropbox has apparently reintroduced the version history feature in their free accounts, keeping all versions for 30-days. SugarSync adds the ability to designate any folder(s) for sync across your computer (although I've had problems with the stability of SugarSync on Windows 7 and was forced to uninstall it). Wuala and SpiderOak add client-side encryption -- so absolutely nobody can access your files without access to your computer. With any other cloud-sync'd folder service, it's prudent to add your own layer of client-side encryption using Boxcryptor. These services have the added benefit of off-site storage, allowing retrieval even if your computer crashes or is lost/stolen.

Automated database backups WITHOUT an internet connection:

Consider a stable Base configuration:
    When you use the default "embedded database" configuration it's just a matter of time before you'll encounter data corruption/loss. Base is not stable enough to host the database files inside the .odb container-file. See my signature links for a relatively "quick" way to migrate your existing data to a robust configuration with Base.
Last edited by DACM on Thu May 15, 2014 8:40 pm, edited 14 times in total.
AOO 4.1.x; LO 4.2.x; Windows 7/8 64-bit
Warning: Avoid embedded databases --> Solution: Adopt a portable 'split database' folder
Soli Deo gloria
User avatar
DACM
Volunteer
 
Posts: 1138
Joined: Tue Nov 03, 2009 7:24 am

Re: Database partly destroyed

Postby pm-c » Sun Feb 12, 2012 6:35 pm

Hej support!
I am a bit confused by the overwhelming amount of information, which on the other hand is very interesting..
I just want to
1) create a new safer database, and
2) include the backup file covering 2/3 of the original table in the new db.
Could you, please step by step, tell me what to do from OpenOffice's opening page where I choose database?
pm-c
OpenOffice 3.3.0 on Windows 7
pm-c
 
Posts: 3
Joined: Fri Feb 10, 2012 4:21 pm

Re: Database partly destroyed

Postby RoryOF » Sun Feb 12, 2012 6:48 pm

Before anything, read DACM's note on avoiding database corruption. That should set you on the right path.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29260
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Database partly destroyed

Postby pm-c » Thu Feb 23, 2012 4:41 pm

I have reinstalled openOffice to get rid of obsolete filenames in the Base dropdown menu.
Then i downloaded "Automatically create a new HSQLDB 2.x "multi-mode" database (Windows only)".
When I try to use the files "Ny database" (New database) and "Ny database1" I get the message:
"No connection to source Ny database - file input/output error java.lang.NullPointer.Exception.proporties
C:\Users\Documents\Ny database."
What do I do wrong?
pm-c
OpenOffice 3.3.0 on Windows 7
pm-c
 
Posts: 3
Joined: Fri Feb 10, 2012 4:21 pm

Re: Database partly destroyed

Postby Greengiant224 » Thu Feb 23, 2012 7:31 pm

pm-c:
"No connection to source Ny database - file input/output error java.lang.NullPointer.Exception.proporties
C:\Users\Documents\Ny database."
What do I do wrong?


You need to start the hsqldb v2.2+ server first by clicking on the start_server.bat file.
To stop the server use stop_server.bat Closing down the .odb file first.

Please bear in mind that as you are using Win7(64bit?) you need Java version 32bit for this to run successfully.

Also, please read the postings of DACM (do a search) he explains all of this set-up, beautifully.

Please come back if you need further help.

Greengiant224

Win 7, AOO 4.1.6, LibreOffice 6.1.* (Java 1.8.0_181) utilising HSQL 1.8.10 & 2.4.*, MySQL, PostgreSQL, SQLite
+ Blood, Sweat and Tears (Application, Determination and Perseverance)
User avatar
Greengiant224
 
Posts: 276
Joined: Wed Jun 09, 2010 3:50 pm
Location: All Over The World

Re: Database partly destroyed

Postby DACM » Fri Feb 24, 2012 12:58 am

pm-c wrote:When I try to use the files "Ny database" (New database) and "Ny database1" I get the message:
"No connection to source Ny database - file input/output error java.lang.NullPointer.Exception.proporties
C:\Users\Documents\Ny database."
What do I do wrong?

You're not doing anything wrong, but you may be getting ahead of yourself.

 Edit: It is now possible to run all versions of HSQLDB simultaneously, complete with legacy 'embedded database' support, using a single installation of Base. Simply adopt macro-enhanced templates to support your split-databases. You can drag-&-drop your existing Queries, Forms and Reports to the template, while copy-&-pasting your existing Macros. 


The "New Database" wizard in Base is effectively disabled when you upgrade to HSQLDB 2.x. And any legacy "embedded databases" (that you previously created with the "New Database" wizard in Base) are also inaccessible while Base is configured with HSQLDB 2.x support.

To re-gain legacy "embedded database" support, you can temporarily override HSQLDB 2.x support by following the instructions for: Manual "split-database" setup. But you'll have to undo this override to re-gain HSQLDB 2.x support in the future. It's actually easier to simply downgrade to the built-in version (HSQLDB 1.8.0.10) by running mydb.exe, perhaps only for migration purposes to the "multi-mode" configuration -- which can then be upgraded to HSQLDB 2.x by re-running the dedicated installer (hsqldb_OOo.exe). Or some find it easier to simply install LibreOffice Portable in addition to OOo to supply legacy "embedded database" support.

But as for creating a new HSQLDB 2.x database, if you opted to install the Base front-end files with the HSQLDB 2.x installation, then you should be running C:\Users\<current user>\Databases\mydb\mydb.file.odb without moving or renaming anything (at this point). Or you can run START.vbs or server.start.bat (also found in the mydb folder; START.vbs simply runs server.start.bat silently) to run the HSQLDB engine in server-mode. These methods create a new database as necessary when you click on the Tables icon in Base. To run in server-mode, you may need to edit the folder/paths in server.start.bat in order to reflect a non-default installation of OOo.
AOO 4.1.x; LO 4.2.x; Windows 7/8 64-bit
Warning: Avoid embedded databases --> Solution: Adopt a portable 'split database' folder
Soli Deo gloria
User avatar
DACM
Volunteer
 
Posts: 1138
Joined: Tue Nov 03, 2009 7:24 am


Return to Forms

Who is online

Users browsing this forum: No registered users and 2 guests