Jump to content

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 ===