Backup - Revision history

KKoPV: /* Backup with API */

2014-09-28T15:43:18Z

‎Backup with API

KKoPV: /* Backup with API */

2014-09-28T15:42:35Z

‎Backup with API

KKoPV: /* Backup with API */

2014-09-28T15:42:13Z

‎Backup with API

KKoPV at 11:37, 14 May 2014

2014-05-14T11:37:20Z

KKoPV: /* Backup with API */

2014-03-06T14:57:19Z

‎Backup with API

KKoPV: /* Backup with API */

2014-03-06T14:55:43Z

‎Backup with API

KKoPV at 14:52, 6 March 2014

2014-03-06T14:52:18Z

KKoPV: Created page with "== Database backup == A full database backup is quite simple. $ mysqldump -u [username] -p[password] -h [host] [databaseName] >PVLng-$(date +"Y-m-d").sql It just dumps all..."

2014-02-27T12:25:19Z

Created page with "== Database backup == A full database backup is quite simple. $ mysqldump -u [username] -p[password] -h [host] [databaseName] >PVLng-$(date +"Y-m-d").sql It just dumps all..."

New page

== Database backup ==

A full database backup is quite simple.

$ mysqldump -u [username] -p[password] -h [host] [databaseName] >PVLng-$(date +"Y-m-d").sql

It just dumps all data into a date stamped SQL file.

== Backup with API ==

If you are interested in CSV/TSV data as backup, you can do this by requesting all data for a channel via the API

$ GUID=your_GUID_here
<nowiki>$ wget -o PVLng-$GUID-$(date +"Y-m-d").csv http://your.domain.here/api/r3/data/$GUID.csv?start=0&full=1</nowiki>

* <tt>start=0</tt> - all data since 1970...
* <tt>full=1</tt> - extract also the readable date+time column

[[Category:HowTo]]
[[Category:Example]]

@@ Line 37: / Line 37: @@
   ### Read all real channels, but WITHOUT RANDOM channels
-  wget -qO - $host/api/r3/channels.csv | grep -v "RANDOM " | \
+  wget -qO - $host/api/latest/channels.csv | grep -v "RANDOM " | \
   while read id GUID name dummy; do
     ### remove text delimiters

@@ Line 43: / Line 43: @@
     echo -n "$(date) $GUID - $name ... "
-    wget -q --header="X-PVLng-Key: $apikey" -O $destination/$GUID-$(date +"Y-m-d").csv $host/api/r3/data/$GUID.csv?start=0&full=1
+    wget -q --header="X-PVLng-Key: $apikey" -O $destination/$GUID-$(date +"Y-m-d").csv $host/api/latest/data/$GUID.csv?start=0&full=1
     echo Done.
   done
   echo $(date) Finished.

@@ Line 14: / Line 14: @@
   # GUID=your_GUID_here
-  <nowiki># wget -O PVLng-$GUID-$(date +"Y-m-d").csv http://your.domain.here/api/r3/data/$GUID.csv?start=0&full=1</nowiki>
+  <nowiki># wget -O PVLng-$GUID-$(date +"Y-m-d").csv http://your.domain.here/api/latest/data/$GUID.csv?start=0&full=1</nowiki>
 * <tt>start=0</tt> - all data since 1970...

@@ Line 1: / Line 1: @@
 == Database backup ==
 A full database backup is quite simple.
-  $ mysqldump -u [username] -p[password] -h [host] [databaseName] >PVLng-$(date +"Y-m-d").sql
+  # mysqldump -u [username] -p[password] -h [host] [databaseName] >PVLng-$(date +"Y-m-d").sql
 It just dumps all data into a date stamped SQL file.
@@ Line 11: / Line 13: @@
 If you are interested in CSV/TSV data as backup, you can do this by requesting all data for a channel via the API
-  $ GUID=your_GUID_here
+  # GUID=your_GUID_here
-  <nowiki>$ wget -O PVLng-$GUID-$(date +"Y-m-d").csv http://your.domain.here/api/r3/data/$GUID.csv?start=0&full=1</nowiki>
+  <nowiki># wget -O PVLng-$GUID-$(date +"Y-m-d").csv http://your.domain.here/api/r3/data/$GUID.csv?start=0&full=1</nowiki>
 * <tt>start=0</tt> - all data since 1970...
@@ Line 46: / Line 48: @@
   echo $(date) Finished.

@@ Line 15: / Line 15: @@
 * <tt>start=0</tt> - all data since 1970...
-* <tt>full=1 </tt> - extract also the readable date+time column
+* <tt>full=1&nbsp;</tt> - extract also the readable date+time column
 As script:

@@ Line 12: / Line 12: @@
   $ GUID=your_GUID_here
-  <nowiki>$ wget -o PVLng-$GUID-$(date +"Y-m-d").csv http://your.domain.here/api/r3/data/$GUID.csv?start=0&full=1</nowiki>
+  <nowiki>$ wget -O PVLng-$GUID-$(date +"Y-m-d").csv http://your.domain.here/api/r3/data/$GUID.csv?start=0&full=1</nowiki>
 * <tt>start=0</tt> - all data since 1970...
 * <tt>full=1</tt> - extract also the readable date+time column
 [[Category:HowTo]]
 [[Category:Example]]