Duplicating a Database on another Instance for testing purposes

Hi,


I have 3 erpnext database running and I have kind of cloned one of the database on another instance for testing purposes, now I would like to test the other 2 databases as well on the test instance and I would like to know what should I do to restore the other 2 databases on the same test instance since I am not looking to make more than 1 instance for testing purposes.

Let me explain the situation here:

  1. I have 3 instances of erpnext with different databases running on different ports like A, B and C.
  2. I have another 4th instance which I use for testing purposes and currently it is a copy of database A.
  3. Whenever I want to update the 4th instance I generally take a backup of A and restore in on the test account.
  4. Now I want to know how to clone database B and C on test (4th instance)
  5. I know the procedure would be similar to the one mentioned in the wiki here, but I wanted to know what different steps I need to take to get the things done properly.
Kindly let me know if I need to follow the same procedure in wiki or should I go for some additional steps.



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.

     

     
Aditya,

Do you want to merge all three in the test db? Thats not trivial. Its best to have 3 test databases or individually restore one by one.

best,
Rushabh

T: @rushabh_mehta

On 29-Jul-2013, at 12:12 PM, Aditya Duggal <ad...@gmail.com> wrote:

Hi,

I have 3 erpnext database running and I have kind of cloned one of the database on another instance for testing purposes, now I would like to test the other 2 databases as well on the test instance and I would like to know what should I do to restore the other 2 databases on the same test instance since I am not looking to make more than 1 instance for testing purposes.

Let me explain the situation here:

  1. I have 3 instances of erpnext with different databases running on different ports like A, B and C.
  2. I have another 4th instance which I use for testing purposes and currently it is a copy of database A.
  3. Whenever I want to update the 4th instance I generally take a backup of A and restore in on the test account.
  4. Now I want to know how to clone database B and C on test (4th instance)
  5. I know the procedure would be similar to the one mentioned in the wiki here, but I wanted to know what different steps I need to take to get the things done properly.
Kindly let me know if I need to follow the same procedure in wiki or should I go for some additional steps.



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.

     

     



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.

     

     
No I don't want to merge the 3 dbs. Instead I want to test the 3 dbs separately and hence if I want to test DB A then I would restore A's backup on test and then after testing A, I could restore the db of B and so on.

Just wanted to know if this is the correct approach or would restoring B's backup on A's backup would create any issues.


On Mon, Jul 29, 2013 at 12:38 PM, Rushabh Mehta <rm...@gmail.com> wrote:

Aditya,


Do you want to merge all three in the test db? Thats not trivial. Its best to have 3 test databases or individually restore one by one.


best,

Rushabh



On 29-Jul-2013, at 12:12 PM, Aditya Duggal <ad...@gmail.com> wrote:

Hi,

I have 3 erpnext database running and I have kind of cloned one of the database on another instance for testing purposes, now I would like to test the other 2 databases as well on the test instance and I would like to know what should I do to restore the other 2 databases on the same test instance since I am not looking to make more than 1 instance for testing purposes.

Let me explain the situation here:

  1. I have 3 instances of erpnext with different databases running on different ports like A, B and C.
  2. I have another 4th instance which I use for testing purposes and currently it is a copy of database A.
  3. Whenever I want to update the 4th instance I generally take a backup of A and restore in on the test account.
  4. Now I want to know how to clone database B and C on test (4th instance)
  5. I know the procedure would be similar to the one mentioned in the wiki here, but I wanted to know what different steps I need to take to get the things done properly.
Kindly let me know if I need to follow the same procedure in wiki or should I go for some additional steps.



Note:



If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.



    End of Note



    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.







Note:



If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.



    End of Note



    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.







Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.

     

     
Hi Aditya,

You can keep using lib/wnf.py --install TEST_DB_NAME DATABASE.SQL for each db.

Thanks,
Anand.

On 29-Jul-2013, at 12:40 PM, Aditya Duggal <ad...@rigpl.com> wrote:

No I don't want to merge the 3 dbs. Instead I want to test the 3 dbs separately and hence if I want to test DB A then I would restore A's backup on test and then after testing A, I could restore the db of B and so on.

Just wanted to know if this is the correct approach or would restoring B's backup on A's backup would create any issues.


On Mon, Jul 29, 2013 at 12:38 PM, Rushabh Mehta <rm...@gmail.com> wrote:

Aditya,


Do you want to merge all three in the test db? Thats not trivial. Its best to have 3 test databases or individually restore one by one.


best,

Rushabh



On 29-Jul-2013, at 12:12 PM, Aditya Duggal <ad...@gmail.com> wrote:

Hi,

I have 3 erpnext database running and I have kind of cloned one of the database on another instance for testing purposes, now I would like to test the other 2 databases as well on the test instance and I would like to know what should I do to restore the other 2 databases on the same test instance since I am not looking to make more than 1 instance for testing purposes.

Let me explain the situation here:

  1. I have 3 instances of erpnext with different databases running on different ports like A, B and C.
  2. I have another 4th instance which I use for testing purposes and currently it is a copy of database A.
  3. Whenever I want to update the 4th instance I generally take a backup of A and restore in on the test account.
  4. Now I want to know how to clone database B and C on test (4th instance)
  5. I know the procedure would be similar to the one mentioned in the wiki here, but I wanted to know what different steps I need to take to get the things done properly.
Kindly let me know if I need to follow the same procedure in wiki or should I go for some additional steps.



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 





Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 





Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.

     

     



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.