Help:Wiki Backup

You need to backup two things in order to restore the wiki:

• The wiki mysql database
• The images folder

Backing up the MySQL Database

1. Open SSH Secure Shell
2. Login to the Hades server (see administrator)
3. Type:

   mysqldump -h fred.tech.northwestern.edu -u [USERNAME] -p [PASSWORD] -B mewiki > mewiki.sql

4. Zip the database file:

   gzip mewiki.sql

5. FTP to the directory containing the mewiki.sql.gz file and download to a safe place
6. Delete the mewiki.sql.gz file from the server.

Restoring the MySQL Database

1. Upload the mewiki.sql.gz file to the Hades webserver
2. Unzip the file:

   gunzip -xf mewiki.sql.gz

3. Insert the database:

   mysql -h localhost -u mewiki -p mewiki < mewiki.sql

4. Delete the mewiki.sql from the server.

Backing up the Images Folder

1. Navigate to the wiki directory (./wiki)
2. Tar the images folder:

   tar -cf images.tar images

3. Zip the file:

   gzip images.tar

4. FTP download the file images.tar.gz to a safe place.
5. Delete the images.tar.gz file from the server.