Help:Wiki Backup - Revision history

129.105.69.231 at 15:29, 11 August 2006

2006-08-11T15:29:52Z

@@ Line 5: / Line 5: @@
 * The wiki mysql database
 * The images folder
 ===Backing up the MySQL Database===
@@ Line 15: / Line 16: @@
 # Delete the mewiki.sql.gz file from the server.
 # Upload the mewiki.sql.gz file to the Hades webserver
@@ Line 30: / Line 31: @@
 # FTP download the file images.tar.gz to a safe place.
 # Delete the images.tar.gz file from the server.

129.105.69.231 at 15:25, 11 August 2006

2006-08-11T15:25:41Z

← Older revision		Revision as of 10:25, 11 August 2006
Line 1:		Line 1:
	'''LAST BACKUP : 7/18/2006'''		'''LAST BACKUP : BJS 8/11/2006'''

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

Stephens at 18:12, 18 July 2006

2006-07-18T18:12:57Z

← Older revision		Revision as of 13:12, 18 July 2006
Line 1:		Line 1:
	'''LAST BACKUP : 7/7/2006'''		'''LAST BACKUP : 7/18/2006'''

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

Stephens at 23:22, 10 July 2006

2006-07-10T23:22:52Z

← Older revision		Revision as of 18:22, 10 July 2006
Line 10:		Line 10:
	# Open SSH Secure Shell		# Open SSH Secure Shell
	# Login to the Hades server (see administrator)		# Login to the Hades server (see administrator)
	# Type:<pre>mysqldump -h localhost -u [USERNAME] -p ~~[PASSWORD]~~ -B mewiki > mewiki.sql</pre>		# Type:<pre>mysqldump -h localhost -u [USERNAME] -p -B mewiki > mewiki.sql</pre>
	# Zip the database file:<pre>gzip mewiki.sql</pre>		# Zip the database file:<pre>gzip mewiki.sql</pre>
	# FTP to the directory containing the mewiki.sql.gz file and download to a safe place		# FTP to the directory containing the mewiki.sql.gz file and download to a safe place
Line 19:		Line 19:
	# Upload the mewiki.sql.gz file to the Hades webserver		# Upload the mewiki.sql.gz file to the Hades webserver
	# Unzip the file:<pre>gunzip -xf mewiki.sql.gz</pre>		# Unzip the file:<pre>gunzip -xf mewiki.sql.gz</pre>
	# Insert the database:<pre>mysql -h localhost -u [USERNAME] -p ~~[PASSWORD]~~ mewiki < mewiki.sql</pre>		# Insert the database:<pre>mysql -h localhost -u [USERNAME] -p mewiki < mewiki.sql</pre>
			# Enter the password for the mysql database
	# Delete the mewiki.sql from the server.		# Delete the mewiki.sql from the server.

Stephens at 23:10, 7 July 2006

2006-07-07T23:10:13Z

← Older revision		Revision as of 18:10, 7 July 2006
Line 1:		Line 1:
			'''LAST BACKUP : 7/7/2006'''

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

Stephens: /* Restoring the MySQL Database */

2006-05-18T17:57:38Z

Restoring the MySQL Database

← Older revision		Revision as of 12:57, 18 May 2006
Line 17:		Line 17:
	# Upload the mewiki.sql.gz file to the Hades webserver		# Upload the mewiki.sql.gz file to the Hades webserver
	# Unzip the file:<pre>gunzip -xf mewiki.sql.gz</pre>		# Unzip the file:<pre>gunzip -xf mewiki.sql.gz</pre>
	# Insert the database:<pre>mysql -h localhost -u ~~mewiki~~ -p mewiki < mewiki.sql</pre>		# Insert the database:<pre>mysql -h localhost -u [USERNAME] -p [PASSWORD] mewiki < mewiki.sql</pre>
	# Delete the mewiki.sql from the server.		# Delete the mewiki.sql from the server.

Stephens: /* Backing up the MySQL Database */

2006-05-16T21:54:56Z

Backing up the MySQL Database

← Older revision		Revision as of 16:54, 16 May 2006
Line 8:		Line 8:
	# Open SSH Secure Shell		# Open SSH Secure Shell
	# Login to the Hades server (see administrator)		# Login to the Hades server (see administrator)
	# Type:<pre>mysqldump -h ~~fred.tech.northwestern.edu~~ -u [USERNAME] -p [PASSWORD] -B mewiki > mewiki.sql</pre>		# Type:<pre>mysqldump -h localhost -u [USERNAME] -p [PASSWORD] -B mewiki > mewiki.sql</pre>
	# Zip the database file:<pre>gzip mewiki.sql</pre>		# Zip the database file:<pre>gzip mewiki.sql</pre>
	# FTP to the directory containing the mewiki.sql.gz file and download to a safe place		# FTP to the directory containing the mewiki.sql.gz file and download to a safe place

Stephens at 19:32, 16 May 2006

2006-05-16T19:32:18Z

← Older revision		Revision as of 14:32, 16 May 2006
Line 11:		Line 11:
	# Zip the database file:<pre>gzip mewiki.sql</pre>		# Zip the database file:<pre>gzip mewiki.sql</pre>
	# FTP to the directory containing the mewiki.sql.gz file and download to a safe place		# FTP to the directory containing the mewiki.sql.gz file and download to a safe place
			# Delete the mewiki.sql.gz file from the server.

			===Restoring the MySQL Database===

			# Upload the mewiki.sql.gz file to the Hades webserver
			# Unzip the file:<pre>gunzip -xf mewiki.sql.gz</pre>
			# Insert the database:<pre>mysql -h localhost -u mewiki -p mewiki < mewiki.sql</pre>
			# Delete the mewiki.sql from the server.

	===Backing up the Images Folder===		===Backing up the Images Folder===
Line 18:		Line 26:
	# Zip the file:<pre>gzip images.tar</pre>		# Zip the file:<pre>gzip images.tar</pre>
	# FTP download the file images.tar.gz to a safe place.		# FTP download the file images.tar.gz to a safe place.
			# Delete the images.tar.gz file from the server.

Stephens at 19:28, 16 May 2006

2006-05-16T19:28:51Z

New page

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

* The wiki mysql database
* The images folder

===Backing up the MySQL Database===

# Open SSH Secure Shell
# Login to the Hades server (see administrator)
# Type:<pre>mysqldump -h fred.tech.northwestern.edu -u [USERNAME] -p [PASSWORD] -B mewiki > mewiki.sql</pre>
# Zip the database file:<pre>gzip mewiki.sql</pre>
# FTP to the directory containing the mewiki.sql.gz file and download to a safe place

===Backing up the Images Folder===

# Navigate to the wiki directory (./wiki)
# Tar the images folder: <pre>tar -cf images.tar images</pre>
# Zip the file:<pre>gzip images.tar</pre>
# FTP download the file images.tar.gz to a safe place.