Manual Database Backup - Revision history

Luc Morissette: Added TelcoBridges linux

2024-06-13T18:34:53Z

Added TelcoBridges linux

← Older revision		Revision as of 14:34, 13 June 2024
Line 17:		Line 17:
	SELECT * from mysql.user;</pre>		SELECT * from mysql.user;</pre>
	<br>		<br>
	To work with the MySQL service (CentOS 5):<br>		To work with the MySQL service on CentOS 5:<br>
	<pre>service mysqld stop		<pre>service mysqld stop
	service mysqld start		service mysqld start
Line 23:		Line 23:
	</pre>		</pre>
	<br>		<br>
	To work with the MySQL service (CentOS 7):<br>		To work with the MySQL service on CentOS 7 or Telcobridges linux:<br>
	~~<br>~~ Enable and start MariaDB		Enable and start MariaDB
	systemctl enable mariadb		systemctl enable mariadb
	systemctl start mariadb		systemctl start mariadb

Luc Morissette at 13:17, 19 March 2021

2021-03-19T13:17:30Z

← Older revision		Revision as of 09:17, 19 March 2021
Line 10:		Line 10:
	<br> <br>		<br> <br>

	Here are other useful mysql commands ~~(CentOS 5)~~:		Here are other useful mysql commands:
	<pre>mysql –u tbdb –p tbdbpw		<pre>mysql –u tbdb –p tbdbpw
	use toolpack_3_1;		use toolpack_3_1;
Line 16:		Line 16:
	SELECT * from system_infos;		SELECT * from system_infos;
	SELECT * from mysql.user;</pre>		SELECT * from mysql.user;</pre>
	~~And to~~ work with the MySQL service:<br>		<br>
			To work with the MySQL service (CentOS 5):<br>
	<pre>service mysqld stop		<pre>service mysqld stop
	service mysqld start		service mysqld start
	ps -ef \| grep mysqld		ps -ef \| grep mysqld
	</pre>		</pre>
			<br>
	~~Here are other useful mysql commands~~ (CentOS 7):		To work with the MySQL service (CentOS 7):<br>
	<br> Enable and start MariaDB		<br> Enable and start MariaDB
	systemctl enable mariadb		systemctl enable mariadb
	systemctl start mariadb		systemctl start mariadb

Luc Morissette: Added CentOS 7 commands

2021-03-19T13:16:21Z

Added CentOS 7 commands

← Older revision		Revision as of 09:16, 19 March 2021
Line 21:		Line 21:
	ps -ef \| grep mysqld		ps -ef \| grep mysqld
	</pre>		</pre>

			Here are other useful mysql commands (CentOS 7):
			<br> Enable and start MariaDB
			systemctl enable mariadb
			systemctl start mariadb

Luc Morissette at 13:14, 19 March 2021

2021-03-19T13:14:33Z

← Older revision		Revision as of 09:14, 19 March 2021
Line 8:		Line 8:

	For scheduled backups, see [[Scheduled Database Backup]]		For scheduled backups, see [[Scheduled Database Backup]]
	<br>		<br> <br>

	Here are other useful mysql commands (CentOS 5):		Here are other useful mysql commands (CentOS 5):

Luc Morissette at 13:14, 19 March 2021

2021-03-19T13:14:21Z

← Older revision		Revision as of 09:14, 19 March 2021
Line 7:		Line 7:
	This procedure can also be used to make copies of similar configurations from one Toolpack system to another. The Serial Number of the Tmedia used must be updated after the new database is in place using the Migration tab. If the tab is not present, you can do it manually (contact support)<br><br>		This procedure can also be used to make copies of similar configurations from one Toolpack system to another. The Serial Number of the Tmedia used must be updated after the new database is in place using the Migration tab. If the tab is not present, you can do it manually (contact support)<br><br>

			For scheduled backups, see [[Scheduled Database Backup]]
	<br>		<br>
	~~For scheduled backups, see [[Scheduled Database Backup]]~~

	Here are other useful mysql commands (CentOS 5):		Here are other useful mysql commands (CentOS 5):

Luc Morissette at 13:14, 19 March 2021

2021-03-19T13:14:05Z

← Older revision		Revision as of 09:14, 19 March 2021
Line 7:		Line 7:
	This procedure can also be used to make copies of similar configurations from one Toolpack system to another. The Serial Number of the Tmedia used must be updated after the new database is in place using the Migration tab. If the tab is not present, you can do it manually (contact support)<br><br>		This procedure can also be used to make copies of similar configurations from one Toolpack system to another. The Serial Number of the Tmedia used must be updated after the new database is in place using the Migration tab. If the tab is not present, you can do it manually (contact support)<br><br>

	Here are other useful mysql commands:		<br>
			For scheduled backups, see [[Scheduled Database Backup]]

			Here are other useful mysql commands (CentOS 5):
	<pre>mysql –u tbdb –p tbdbpw		<pre>mysql –u tbdb –p tbdbpw
	use toolpack_3_1;		use toolpack_3_1;
