Actions

Manual Database Backup

Revision as of 14:00, 10 May 2011 by Luc Morissette (talk | contribs) (New page)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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)