This article assumes that the files are in the standard locations.
Set the following variable to where you have the copy of the restored files.
Precondition: home directories restored (contain IMAP directories).
mv /etc/postfix /etc/postfix.old mv /etc/dovecot /etc/dovecot.old cp -a $restore_dir/var/mail/* /var/mail/ cp -a $restore_dir/etc/aliases $restore_dir/etc/mailname /etc postalias /etc/aliases service saslauthd start service postfix start service dovecot start
Variant a) Quick and dirty: restore by replacing files.
<note>This is a dangerous variant since there can be incompatibilities between MySQL versions that affect the storage format. Also it is not guaranteed that the files were in a consitent state when they were backed-up if the server was running. In any case exporting and importing the database is much safer!</note>
service mysql stop cp -a /var/lib/mysql /var/lib/mysql.old
Restore each database:
cp -a $restore_dir/var/lib/mysql/<database> /var/lib/mysql
mv /etc/wordpress /etc/wordpress.old cp -a $restore_dir/etc/wordpress /etc
Start the server
service mysql start
Check if you can see the
echo 'show databases' | mysql -u root -p
Follow the instructions to download and install the package from the article “Installation on Debian” up to the point where the configuration dialogs start.
In the dialogs choose not to install a default database since you are going to restore an existing database.
We discussed the q&d variant of restoring a MySQL database earlier. If you have an SQL dump use that instead of the file copy method below.
service mysql stop cp -a $restore_dir/var/lib/mysql/gallery3 /var/lib/mysql chown -R mysql:mysql /var/lib/mysql/gallery3/ service mysql start
Check if MySQL sees the database:
echo 'show databases' | mysql -u root -p gallery3
Now add the missing gallery database user with the appropriate permissions:
GRANT SELECT, INSERT, LOCK TABLES, UPDATE, DELETE, ALTER ON gallery3.* TO gallery3@localhost IDENTIFIED BY '<password>'; FLUSH privileges;
Restore the configuration files and the collected photos and albums (this may take a while):
cp -a $restore_dir/etc/gallery3/* /etc/gallery3/ cp -a $restore_dir/var/lib/gallery3/* /var/lib/gallery3/
Don't forget to restore the Apache configuration (not described here since this is different for almost each installation).
If gallery gives you a warning that PHP's “short open tag” feature is required, you need to enable it in the
sed -ie 's/^short_open_tag *=.*/short_open_tag = On/' /etc/php5/apache2/php.ini