Specifications

Call Detail Record Reports
ShoreTel 7.5 Administration Guide C – 7
The file located at "C:\Program Files\Shoreline Communications\Shoreware
Server\MySQL\MySQL Server 5.0\Examples\restore1.bat" is an example of a batch file
that restores a MySQL CDR database under generic default conditions. This file can be
used as a template for creating a batch file that restores the database under specific
conditions. The password is shorewaredba. Restoring a 1.5 GB database requires 1200
seconds.
Database Replication
MySQL provides a Database Replication tool. Access the following web pages for more
information:
• http://www.howtoforge.com/mysql_database_replication provides MySQL
database replication setup information.
• http://solutions.mysql.com/solutions/tools?type=25 lists tools and add-ons that
assist with database replication.
Installing MySQL on a Secondary Server
Although the archive database is normally stored on the main ShoreWare server,
MySQL databases can be installed on a Secondary Server to conserve main server
resources. A separate licensed copy of MySQL Enterprise Server 5.0 is required to
install the database on a Secondary Server.
To install MySQL on a secondary server, perform the following procedure (Replace
c:\Program Files\... in the instructions to the location where MySQL is installed on the
server).
Step 1 Install MySQL Enterprise Server 5.0 on a Secondary server.
Step 2 Select all the default values during installation except for the following
items:
• use root for UserID
• use shorewaredba for the password,
• utf8 for the character set as part of the installation
Step 3 Backup the file c:\Program Files\MySQL\MySQL Server 5.0\my.ini from
the Secondary server to a safe location (i.e. c:\MySQL_backup).
Step 4 Backup the files c:\Program Files\MySQL\MySQL Server
5.0\Data\[ib_logfile*] from the Secondary server to a safe location (i.e.
c:\MySQL_backup).
Step 5 Select Start->Administrative Tools->Services->MySQL
Step 6 Click “Stop the service” and check that MySQL service status is blank
Step 7 Compare the file from the Main server directory c:\Program
Files\Shoreline Communications\ShoreWare
Director\example\archive_MySQL_my.ini with a Secondary server file
c:\windows\my.ini. Make sure that all the parameters specified in the
archive_MySQL_my.ini are set appropriately in my.ini.
Step 8 Archive_MyAQL_my.ini values are as follows.