Seon Core administrative scripts - Revision history

Admin: /* seon_archive.sh */

2016-02-02T13:23:57Z

‎seon_archive.sh

2016-02-02T13:23:22Z

‎seon_archive.sh

2016-02-02T13:22:09Z

‎seon_archive.sh

2013-08-20T10:57:23Z

‎seon_archive.sh

2013-08-20T10:56:36Z

‎seon_archive.sh

2013-08-20T10:54:25Z

‎seon_archive.sh

2013-08-20T10:53:44Z

‎seon_archive.sh

2013-08-20T10:53:19Z

@@ Line 58: / Line 58: @@
 #Shutdown Seon processes
 #Shutdown webserver
 #Run archive script
 #Start webserver
 #Start Seon processes

@@ Line 55: / Line 55: @@
 *is the parameter valid
-Since the scripts locks the database tables which will be used for archiving, please plan a downtime for OS4X. Also, please use the following procedure for using this script:
+Since the scripts locks the database tables which will be used for archiving, please plan a downtime for Seon. Also, please use the following procedure for using this script:
-#Shutdown OS4X processes
+#Shutdown Seon processes
 #Shutdown webserver
 #Shutdown database server
@@ Line 62: / Line 62: @@
 #Start database server
 #Start webserver
-#Start OS4X processes
+#Start Seon processes
 The created archive is a valid MySQL dump which can be easily imported with standard MySQL tools (like the "mysqlclient" command line tool). The archive is saved in the configured [[Seon_Core_installation#backup|database backup directory]] as a compressed MySQL dump file, with a filename

@@ Line 54: / Line 54: @@
 *is a backup directory correctly configured
 *is the parameter valid
 The created archive is a valid MySQL dump which can be easily imported with standard MySQL tools (like the "mysqlclient" command line tool). The archive is saved in the configured [[Seon_Core_installation#backup|database backup directory]] as a compressed MySQL dump file, with a filename

← Older revision		Revision as of 10:57, 20 August 2013
Line 59:		Line 59:
	where "<code>$TIMESTAMP</code>" is a string containing the date- and timestamp when the script was started. Example:		where "<code>$TIMESTAMP</code>" is a string containing the date- and timestamp when the script was started. Example:
	/opt/seon/backup/seon_archive.20130813.121123.sql.gz		/opt/seon/backup/seon_archive.20130813.121123.sql.gz
		+	You can easily restore its content via the script "[[Seon Core administrative scripts#seonrestore\|seonrestore]]" documented above.

@@ Line 55: / Line 55: @@
 *is the parameter valid
-The created archive is a valid MySQL dump which can be easily imported with standard MySQL tools (like the "mysqlclient" command line tool). The archive is backed up in the configured [[Seon_Core_installation#backup|database backup directory]], with a filename
+The created archive is a valid MySQL dump which can be easily imported with standard MySQL tools (like the "mysqlclient" command line tool). The archive is saved in the configured [[Seon_Core_installation#backup|database backup directory]] as a compressed MySQL dump file, with a filename
-  seon_archive.$TIMESTAMP.sql
+  seon_archive.$TIMESTAMP.sql.gz
-where "<code>$TIMESTAMP</code>" is a string containing the date- and timestamp when the script was started.
+where "<code>$TIMESTAMP</code>" is a string containing the date- and timestamp when the script was started. Example:

← Older revision		Revision as of 10:53, 20 August 2013
Line 30:		Line 30:

	Now you can safely start the Seon processes again.		Now you can safely start the Seon processes again.
		+
		+
		+	== seon_archive.sh ==
		+	This script is intended to keep the MySQL database usage clean and usable. As a mandatory parameter, you must pass the maximum age of entries (in days) for the oldest entries available in the MySQL database. All entries older that this given age are archived. The archived entities are:
		+	*all logs (incl. vault):
		+	**receive log
		+	**send log
		+	**system log
		+	**event (aka "script") log
		+	**archived xERPs
		+	**directory scanner
		+	*CRL vault
		+	*CSR vault
		+
		+	The script dynamically checks if Seon Enteprise is enabled. If this is the case, the script also archives the following entities older than the given age:
		+	*all jobs
		+	*all XML entries of archived jobs
		+	*all plugin logs of archived jobs
		+
		+	The script dynamically verifies the running circumstances:
		+	*is the database of type "MySQL"
		+	*is a dump tool correctly configured
		+	*is a backup directory correctly configured
		+	*is the parameter valid
		+
		+	The created archive is a valid MySQL dump which can be easily imported with standard MySQL tools (like the "mysqlclient" command line tool). The archive is backed up in the configured [[http://wiki.seon.de/wiki/index.php/Seon_Core_installation#backup\|database backup directory]], with a filename
		+	seon_archive.$TIMESTAMP.sql
		+	where "<code>$TIMESTAMP</code>" is a string containing the date- and timestamp when the script was started.