Rollbase Prod DB to Rollbase Test DB

Posted by Jorrit on 30-May-2016 07:24

hi, 

We have Rollbase privatecloud V 4.1.1.0

For test purposes we want to know if there is any posibility to place a copy of the production database to the test database every night.

If this is possible, what steps do we have to take?


Regards Jorrit

All Replies

Posted by Thierry Ciot on 30-May-2016 09:49

I'm not a production person but here is what I;m doing in in my development environment:

Hope this helps, Thierry.

With My SQL, I take DB backup on a regular basis that I can restore on same system in case of problems.  I have restored the backup on another RB system (a second development machine) without any problem.  One machine running Windows 7 and the other one Windows 10.

I do something like this:

mysqldump -u root -p rb_dbo2 > "\RB\rb_dbo-2016-May-30.sql"

mysql

use rb_dbo

source \rb\rb_dbo-2016-May-30.sql

This thread is closed