PostgreSQL/PgLoader: Difference between revisions

Revision as of 06:35, 3 December 2024

cat << EXE | sudo bash
apt-get update;echo
apt list -a --upgradable
apt-get install -y pgloader
EXE

cat << DDL \| mysql CREATE DATABASE IF NOT EXISTS academia; CREATE USER 'chorke'@'%' IDENTIFIED BY 'sadaqah!'; GRANT ALL PRIVILEGES ON academia.* TO 'chorke'@'%'; FLUSH PRIVILEGES; DDL

PostgreSQL » PgLoader » Migrate From MySQL PostgreSQL » PgBouncer PostgreSQL » PgLoader PostgreSQL » Helm PostgreSQL

Academia JavaEE Workspace in Ubuntu IntelliJ IDEA OpenLDAP OpenVPN MariaDB HAProxy Helm CIDR UFW K8s	K8s » Swiss Knife K8s » Ingress K8s » Service K8s » Run

@@ Line 6: / Line 6: @@
 EXE
 </syntaxhighlight>
+==Migration==
+{|
+|valign='top'|
+<syntaxhighlight lang="bash">
+cat << DDL | mysql
+CREATE DATABASE IF NOT EXISTS academia;
+CREATE USER 'chorke'@'%' IDENTIFIED BY 'sadaqah!';
+GRANT ALL PRIVILEGES ON academia.* TO 'chorke'@'%';
+FLUSH PRIVILEGES;
+DDL
+</syntaxhighlight>
+|valign='top'|
+|-
+|colspan='3'|
+----
+|-
+|valign='top'|
+|valign='top'|
+|}
 ==Playground==
 {|
 |valign='top'|
+<syntaxhighlight lang="bash">
+pgloader -h
+pgloader -V
+</syntaxhighlight>
 |valign='top'|