Backup and restore - Revision history

Kpe: /* Corrupted databases */

2024-04-30T12:57:43Z

Corrupted databases

← Older revision		Revision as of 14:57, 30 April 2024
Line 47:		Line 47:
	# Dump database if possible using '''mysqldump'''		# Dump database if possible using '''mysqldump'''
	# Connect remotely and dump SQL script files of each table		# Connect remotely and dump SQL script files of each table


			== Problems with views ==
			In some cases database views will be treated as tables which requires them to be deleted

			DROP TABLE IF EXISTS authenticationtype;
			DROP TABLE IF EXISTS cleanuppolicy;
			DROP TABLE IF EXISTS datatypegroup;
			DROP TABLE IF EXISTS datatypegroupsub;
			DROP TABLE IF EXISTS datatypemapping;
			DROP TABLE IF EXISTS defaultsystemconfig;
			DROP TABLE IF EXISTS eventdomain;
			DROP TABLE IF EXISTS eventseverity;
			DROP TABLE IF EXISTS formstatusactiontype;
			DROP TABLE IF EXISTS guilanguage_copy;
			DROP TABLE IF EXISTS guilanguageterm;
			DROP TABLE IF EXISTS guilanguageword_copy;
			DROP TABLE IF EXISTS guistyle_copy;
			DROP TABLE IF EXISTS integrationtype;
			DROP TABLE IF EXISTS messagetype;
			DROP TABLE IF EXISTS persistencescope;
			DROP TABLE IF EXISTS persistencetype;
			DROP TABLE IF EXISTS remotedatabasedriver;
			DROP TABLE IF EXISTS reservednames;
			DROP TABLE IF EXISTS satelitemode;
			DROP TABLE IF EXISTS sharemediatype;
			DROP TABLE IF EXISTS sqllogcrud;
			DROP TABLE IF EXISTS sqllogtarget;
			DROP TABLE IF EXISTS staticdatacountry;
			DROP TABLE IF EXISTS staticdatacountrycode;
			DROP TABLE IF EXISTS staticdatacurrencycode;
			DROP TABLE IF EXISTS staticdatanace;
			DROP TABLE IF EXISTS staticdatapostalcode;
			DROP TABLE IF EXISTS staticdataunspsc;
			DROP TABLE IF EXISTS staticicddiagnose;
			DROP TABLE IF EXISTS staticsksatc;
			DROP TABLE IF EXISTS staticsksbehandling;
			DROP TABLE IF EXISTS staticsksdiagnose;
			DROP TABLE IF EXISTS staticsksoperation;
			DROP TABLE IF EXISTS staticskssygehusafdeling;
			DROP TABLE IF EXISTS staticsksulykke;
			DROP TABLE IF EXISTS staticsksundersoegelse;
			DROP TABLE IF EXISTS statisticsftest;
			DROP TABLE IF EXISTS systemcodeunittype;
			DROP TABLE IF EXISTS systemconfiggroup;
			DROP TABLE IF EXISTS systemconfigvalue;
			DROP TABLE IF EXISTS systemdatatype;
			DROP TABLE IF EXISTS systemdatatypegroups;
			DROP TABLE IF EXISTS systemdatatypepackage;
			DROP TABLE IF EXISTS systemformat;
			DROP TABLE IF EXISTS systemhelp;
			DROP TABLE IF EXISTS systemindicatorview;
			DROP TABLE IF EXISTS systemmodelvariabletype;
			DROP TABLE IF EXISTS systemnamedquerys;
			DROP TABLE IF EXISTS systemoperator;
			DROP TABLE IF EXISTS systempolicygroup;
			DROP TABLE IF EXISTS systempolicymeta;
			DROP TABLE IF EXISTS systemsamplevalue;
			DROP TABLE IF EXISTS systemstate;
			DROP TABLE IF EXISTS userflagtype;
			DROP TABLE IF EXISTS usermenulayout;
			DROP TABLE IF EXISTS usermenulevel;
			DROP TABLE IF EXISTS version;
			DROP TABLE IF EXISTS widgetlayout;
			DROP TABLE IF EXISTS widgetposition;
			DROP TABLE IF EXISTS widgettype;

Kpe at 14:11, 18 May 2022

2022-05-18T14:11:28Z

