Differences

This shows you the differences between two versions of the page.

--- onny:notizen [2022/08/16 17:45] – 10.25.0.100
+++ onny:notizen [2022/09/17 13:39] – [postgresql] 10.25.0.100
@@ Line 2142: / Line 2142: @@
 # download kernel and stuff from here http://dl-cdn.alpinelinux.org/alpine/edge/releases/armv7/netboot/
 qemu-system-arm -M virt -m 512M -cpu cortex-a15 -kernel vmlinuz-lts -initrd initramfs-lts -append "console=ttyAMA0 ip=dhcp alpine_repo=http://dl-cdn.alpinelinux.org/alpine/edge/main/" -nographic
+</code>
+===== postgresql =====
+dump database
+<code>
+pg_dump -U gitlab gitlabhq_production > /tmp/gitlab.pgsql
+</code>
+dump all
+<code>
+pg_dumpall > /tmp/dump_file_name.tar
+</code>
+import database
+<code>
+psql# CREATE DATABASE gitlabhq_production;
+psql -U gitlab gitlabhq_production < gitlab.pgsql
+</code>
+===== mysql =====
+Dump database
+<code bash>
+mysqldump -u root -p Tutorials > tut_backup.sql
+</code>
+Backup everything
+<code bash>
+mysqldump -u root -p --all-databases > alldb.sql
+</code>
+Import database
+<code>
+mysql> CREATE DATABASE wordpress;
+sudo mysql -u root wordpress < wordpress.sql
+</code>
+Setup
+<code bash>
+systemctl stop mysqld
+mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
+systemctl start mysqld
+mysql_secure_installation
 </code>

Project-Insanity