Connection to mariaDB generates tables, but does not migrate information
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.
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 <eclark28@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/
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 <eclark28@fau.edu <mailto:eclark28@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/ <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/
participants (3)
-
evan clark
-
Hans-Rudolf Hotz
-
Nate Coraor