1,106
edits
FeministWiki:Server setup: Difference between revisions
→Copy over SQL databases
Technician (talk | contribs) |
Technician (talk | contribs) |
||
| Line 113: | Line 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.) | The following command can be used to create a dump of all databases and import it on the new server. 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)" | mysqldump -u root -p"$(cat /root/pwd/mysql)" \ | ||
--databases blogs \ | --databases blogs \ | ||
feministblog \ | feministblog \ | ||
| Line 127: | Line 127: | ||
feministwiki_it \ | feministwiki_it \ | ||
feministwiki_pt \ | feministwiki_pt \ | ||
fff | fff \ | ||
| ssh root@feministwiki.dev 'mysql -u root -p"$(cat /root/pwd/mysql)"' | |||
=== Copy over /var/www === | === Copy over /var/www === | ||