There were a couple of factors related to this initial post. First, was
that I'd encountered a somewhat minor problem with an application that
I've been using for a bit more than 15 years without any prior problem.
Second, I do some work with relational databases and thought I should
know how to do such things with Derby.
The minor problem was a failure to allow insertion of a specific new row
into a table. Based on knowledge of what was being shown to be in the
database this should have worked fine. Other insertions were also
working as expected. Therefore, I deduced that a plausible explanation
would be some kind of corruption that may have crept into the underlying
files used to store the data. This could have happened anytime but based
on the specific elements involved I thought it likely to be something
that happened long ago.
Therefore, my idea was to want to recover as much of the data as
possible and then create a new database using that data. I determined
that when it came to your suggestions 2i was the only one that fit this
criteria. In that, this produces new database files that are completely
independent from the original ones. Fortunately, my archives did have a
text file that contained the SQL for creating the tables. I haven't
used the resulting database much yet but I was able to insert the row
that previously failed and have no reason to think there is any problem.
When compared to the MySQL/phpMyAdmin export/import technique this one
is NOT quite as simple. On the other hand ending up with the data in
.csv format could be considered more desirable for generalized
compatibility reasons than the SQL format used for MySQL.
Would be grateful to learn about any flaws in my assessment of this
situation and many thanks for the help.
ajax ...
On 6/29/2020 6:40 PM, Rick Hillegas wrote:
Hi Ajax,
I don't know why you are not receiving email which I posted to the
derby-user list. In any event, you can try posting your messages both
to me and to derby-user. I will respond to all so that you and
derby-user should be copied on the whole conversation.
Thanks,
-Rick
On 6/29/20 7:39 AM, [email protected] wrote:
<quote author='Rick Hillegas-3'>
Hi Ajax,
Here are a couple points to consider:
...
</quote>
Quoted from:
http://apache-database.10148.n7.nabble.com/How-to-migrate-a-Derby-database-tp151268p151269.html
I'm NOT completely sure what I'm doing right now. I think this
message should end up being an email addressed to Rick Hillegas. I'm
able to do this because of his reply to my original post which was
done by sending an email. It seems that I'm not able to respond to
that reply via the website being used to send this message. I sort
of thought your reply might have shown up in my inbox as a result of
having subscribed to the mailing list. However, even after checking
SPAM boxes I can find nothing.
While I do have a question related to your excellent reply to my
original post, the question for now is "How am I supposed to submit
such questions? In that, how to respond to your reply?".
_____________________________________
Sent from http://apache-database.10148.n7.nabble.com
