Database download and upload
No edit summary
(Adding page to Category:TOC because it contains a TOC.)
 
(23 intermediate revisions by 5 users not shown)
Line 1: Line 1:
If you want to test some new thing and don`t move your app on the new site or you want to make a backup of your app you can use this Snapshot and Upload function.
== Purpose ==
If you want to test something new without moving your app to a new site or making a backup of your app, you can use this Snapshot and Upload function.


== Snapshot and download ==
== Snapshot and Download ==
Start MDriven Designer and head to "'''CloudForm'''" tab, if it's needed please log in in your MDriven Turnkey account.
Start MDriven Designer and head to the "'''CloudForm'''" tab. If needed, please log in to your MDriven Turnkey account.


Choose the web site which you want to backup.
Choose the website to which you want to backup.
[[File:Choosing your site for the snapshot of admin DB.jpg|none|thumb|Choose the site you needed to backup/replace.]]
[[File:Choosing your site for the snapshot of admin DB.jpg|none|thumb|Choose the site you needed to backup/replace.]]
After choosing the site head to '''Admin DB Access and Swap''' tab.
After choosing the site, head to the '''Admin DB Access and Swap''' tab.


Press "'''Snapshot Admin DB'''" to take a snapshot of your database.
Press "'''Snapshot Admin DB'''" to take a snapshot of your database.
Line 12: Line 13:
After this, you can download your DB on your computer by clicking the "'''Download Snapshot Admin db'''" button.
After this, you can download your DB on your computer by clicking the "'''Download Snapshot Admin db'''" button.


== Upload the datebase snapshot ==
=== Read or Edit the Backup Database ===
To upload your database snapshot you need to choose the site you need.
[[Documentation:MDrivenServer, opening the built-in database|MDrivenServer, opening the built-in database]]
 
== Upload the Database Snapshot ==
To upload your database snapshot, you must choose the site you need.


Head to '''Admin DB Access and Swap''' tab and choose the path to your local database snapshot.
Head to '''Admin DB Access and Swap''' tab and choose the path to your local database snapshot.
Line 19: Line 23:
Click "'''Upload Admin db for replace'''".
Click "'''Upload Admin db for replace'''".


Here's a video showing how to [[Snapshot And Upload]] the MDriven server's database.
You can use this as a simple backup solution.
<p class="warn">
<em>To make your experience more comfortable, we set the main tags mentioned in the video to the right bar menu of this mini player. Choose the interesting subtitle on the list and immediately get to the exact theme timeplace in the video. Now you can pick any topic to be instructed without watching the whole video.</em> </p>
<style type="text/css">
p.warn {
opacity: 0.6;
text-align: justify;
opacity: 0.7
width: 90%
}
#video12 {
  position: relative;
  padding-bottom: 10px;
}
#video12::after {
  content: "";
  display: table;
  clear: both;
}
#video12 iframe {
  width: 100%;
  min-width: 200px;
  max-width: 740px;
  height: 500px;
  float: left;
}


@media (max-width: 767px) {
== Video Tutorial ==
  #video12 iframe {
<html>
    height: 180px;
  }
}


#video12 div {
<p class="video-warn">
  float: left;
   To make your experience smooth, we set the main tags mentioned in the video to the right bar menu of this mini-player. Choose an interesting subtitle on the list and immediately get to the exact theme navigation item place in the video. Now you can pick any topic to be instructed on without watching the whole video.
  padding-left: 10px;
overflow-y: auto;
height: 500px;
}
span.time {
    display:block;
   padding: 2px 10px 2px 10px;
    padding-bottom: 0.5em;
    padding-top: 0.5em;
  opacity: 0.7;
}
span.time:hover {
  color: #0000FF;
  cursor: pointer;
}
span.time:focus {
  color: blue;
}
</style>


<br>
 
<div id="video12">
</p>
<iframe width="740" height="500" src="https://www.youtube.com/embed/mtOHl-AsyNU?rel=0&autoplay=0" frameborder="0" allowfullscreen></iframe>
 
   <div>
<div class="video">
    <span class="time" data-video="mtOHl-AsyNU" data-start="40" tabindex="0"> Admin DB Access and Swap </span>
  <div class="video__wrapper">
    <span class="time" data-video="mtOHl-AsyNU" data-start="213" tabindex="0"> Bringing back the Model with the Snapshot </span>
    <iframe src="https://www.youtube.com/embed/qegsZDwGOTk?rel=0&autoplay=0" frameborder="0" allowfullscreen></iframe>
    <span class="time" data-video="mtOHl-AsyNU" data-start="341" tabindex="0"> Newest Version of the Turnkey software
   </div>
  <div class="video__navigation">
      <span class="navigation-item" data-video="qegsZDwGOTk" data-start="321" tabindex="0"> Snapshot and Upload </span>
      <span class="navigation-item" data-video="qegsZDwGOTk" data-start="361" tabindex="0"> Admin DB Access and Swap </span>
      <span class="navigation-item" data-video="qegsZDwGOTk" data-start="444" tabindex="0"> Bringing back the Model with the Snapshot </span>
      <span class="navigation-item" data-video="qegsZDwGOTk" data-start="572" tabindex="0"> Newest Version of the Turnkey software
     (portal.MDriven.net) </span>
     (portal.MDriven.net) </span>
</div>
  </div>
</div>
</div>


You can use this as a simple backup solution.
</html>
 
==== Opening and viewing the database snapshot ====
If you want to open the downloaded DatabaseCompact.sdf database file, we recommend using Linqpad (http://www.linqpad.net).
 
When opening the sdf-file, select SQL CE 4.0 driver. If Linqpad can't find the driver, download Microsoft SQL Server Compact 4.0 database driver from Microsoft and install it, then restart Linqpad.
 
Please note that all database tables are prefixed with '''A0_''' for the modelled database and '''Admin_''' for the MDriven servers own database.


[[Category:Database]]
[[Category:Database]]
[[Category:SQL]]
[[Category:SQL]]
[[Category:MDriven Server]]
[[Category:MDriven Server]]
{{Edited|July|12|2024}}
[[Category:TOC]]

Latest revision as of 13:46, 26 March 2024

Purpose

If you want to test something new without moving your app to a new site or making a backup of your app, you can use this Snapshot and Upload function.

Snapshot and Download

Start MDriven Designer and head to the "CloudForm" tab. If needed, please log in to your MDriven Turnkey account.

Choose the website to which you want to backup.

Choose the site you needed to backup/replace.

After choosing the site, head to the Admin DB Access and Swap tab.

Press "Snapshot Admin DB" to take a snapshot of your database.

Take a snapshot of your admin database.

After this, you can download your DB on your computer by clicking the "Download Snapshot Admin db" button.

Read or Edit the Backup Database

MDrivenServer, opening the built-in database

Upload the Database Snapshot

To upload your database snapshot, you must choose the site you need.

Head to Admin DB Access and Swap tab and choose the path to your local database snapshot.

Choose your local DB copy.

Click "Upload Admin db for replace".

You can use this as a simple backup solution.

Video Tutorial

To make your experience smooth, we set the main tags mentioned in the video to the right bar menu of this mini-player. Choose an interesting subtitle on the list and immediately get to the exact theme navigation item place in the video. Now you can pick any topic to be instructed on without watching the whole video.

Snapshot and Upload Admin DB Access and Swap Bringing back the Model with the Snapshot Newest Version of the Turnkey software (portal.MDriven.net)

This page was edited more than 9 months ago on 03/26/2024. What links here
Retrieved from "https://newwikicopy.mdriven.net/index.php?title=Documentation:Database_download_and_upload&oldid=17723"

© MDRIVEN . All Rights Reserved

Glossary API Docs
MDriven World | Portal | Blog | YouTube | StackOverflow | Facebook

© MDRIVEN . All Rights Reserved