1,106
edits
FeministWiki:Server setup: Difference between revisions
→Copying over live data
Technician (talk | contribs) |
Technician (talk | contribs) |
||
| Line 219: | Line 219: | ||
The {{C|check_perms}} command, which is part of GNU Mailman, will take care of fixing the group ownership of the extracted files. | The {{C|check_perms}} command, which is part of GNU Mailman, will take care of fixing the group ownership of the extracted files. | ||
== Recreate SQL users == | |||
If the versions of MariaDB on the old and new server are compatible enough, you might be able to dump the {{C|mysql.user}} table and import it on the new server, but it's safer to recreate the users from scratch: | |||
sql << EOF | |||
create user blogs@localhost identified by '$(cat ~/pwd/mysql-blogs)'; | |||
grant all on blogs.* to blogs@localhost; | |||
create user feministfiles@localhost identified by '$(cat ~/pwd/mysql-files)'; | |||
grant all on feministfiles.* to feministfiles@localhost; | |||
create user feministforum@localhost identified by '$(cat ~/pwd/mysql-forum)'; | |||
grant all on feministforum.* to feministforum@localhost; | |||
create user feministmail@localhost identified by '$(cat ~/pwd/mysql-mail)'; | |||
grant all on feministmail.* to feministmail@localhost; | |||
create user feministwiki@localhost identified by '$(cat ~/pwd/mysql-wiki)'; | |||
grant all on feministwiki.* to feministwiki@localhost; | |||
create user fff@localhost identified by '$(cat ~/pwd/mysql-fff)'; | |||
grant all on fff.* to fff@localhost; | |||
EOF | |||
== Test == | == Test == | ||