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/09/17 13:37] – [qemu] 10.25.0.100 | onny:notizen [2022/09/19 18:42] – [mysql] 10.25.0.100 | ||
|---|---|---|---|
| Line 2160: | Line 2160: | ||
| 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 | ||
| </ | </ | ||
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
