Manual Database Backup

From TBwiki
Revision as of 13:00, 10 May 2011 by Luc Morissette (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

To backup the MySQL database, use the following commands:

mysqldump -u tbdb -ptbdbpw --opt toolpack_0 > toolpack_0_bk.sql

Then, you need to save the "toolpack_0_bk.sql" file in a safe place.

You can recover the database this way:

mysql -u tbdb -ptbdbpw toolpack_0 < toolpack_0_bk.sql

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)

Personal tools