[Solved] Lost the data from a table

Creating tables and queries

[Solved] Lost the data from a table

Postby ahtea » Tue Mar 13, 2018 9:48 pm

I have lost all the data from one of my tables. The fields are present, but there is no data.
If I look at the .data file in Notepad, it *looks* like the data is there, though.
The other tables appear to be intact.
Back story:
I'm an inexperienced user. I was trying to do some INSERTs into the table.
I first copied the .data file to another directory.
After trying some SQL insert commands I decided to restore the original .data file.
I closed Base, copied the original .data file back and restarted BASE.
The table had no records left.

Is there anything I can do to restore the table?

EDIT: The data was recovered by taking the four files, .data, .properties, .backup, .script and open them with HSQL Version 2.4.1 ( it is a beta at the moment ) and use SqlTool.jar to export ( extract ) the data from the one table.
Thank you Sliderule!
Last edited by ahtea on Thu Mar 15, 2018 4:18 pm, edited 4 times in total.
Apache OpenOffice 4.1.5
Windows 8.1
ahtea
 
Posts: 2
Joined: Tue Mar 13, 2018 9:18 pm

Re: Lost the data from a table

Postby Sliderule » Tue Mar 13, 2018 11:43 pm

ahtea wrote:I have lost all the data from one of my tables. The fields are present, but there is no data.
If I look at the .data file in Notepad, it *looks* like the data is there, though.
The other tables appear to be intact.
Back story:
I'm an inexperienced user. I was trying to do some INSERTs into the table.
I first copied the .data file to another directory.
After trying some SQL insert commands I decided to restore the original .data file.
I closed Base, copied the original .data file back and restarted BASE.
The table had no records left.

Is there anything I can do to restore the table?

It is impossible for me to answer your question, unless, I can see ( look at a copy ) of your Base file ( *.odb ).

Upload a copy of your Base file ( *.odb ) here, or, to a link that I can see it, such as:

https://www.mediafire.com/

Sliderule
User avatar
Sliderule
Volunteer
 
Posts: 1161
Joined: Thu Nov 29, 2007 9:46 am

Re: Lost the data from a table

Postby ahtea » Tue Mar 13, 2018 11:58 pm

I uploaded the .odb, .data and associated files to the mediafire, into an account just created.
Hope it was done correctly!
http://www.mediafire.com/folder/zyvwvho2ur5re/Database
Apache OpenOffice 4.1.5
Windows 8.1
ahtea
 
Posts: 2
Joined: Tue Mar 13, 2018 9:18 pm

Re: Lost the data from a table

Postby Sliderule » Wed Mar 14, 2018 2:37 am

ahtea:

I just sent you a PM ( Private Message ).

Sliderule
User avatar
Sliderule
Volunteer
 
Posts: 1161
Joined: Thu Nov 29, 2007 9:46 am


Return to Tables & Queries

Who is online

Users browsing this forum: No registered users and 2 guests