How Portable are Derby-managed data?

[niloofar montazeri <mo...@gmail.com>]

Hi,

I am a MySql user and am searching for a light-weight database system that
allows me to *easily move tables from one machine to another*. My problem
with MySql was that in order to move data from machine m1 to machine m2, I
needed to stop the server on m2, move the entire data folder (i.e., all the
databases and tables) from m1 to m2 and then restart the server on m2 (If I
was lucky and it would easily restart).
Maybe I am not familiar with correct MySql settings, but I need an easy to
install tool for sorting, counting, indexing and merging data that allows
for high portability. Is Derby the right tool for this purpose?

I appreciate your help...
Niloofar

Re: How Portable are Derby-managed data?

[Peter Ondruška <pe...@gmail.com>]

http://db.apache.org/derby/docs/10.7/adminguide/cadminhubbkup63476.html

On Thu, Apr 7, 2011 at 5:59 AM, niloofar montazeri
<mo...@gmail.com> wrote:
> Hi,
>
> I am a MySql user and am searching for a light-weight database system that
> allows me to easily move tables from one machine to another. My problem with
> MySql was that in order to move data from machine m1 to machine m2, I needed
> to stop the server on m2, move the entire data folder (i.e., all the
> databases and tables) from m1 to m2 and then restart the server on m2 (If I
> was lucky and it would easily restart).
> Maybe I am not familiar with correct MySql settings, but I need an easy to
> install tool for sorting, counting, indexing and merging data that allows
> for high portability. Is Derby the right tool for this purpose?
>
> I appreciate your help...
> Niloofar
>



-- 
Peter