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/09/17 13:37] – [qemu] 10.25.0.100 | onny:notizen [2022/09/21 12:37] – [partitioning] 10.25.0.100 | ||
---|---|---|---|
Line 1872: | Line 1872: | ||
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 2160: | Line 2168: | ||
psql# CREATE DATABASE gitlabhq_production; | psql# CREATE DATABASE gitlabhq_production; | ||
psql -U gitlab gitlabhq_production < gitlab.pgsql | 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 | ||
</ | </ |