Connection to mariaDB generates tables, but does not migrate information

classic Classic list List threaded Threaded
3 messages Options
| Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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/
| Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Connection to mariaDB generates tables, but does not migrate information

Nate Coraor (nate@bx.psu.edu)
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 <[hidden email]> 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/
| Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: 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 <[hidden email]
> <mailto:[hidden email]>> 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/ <https://lists.galaxyproject.org/>
>
>     To search Galaxy mailing lists use the unified search at:
>     http://galaxyproject.org/search/mailinglists/
>     <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/
Loading...