Data at Your Fingertips: Explore Our New Reporting and Statistical Capabilities By Ryan Ashbrook Yesterday at 01:29 PM
MartynSanders Posted March 28 Share Posted March 28 (edited) Good evening, I have an onprem installation and I want to copy the live content to my test-instance. Are there any solutions? I didn't found something right now - maybe I didn't looked for the correct wording in Google. Or maybe can I just copy some table, like users, categories and content? I don't have much customised (only css, javascript, etc.). Thanks for your help in advance! Greetings Martyn Edited March 28 by MartynSanders The Old Man 1 Link to comment Share on other sites More sharing options...
Randy Calvert Posted March 28 Share Posted March 28 This post was recognized by Marc Stridgen! Randy Calvert was awarded the badge 'Helpful' and 5 points. Export your PRODDB. Import it into a new database (DEVDB) Assign a mySQL username/password that only has access to the dev instance Copy the home folder of your prod site to the test instance (rsync or download everything and upload) On the dev instance, edit the conf_global.php file to update the mySQL info, and edit the board URL to reflect the correct URL of the test instance. This makes the assumption you're not using other external services such as Redis or Elasticsearch, etc. I generally would not setup cron on the test instance in case other tasks such as commerce billing run on your prod instance that would potentially end up as duplicates. Link to comment Share on other sites More sharing options...
MartynSanders Posted March 29 Author Share Posted March 29 11 hours ago, Randy Calvert said: Export your PRODDB. Import it into a new database (DEVDB) Assign a mySQL username/password that only has access to the dev instance Copy the home folder of your prod site to the test instance (rsync or download everything and upload) On the dev instance, edit the conf_global.php file to update the mySQL info, and edit the board URL to reflect the correct URL of the test instance. This makes the assumption you're not using other external services such as Redis or Elasticsearch, etc. I generally would not setup cron on the test instance in case other tasks such as commerce billing run on your prod instance that would potentially end up as duplicates. Hi Randy, thank you - easier than I thought. I'll give you feedback if it worked. Greetings Link to comment Share on other sites More sharing options...
Nathan Explosion Posted March 29 Share Posted March 29 This post was recognized by Marc Stridgen! Nathan Explosion was awarded the badge 'Helpful' and 5 points. On the resulting test instance, please create a constants.php file in the root (same location as the conf_global.php) Content should be <?php and then think about the following: To avoid actually sending out email to users...(create an 'email' folder in the root of the installation) \define('EMAIL_DEBUG_PATH', 'email'); If you use Commerce, add this to ensure that you aren't going to end up double-charging for items that may be renewable \define('NEXUS_TEST_GATEWAYS', true); If you already have a constants.php file then it may have content in there specific to your production installation, and it may need to be modified to avoid affecting the production instance (caching stuff, for example) In this case, post the current contents for advice. balazsp, The Old Man and G17 Media 2 1 Link to comment Share on other sites More sharing options...
PatrickRQ Posted March 29 Share Posted March 29 @Marc Stridgen Quote Nathan Explosion was awarded the badge 'Helpful' and 5 points. What @Nathan Explosion wins when he will collect 100 points? 😂 Link to comment Share on other sites More sharing options...
Marc Stridgen Posted March 29 Share Posted March 29 10 minutes ago, PatrickRQ said: @Marc Stridgen What @Nathan Explosion wins when he will collect 100 points? 😂 Life size cardboard cutout of myself, of course! The Old Man 1 Link to comment Share on other sites More sharing options...
PatrickRQ Posted March 29 Share Posted March 29 2 hours ago, Marc Stridgen said: Life size cardboard cutout of myself, of course! I better start collecting the points, want one too! The Old Man and Marc Stridgen 2 Link to comment Share on other sites More sharing options...
The Old Man Posted April 4 Share Posted April 4 Nathan's post was a prime candidate for warranting an "Add to Google Notes" share button! Link to comment Share on other sites More sharing options...
Recommended Posts