{info:title=MySQL database no longer necessary for Server Backup Manager 5.4.0 and later installations}
Server Backup Manager 5.4.0 and later installations no longer require MySQL.
{info}
h2. Hardware prerequisites
Install the Data Center Console on an independent server. It is NOT recommended that you install DCC on the same host with Server Backup Manager.
h2. Software prerequisites
* *Server Backup Manager Upgrade*. Before installing DCC, be sure to upgrade all Backup Managers that you intend to register with DCC. For more information about upgrading your Backup Managers, see [Upgrade Server Backup Manager for Windows] and [Upgrade Server Backup Manager for Linux].
* *MySQL Database Creation* *_(Pre-SBM 5.4.0 installations only)_*. DCC is a MySQL-based application and requires a customer-supplied MySQL database instance and schema in order to properly install and run. The DCC installation and upgrade handles all table creation and any upgrade data migration. However, customers are responsible for the general health, maintenance, and availability of the MySQL database. In advance, create a MySQL database instance and user account with permissions allowing you to create, read, update, and delete objects within the account. DCC requires *InnoDB* storage engine support for the MySQL database instance.
For more information about creating MySQL user accounts and setting permissions, see [http://dev.mysql.com/doc/refman/5.5/en/user-account-management.html|http://dev.mysql.com/doc/refman/5.5/en/user-account-management.html] (external link). For more information about installing MySQL, see [http://dev.mysql.com/doc/refman/5.5/en/installing.html|http://dev.mysql.com/doc/refman/5.5/en/installing.html] (external link).
{info:title=Note}
Make sure that all necessary ports are opened. For more information about managing network ports, see [ServerBackup:Configure network ports].
{info}
h2. Recommended system requirements
* *Operating System*: 64-bit only, Windows Server 2008 R2, or Linux 2.6
* *Physical Memory*: 4 GB
* *Free Disk Space*: Not less than 10 GB
For more information about system requirements, see [Server Backup Manager System Requirements].
----
h2. Creating a MySQL database on Windows (Pre-SBM 5.4.0 installations only)
# Launch the MySQL command line.
# Input your MySQL account password, and then press <Enter>.
# Type the following command to create a database:
{code}create database [DATABASE_NAME];{code}
{info:title=Note}Remember this database name as you later must this information in the {{server.properties}} file.
{info}
The system displays the following message:
{code}Query OK, 1 row affected.{code}
----
h2. Creating a MySQL database on Linux (Pre-SBM 5.4.0 installations only)
# Log in to MySQL, as shown in the following image.
{code}mysql -u [USERNAME] -p{code}
!01aa.png!
# Type the following command to display the list of existing databases:
{code}show databases;{code}
!02a.png!
# Type the following command to create a database:
{code}create database [DATABASE_NAME];{code}
!03a.png!
# Type the following command to verify that the database is created successfully:
{code}show databases;{code}
!04a.png!
----
The next step is described in:
* [Install Data Center Console on Windows]
* [Install Data Center Console on Linux]
{excerpt:hidden=true}The description of Data Center Console prerequisites.{excerpt}
Server Backup Manager 5.4.0 and later installations no longer require MySQL.
{info}
h2. Hardware prerequisites
Install the Data Center Console on an independent server. It is NOT recommended that you install DCC on the same host with Server Backup Manager.
h2. Software prerequisites
* *Server Backup Manager Upgrade*. Before installing DCC, be sure to upgrade all Backup Managers that you intend to register with DCC. For more information about upgrading your Backup Managers, see [Upgrade Server Backup Manager for Windows] and [Upgrade Server Backup Manager for Linux].
* *MySQL Database Creation* *_(Pre-SBM 5.4.0 installations only)_*. DCC is a MySQL-based application and requires a customer-supplied MySQL database instance and schema in order to properly install and run. The DCC installation and upgrade handles all table creation and any upgrade data migration. However, customers are responsible for the general health, maintenance, and availability of the MySQL database. In advance, create a MySQL database instance and user account with permissions allowing you to create, read, update, and delete objects within the account. DCC requires *InnoDB* storage engine support for the MySQL database instance.
For more information about creating MySQL user accounts and setting permissions, see [http://dev.mysql.com/doc/refman/5.5/en/user-account-management.html|http://dev.mysql.com/doc/refman/5.5/en/user-account-management.html] (external link). For more information about installing MySQL, see [http://dev.mysql.com/doc/refman/5.5/en/installing.html|http://dev.mysql.com/doc/refman/5.5/en/installing.html] (external link).
{info:title=Note}
Make sure that all necessary ports are opened. For more information about managing network ports, see [ServerBackup:Configure network ports].
{info}
h2. Recommended system requirements
* *Operating System*: 64-bit only, Windows Server 2008 R2, or Linux 2.6
* *Physical Memory*: 4 GB
* *Free Disk Space*: Not less than 10 GB
For more information about system requirements, see [Server Backup Manager System Requirements].
----
h2. Creating a MySQL database on Windows (Pre-SBM 5.4.0 installations only)
# Launch the MySQL command line.
# Input your MySQL account password, and then press <Enter>.
# Type the following command to create a database:
{code}create database [DATABASE_NAME];{code}
{info:title=Note}Remember this database name as you later must this information in the {{server.properties}} file.
{info}
The system displays the following message:
{code}Query OK, 1 row affected.{code}
----
h2. Creating a MySQL database on Linux (Pre-SBM 5.4.0 installations only)
# Log in to MySQL, as shown in the following image.
{code}mysql -u [USERNAME] -p{code}
!01aa.png!
# Type the following command to display the list of existing databases:
{code}show databases;{code}
!02a.png!
# Type the following command to create a database:
{code}create database [DATABASE_NAME];{code}
!03a.png!
# Type the following command to verify that the database is created successfully:
{code}show databases;{code}
!04a.png!
----
The next step is described in:
* [Install Data Center Console on Windows]
* [Install Data Center Console on Linux]
{excerpt:hidden=true}The description of Data Center Console prerequisites.{excerpt}