919
modifications
Ligne 113 : | Ligne 113 : | ||
=== Copy over SQL databases === | === Copy over SQL databases === | ||
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 === |