Re: [galaxy-dev] Connection to mariaDB generates tables, but does not migrate information

[Hans-Rudolf Hotz]

Hi Evan

Although, this is a MySQL to PostgreSQL migration, you might find some 
ideas and tricks for you case as well:


https://wiki.galaxyproject.org/Community/Log/2015/MySQL2PostgreSQL


Regards, Hans-Rudolf


On 12/19/2016 06:46 PM, Nate Coraor wrote:

Hi Evan,

Migration only refers to the schema. Galaxy does not copy data between
databases for you. You'll need to dump the data from your old database
(sqlite?) and load it into the new one. We don't have instructions for
this but most general guides for this conversion available on the web
should get you started.

Thanks,
--nate

On Mon, Dec 19, 2016 at 12:26 PM, evan clark mailto:eclar...@fau.edu>> wrote:

I connected our galaxy instance to mariadb with no connection issues
and it began to migrate the data, I noticed however when galaxy was
finally started the tables were generated, but no data was migrated.
It completed the migration without error so I am not sure if there
is a setting I missed in mariadb.
___
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
https://lists.galaxyproject.org/ 

To search Galaxy mailing lists use the unified search at:
http://galaxyproject.org/search/mailinglists/





___
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
   https://lists.galaxyproject.org/

To search Galaxy mailing lists use the unified search at:
   http://galaxyproject.org/search/mailinglists/


___
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
 https://lists.galaxyproject.org/

To search Galaxy mailing lists use the unified search at:
 http://galaxyproject.org/search/mailinglists/

Re: [galaxy-dev] Connection to mariaDB generates tables, but does not migrate information

[Nate Coraor]

Hi Evan,

Migration only refers to the schema. Galaxy does not copy data between
databases for you. You'll need to dump the data from your old database
(sqlite?) and load it into the new one. We don't have instructions for this
but most general guides for this conversion available on the web should get
you started.

Thanks,
--nate

On Mon, Dec 19, 2016 at 12:26 PM, evan clark  wrote:

> I connected our galaxy instance to mariadb with no connection issues and
> it began to migrate the data, I noticed however when galaxy was finally
> started the tables were generated, but no data was migrated. It completed
> the migration without error so I am not sure if there is a setting I missed
> in mariadb.
> ___
> Please keep all replies on the list by using "reply all"
> in your mail client.  To manage your subscriptions to this
> and other Galaxy lists, please use the interface at:
>  https://lists.galaxyproject.org/
>
> To search Galaxy mailing lists use the unified search at:
>  http://galaxyproject.org/search/mailinglists/
___
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
  https://lists.galaxyproject.org/

To search Galaxy mailing lists use the unified search at:
  http://galaxyproject.org/search/mailinglists/

[galaxy-dev] Connection to mariaDB generates tables, but does not migrate information

[evan clark]

I connected our galaxy instance to mariadb with no connection issues and 
it began to migrate the data, I noticed however when galaxy was finally 
started the tables were generated, but no data was migrated. It 
completed the migration without error so I am not sure if there is a 
setting I missed in mariadb.

___
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
 https://lists.galaxyproject.org/

To search Galaxy mailing lists use the unified search at:
 http://galaxyproject.org/search/mailinglists/