Restoring mediawiki to another server: Difference between revisions
No edit summary |
No edit summary |
||
| Line 84: | Line 84: | ||
::::<tt>$ su | ::::<tt>$ su | ||
::::$ gunzip < /rpbackups/rsync/RP1/var/lib/automsqlbackup/daily/bradnor/bradnor_2019-11-04_06h25m.Monday.sql.gz | mysql bradnor</tt> | ::::$ gunzip < /rpbackups/rsync/RP1/var/lib/automsqlbackup/daily/bradnor/bradnor_2019-11-04_06h25m.Monday.sql.gz | mysql bradnor</tt> | ||
:::or, better when using ssh - nohup runs process even if ssh session ends | |||
::::<tt>$ sudo cat <path to backup> > <unpacked file> | |||
:::::e.g. sudo cat bradnor_2019-11-04_06h25m.Monday.sql.gz > bradnor.sql | |||
::::$ sudo nohup mysql <database name> -e "source <unpacked file>" & | |||
:::::e.g. sudo nohup mysql bradnor -e "source bradnor.sql" & | |||
:restore files | :restore files | ||
::restore the <tt>mediawiki/images</tt> directory and set ownership to user <tt>www-data</tt> | ::restore the <tt>mediawiki/images</tt> directory and set ownership to user <tt>www-data</tt> | ||