FeministWiki:Server setup: Difference between revisions

FeministWiki:Server setup (view source)

902 bytes added , 17 August 2021

1,106

edits

@@ Line 113: / Line 113: @@
 === Copy over SQL databases ===
-TODO
+The following command can be used to create a dump of all databases.  You can use the <code>show databases;</code> command in the SQL console to make sure that the list of databases is complete.  (Unfortunately they have to be listed manually, because using the <code>--all-databases</code> option includes system databases that we don't want.)
+ mysqldump -u root -p"$(cat /root/pwd/mysql)" > all-databases.sql \
+   --databases blogs \
+               feministblog \
+               feministfiles \
+               feministforum \
+               feministmail \
+               feministsocial \
+               feministwiki \
+               feministwiki_de \
+               feministwiki_es \
+               feministwiki_it \
+               feministwiki_pt \
+               fff
+You can then copy over this file to the new server and execute it via:
+ mysql -u root -p"$(cat /root/pwd/mysql)" < all-databases.sql
 === Copy over /var/www ===