Additional Information

FOLDER Structure for Data Storage. Back to TOP

1. Data from Scans is saved in the root folder defined in experiment editor as

ROOT\year\month\day\scans\scan number\(device folders, tdms file etc)

WARNING: The data structure should not be changed manually. The data may be copied but not deleted or moved to a different location

Procedure to backup SQL computer locally. Back to TOP

1. Create a file called backup.sh on the ubuntu computer.

2. Copy the following script to backup.sh and save to /home/loasis/Documents folder

##########################################

#script for loasis sql DB local back up

#########################################

filenamepre="Dump"

day=$(date +%Y-%m-%d--%H:%M:%S)

filename="$filenamepre-$day.sql"

location="/home/loasis/dumps/"

backupfile="$location$filename"

database="loasis"

user="root"

password="dat+l0sim"

sudo mysqldump --user=$user --password=$password $database>$backupfile

3. Open Terminal on the Ubuntu Computer

4. Type sudo crontab -e

type below the comments, 0 0 * * * bash /home/loasis/Documents/backup.sh

5. Save and Exit

6. The mysql db will be dumped every night at 12:00 AM in the /home/loasis/dumps folder