3,250
edits
Changes
Jump to navigation
Jump to search
Line 262:
Line 262: − /usr/bin/occ config:system:set host --value localhost:/var/lib/mysql/mariadb105.sock --type string+ + + + + + +
→Change Database
mysql105 < nextcloud.sql
mysql105 < nextcloud.sql
echo "CREATE USER IF NOT EXISTS `config getprop nextcloud DbUser`@localhost IDENTIFIED BY '`config getprop nextcloud DbPassword`';GRANT ALL PRIVILEGES ON `config getprop nextcloud DbName`.* TO`config getprop nextcloud DbUser`@localhost; FLUSH PRIVILEGES;" | mysql105
echo "CREATE USER IF NOT EXISTS `config getprop nextcloud DbUser`@localhost IDENTIFIED BY '`config getprop nextcloud DbPassword`';GRANT ALL PRIVILEGES ON `config getprop nextcloud DbName`.* TO`config getprop nextcloud DbUser`@localhost; FLUSH PRIVILEGES;" | mysql105
occ config:system:set host --value localhost:/var/lib/mysql/mariadb105.sock --type string
occ maintenance --off
occ maintenance --off
</syntaxhighlight>
</syntaxhighlight>
After checking that all is working you can then delete yourself the old db from the previous mysql server, or keep it as a backup for a while.
If it fails and just want to go back to previous state:
occ maintenance --on
occ config:system:set host --value localhost --type string
occ maintenance --off
=== Known issues ===
=== Known issues ===