FeministWiki:Server setup: Difference between revisions
    Line 113: Line 113:
    === Copy over SQL databases ===
    === 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 ===
    === Copy over /var/www ===
    Retrieved from "https://feministwiki.org/wiki/FeministWiki:Server_setup"