onny:notizen
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
| onny:notizen [2022/08/16 17:45] – 10.25.0.100 | onny:notizen [2022/10/04 11:51] – [nixos] 10.25.40.1 | ||
|---|---|---|---|
| Line 1407: | Line 1407: | ||
| < | < | ||
| src = "/ | src = "/ | ||
| - | dontUnpack = true; | + | |
| - | | + | |
| unpackPhase = '' | unpackPhase = '' | ||
| </ | </ | ||
| Line 1872: | Line 1871: | ||
| fatlabel /dev/sdb1 " | fatlabel /dev/sdb1 " | ||
| </ | </ | ||
| + | |||
| + | grow ext4 partition live | ||
| + | <code bash> | ||
| + | $ growpart /dev/sda 2 | ||
| + | $ resize2fs /dev/sda2 | ||
| + | </ | ||
| + | |||
| resize extX partition | resize extX partition | ||
| + | |||
| <code bash> | <code bash> | ||
| sfdisk -l /dev/sdb | sfdisk -l /dev/sdb | ||
| Line 2142: | Line 2149: | ||
| # download kernel and stuff from here http:// | # download kernel and stuff from here http:// | ||
| qemu-system-arm -M virt -m 512M -cpu cortex-a15 -kernel vmlinuz-lts -initrd initramfs-lts -append " | qemu-system-arm -M virt -m 512M -cpu cortex-a15 -kernel vmlinuz-lts -initrd initramfs-lts -append " | ||
| + | </ | ||
| + | |||
| + | ===== postgresql ===== | ||
| + | |||
| + | dump database | ||
| + | < | ||
| + | pg_dump -U gitlab gitlabhq_production > / | ||
| + | </ | ||
| + | |||
| + | dump all | ||
| + | < | ||
| + | pg_dumpall > / | ||
| + | </ | ||
| + | |||
| + | import database | ||
| + | < | ||
| + | psql# CREATE DATABASE gitlabhq_production; | ||
| + | psql -U gitlab gitlabhq_production < gitlab.pgsql | ||
| + | </ | ||
| + | |||
| + | ===== mysql ===== | ||
| + | |||
| + | Dump database | ||
| + | <code bash> | ||
| + | mysqldump -u root -p Tutorials > tut_backup.sql | ||
| + | </ | ||
| + | |||
| + | Backup everything | ||
| + | <code bash> | ||
| + | mysqldump -u root -p --all-databases > alldb.sql | ||
| + | # in case of nextcloud | ||
| + | mysqldump -u root -p --all-databases --default-character-set=utf8mb4 > alldb.sql | ||
| + | </ | ||
| + | |||
| + | Import database | ||
| + | < | ||
| + | mysql> CREATE DATABASE wordpress; | ||
| + | sudo mysql -u root wordpress < wordpress.sql | ||
| + | </ | ||
| + | |||
| + | Setup | ||
| + | <code bash> | ||
| + | systemctl stop mysqld | ||
| + | mysql_install_db --user=mysql --basedir=/ | ||
| + | systemctl start mysqld | ||
| + | mysql_secure_installation | ||
| </ | </ | ||
onny/notizen.txt · Last modified: 2024/05/22 12:10 by 10.250.0.1
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
