Manual Database Backup - Revision history

Luc Morissette at 13:17, 19 March 2021

2021-03-19T13:17:30Z

Luc Morissette: Added CentOS 7 commands

2021-03-19T13:16:21Z

Added CentOS 7 commands

Luc Morissette at 13:14, 19 March 2021

2021-03-19T13:14:33Z

Luc Morissette at 13:14, 19 March 2021

2021-03-19T13:14:21Z

Luc Morissette at 13:14, 19 March 2021

2021-03-19T13:14:05Z

Luc Morissette: Added Scheduled database backups

2021-03-19T13:13:24Z

Added Scheduled database backups

Luc Morissette: Updated for new format of database name

2021-03-19T13:12:03Z

Updated for new format of database name

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

Luc Morissette at 18:02, 10 May 2011

2011-05-10T18:02:18Z

Luc Morissette: New page

2011-05-10T18:00:45Z

New page

New page

To backup the MySQL database, use the following commands:
<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.

You can recover the database this way:
<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>

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

← Older revision		Revision as of 13: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

@@ Line 8: / Line 8: @@
 For scheduled backups, see [[Scheduled Database Backup]]
-<br>
+<br> <br>
 Here are other useful mysql commands (CentOS 5):

@@ 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>
 For scheduled backups, see [[Scheduled Database Backup]]
 Here are other useful mysql commands (CentOS 5):

@@ 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>
-Here are other useful mysql commands:
+<br>
 <pre>mysql –u tbdb –p tbdbpw
 use toolpack_3_1;
@@ Line 18: / Line 21: @@
 ps -ef | grep mysqld
 </pre>

← Older revision		Revision as of 13: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]]

@@ 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 &gt; toolpack_0_bk.sql</pre>
+<pre>mysqldump -u tbdb -ptbdbpw --opt toolpack_3_1 &gt; 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:
-<pre>mysql -u tbdb -ptbdbpw toolpack_0 &lt; toolpack_0_bk.sql</pre>
+<pre>mysql -u tbdb -ptbdbpw toolpack_3_1 &lt; 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>
 Here are other useful mysql commands:
 <pre>mysql –u tbdb –p tbdbpw
-use toolpack_0;
+use toolpack_3_1;
 show tables;
 SELECT * from system_infos;
@@ Line 18: / Line 18: @@
 ps -ef | grep mysqld
 </pre>

← Older revision		Revision as of 22: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).