summaryrefslogtreecommitdiff
path: root/bin/freeside-mysql.load
diff options
context:
space:
mode:
authorMark Wells <mark@freeside.biz>2016-03-20 16:41:14 -0700
committerMark Wells <mark@freeside.biz>2016-03-20 16:41:27 -0700
commit6ddb8c85f963358bbb1797308df95465b4c2b160 (patch)
tree88c99cc7c0f600ebac6b9b0175bb915fffbbd017 /bin/freeside-mysql.load
parent6b285a7d0b37bb1dfd1972eead37a45bff977651 (diff)
add pgloader config to migrate from mysql, #39756
Diffstat (limited to 'bin/freeside-mysql.load')
-rw-r--r--bin/freeside-mysql.load6
1 files changed, 6 insertions, 0 deletions
diff --git a/bin/freeside-mysql.load b/bin/freeside-mysql.load
new file mode 100644
index 000000000..02f47daf3
--- /dev/null
+++ b/bin/freeside-mysql.load
@@ -0,0 +1,6 @@
+LOAD DATABASE
+ FROM mysql://freeside@/freeside
+ INTO postgresql://freeside@/freeside
+WITH include drop, create tables, reset sequences, create indexes
+CAST type varbinary to varchar
+;