Line 18:		Line 21:
	ps -ef \| grep mysqld		ps -ef \| grep mysqld
	</pre>		</pre>

	~~<br>~~
	~~For scheduled backups, see [[Scheduled Database Backup]]~~

Luc Morissette: Added Scheduled database backups

2021-03-19T13:13:24Z

Added Scheduled database backups

← Older revision		Revision as of 09:13, 19 March 2021
Line 18:		Line 18:
	ps -ef \| grep mysqld		ps -ef \| grep mysqld
	</pre>		</pre>

			<br>
			For scheduled backups, see [[Scheduled Database Backup]]

Luc Morissette: Updated for new format of database name

2021-03-19T13:12:03Z

Updated for new format of database name

← Older revision		Revision as of 09:12, 19 March 2021
Line 1:		Line 1:
	To backup the MySQL database, use the following commands:		To backup the MySQL database, use the following commands (example is for major version 3.1):
	<pre>mysqldump -u tbdb -ptbdbpw --opt ~~toolpack_0~~ > ~~toolpack_0_bk~~.sql</pre>		<pre>mysqldump -u tbdb -ptbdbpw --opt toolpack_3_1 > toolpack_3_1_bk.sql</pre>
	Then, you need to save the "~~toolpack_0_bk~~.sql" file in a safe place.		Then, you need to save the "toolpack_3_1_bk.sql" file in a safe place.

	You can recover the database this way:		You can recover the database this way:
	<pre>mysql -u tbdb -ptbdbpw ~~toolpack_0~~ < ~~toolpack_0_bk~~.sql</pre>		<pre>mysql -u tbdb -ptbdbpw toolpack_3_1 < toolpack_3_1_bk.sql</pre>
	This procedure can also be used to make copies of similar configurations from one Toolpack system to another. The Serial Number of the Tmedia used must be updated after the new database is in place using the Migration tab. If the tab is not present, you can do it manually (contact support)<br><br>		This procedure can also be used to make copies of similar configurations from one Toolpack system to another. The Serial Number of the Tmedia used must be updated after the new database is in place using the Migration tab. If the tab is not present, you can do it manually (contact support)<br><br>

	Here are other useful mysql commands:		Here are other useful mysql commands:
	<pre>mysql –u tbdb –p tbdbpw		<pre>mysql –u tbdb –p tbdbpw
	use ~~toolpack_0~~;		use toolpack_3_1;
	show tables;		show tables;
	SELECT * from system_infos;		SELECT * from system_infos;
Line 18:		Line 18:
	ps -ef \| grep mysqld		ps -ef \| grep mysqld
	</pre>		</pre>


	~~'''IMPORTANT NOTE:''' Starting from release 2.8, the database name is toolpack_2_x (e.g. toolpack_2_8).~~

Cboulanger: Added a note about the name of the DB in later releases

2015-11-03T22:16:27Z

Added a note about the name of the DB in later releases

← Older revision		Revision as of 18:16, 3 November 2015
Line 18:		Line 18:
	ps -ef \| grep mysqld		ps -ef \| grep mysqld
	</pre>		</pre>


			'''IMPORTANT NOTE:''' Starting from release 2.8, the database name is toolpack_2_x (e.g. toolpack_2_8).

Luc Morissette at 18:02, 10 May 2011

2011-05-10T18:02:18Z

← Older revision		Revision as of 14:02, 10 May 2011
Line 1:		Line 1:
	To backup the MySQL database, use the following commands:		To backup the MySQL database, use the following commands:
	<pre>mysqldump -u tbdb -ptbdbpw --opt toolpack_0 > toolpack_0_bk.sql</pre>		<pre>mysqldump -u tbdb -ptbdbpw --opt toolpack_0 > toolpack_0_bk.sql</pre>
	Then, you need to save the "toolpack_0_bk.sql" file in a safe place.		Then, you need to save the "toolpack_0_bk.sql" file in a safe place.

	You can recover the database this way:		You can recover the database this way:
	<pre>mysql -u tbdb -ptbdbpw toolpack_0 < toolpack_0_bk.sql</pre>		<pre>mysql -u tbdb -ptbdbpw toolpack_0 < toolpack_0_bk.sql</pre>
	This procedure can also be used to make copies of similar configurations from one Toolpack system to another. The Serial Number of the Tmedia used must be updated after the new database is in place using the Migration tab. If the tab is not present, you can do it manually (contact support)<br><br>		This procedure can also be used to make copies of similar configurations from one Toolpack system to another. The Serial Number of the Tmedia used must be updated after the new database is in place using the Migration tab. If the tab is not present, you can do it manually (contact support)<br><br>

			Here are other useful mysql commands:
			<pre>mysql –u tbdb –p tbdbpw
			use toolpack_0;
			show tables;
			SELECT * from system_infos;
			SELECT * from mysql.user;</pre>
			And to work with the MySQL service:<br>
			<pre>service mysqld stop
			service mysqld start
			ps -ef \| grep mysqld
			</pre>