Moving Data to New Instance
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
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:
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 <hrh@fmi.ch> 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:
participants (2)
-
Hans-Rudolf Hotz -
Robert Chase