Changes

From SME Server
Jump to navigationJump to search

Nextcloud (view source)

Revision as of 15:37, 23 March 2022

296 bytes added ,  15:37, 23 March 2022
→‎Change Database
Line 262: Line 262:  
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
−
/usr/bin/occ config:system:set host --value localhost:/var/lib/mysql/mariadb105.sock --type string
+
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 ===
Unnilennium
Super Admin, Wiki & Docs Team, Bureaucrats, Interface administrators, Administrators
3,254

edits

Retrieved from "https://wiki.koozali.org/Special:MobileDiff/40978"

Navigation menu