← Older revision		Revision as of 16:11, 18 May 2022
Line 41:		Line 41:

	[http://www.tempusserva.dk/articlebase/Secure%20rsync%20from%20Linux%20webservers%20to%20Windows%20backup%20host.pdf Secure rsync from Linux webservers to Windows backup host.pdf]		[http://www.tempusserva.dk/articlebase/Secure%20rsync%20from%20Linux%20webservers%20to%20Windows%20backup%20host.pdf Secure rsync from Linux webservers to Windows backup host.pdf]

			== Corrupted databases ==
			Try in the following order
			# Run the '''mysqlcheck''' tool
			# Dump database if possible using '''mysqldump'''
			# Connect remotely and dump SQL script files of each table

Tvi: 13 revisions imported

2021-12-10T10:51:14Z

13 revisions imported

← Older revision	Revision as of 12:51, 10 December 2021
(No difference)

old>Admin: /* Windows server backup options */

2013-02-20T14:07:43Z

Windows server backup options

← Older revision		Revision as of 16:07, 20 February 2013
Line 28:		Line 28:
	The service will call the tsrsyncdump.sh every 24 hours, making a dump ready for remote synchronization.		The service will call the tsrsyncdump.sh every 24 hours, making a dump ready for remote synchronization.

	== Windows server backup ~~options~~ ==		== Windows server backup ==

	# Create .bat file		# Create .bat file

old>Admin: /* Backup synchronization (Linux server to Windows storage) */

2013-02-20T14:07:13Z

Backup synchronization (Linux server to Windows storage)

← Older revision		Revision as of 16:07, 20 February 2013
Line 40:		Line 40:
	The following article describes incremental backup files can be transferred from a Linux server to a Windows client		The following article describes incremental backup files can be transferred from a Linux server to a Windows client

	http://www.tempusserva.dk/articlebase/Secure%20rsync%20from%20Linux%20webservers%20to%20Windows%20backup%20host.pdf		[http://www.tempusserva.dk/articlebase/Secure%20rsync%20from%20Linux%20webservers%20to%20Windows%20backup%20host.pdf Secure rsync from Linux webservers to Windows backup host.pdf]

old>Admin: /* Backup synchronization */

2013-02-20T14:06:30Z

Backup synchronization

← Older revision		Revision as of 16:06, 20 February 2013
Line 37:		Line 37:
	Configuring the mysqldump i straitfroward using the [http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html MySQL documentation and examples]		Configuring the mysqldump i straitfroward using the [http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html MySQL documentation and examples]

	== Backup synchronization ==		== Backup synchronization (Linux server to Windows storage) ==
	The following article describes incremental backup files can be transferred from a Linux server to a Windows client		The following article describes incremental backup files can be transferred from a Linux server to a Windows client

	http://www.tempusserva.dk/articlebase/Secure%20rsync%20from%20Linux%20webservers%20to%20Windows%20backup%20host.pdf		http://www.tempusserva.dk/articlebase/Secure%20rsync%20from%20Linux%20webservers%20to%20Windows%20backup%20host.pdf

old>Admin at 14:06, 20 February 2013

2013-02-20T14:06:07Z

← Older revision		Revision as of 16:06, 20 February 2013
Line 36:		Line 36:

	Configuring the mysqldump i straitfroward using the [http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html MySQL documentation and examples]		Configuring the mysqldump i straitfroward using the [http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html MySQL documentation and examples]

			== Backup synchronization ==
			The following article describes incremental backup files can be transferred from a Linux server to a Windows client

			http://www.tempusserva.dk/articlebase/Secure%20rsync%20from%20Linux%20webservers%20to%20Windows%20backup%20host.pdf

old>Admin at 13:51, 7 February 2013

2013-02-07T13:51:28Z

← Older revision		Revision as of 15:51, 7 February 2013
Line 28:		Line 28:
	The service will call the tsrsyncdump.sh every 24 hours, making a dump ready for remote synchronization.		The service will call the tsrsyncdump.sh every 24 hours, making a dump ready for remote synchronization.

	== Windows options ==		== Windows server backup options ==

	# Create .bat file		# Create .bat file
Line 35:		Line 35:
	# Execute above file scheduled from the Windows task manager		# Execute above file scheduled from the Windows task manager

	Configuring the mysqldump i straitfroward using the ~~MySQL documentation and examples:~~		Configuring the mysqldump i straitfroward using the [http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html MySQL documentation and examples]
	http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

old>Admin at 13:49, 7 February 2013

2013-02-07T13:49:04Z

← Older revision		Revision as of 15:49, 7 February 2013
Line 27:		Line 27:

	The service will call the tsrsyncdump.sh every 24 hours, making a dump ready for remote synchronization.		The service will call the tsrsyncdump.sh every 24 hours, making a dump ready for remote synchronization.

			== Windows options ==

			# Create .bat file
			## Use mysqldump to backup all of the databases
			## Copy files to safe location (network drive etc.)
			# Execute above file scheduled from the Windows task manager

			Configuring the mysqldump i straitfroward using the MySQL documentation and examples:
			http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

old>Admin at 05:56, 19 September 2012

2012-09-19T05:56:15Z

← Older revision		Revision as of 07:56, 19 September 2012
Line 20:		Line 20:
	## Run tsrsyncdump.sh (test run)		## Run tsrsyncdump.sh (test run)
	## Run tsinstallcronjobs.sh (future scheduled runs)		## Run tsinstallcronjobs.sh (future scheduled runs)

	# Windows backup machine:		# Windows backup machine:
	## Install Cygwin tools: http://www.cygwin.com/		## Install Cygwin tools: http://www.cygwin.com/