Re: [galaxy-dev] Moving Data to New Instance

2012-05-17 Thread Robert Chase
Hi Hans,

Thankyou! I tried this;

mysqldump -u galaxy_user -p galaxy > db-name.out

mysql -u galaxy_user -p galaxy < db-name.out

and it seemed to work:) I needed to run

manage_db.sh

to upgrade the schema but it ran without incident. All of the datasets in
our old server now appear on our test server and I can download them into
my history.

-Rob

On Wed, May 16, 2012 at 3:48 AM, Hans-Rudolf Hotz  wrote:

>
>
> On 05/15/2012 05:42 PM, Robert Chase wrote:
>
>> Hello All,
>>
>> We have a large amount of data on our production server that we would
>> like to make available on our new test server. I tried to move data from
>> our production server to our test server by copying the meta-data files
>> and dataset files from ~/database/files to the new test server but it
>> didn't work. Is there a way to move the datasets en mass?
>>
>
> Hi Rob
>
>
> At the risk of repeating myself - sorry: You need a copy of your MySQL
> database for your new test instance of galaxy to connect to.
>
> what exactly does not work? what kind of error messages do you get?
>
>
> Regards, Hans
>
>
>
>
>> -Rob
>>
>>
>> __**_
>> 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:
>>
>>   http://lists.bx.psu.edu/
>>
>
___
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:

  http://lists.bx.psu.edu/

Re: [galaxy-dev] Moving Data to New Instance

2012-05-16 Thread Hans-Rudolf Hotz



On 05/15/2012 05:42 PM, Robert Chase wrote:

Hello All,

We have a large amount of data on our production server that we would
like to make available on our new test server. I tried to move data from
our production server to our test server by copying the meta-data files
and dataset files from ~/database/files to the new test server but it
didn't work. Is there a way to move the datasets en mass?


Hi Rob


At the risk of repeating myself - sorry: You need a copy of your MySQL 
database for your new test instance of galaxy to connect to.


what exactly does not work? what kind of error messages do you get?


Regards, Hans





-Rob


___
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:

   http://lists.bx.psu.edu/

___
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:

 http://lists.bx.psu.edu/


[galaxy-dev] Moving Data to New Instance

2012-05-15 Thread Robert Chase
Hello All,

We have a large amount of data on our production server that we would like
to make available on our new test server. I tried to move data from our
production server to our test server by copying the meta-data files and
dataset files from ~/database/files to the new test server but it didn't
work. Is there a way to move the datasets en mass?

-Rob
___
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:

  http://lists.bx.psu.edu/