Article ID: 119556, created on Jan 10, 2014, last review on May 5, 2014

  • Applies to:
  • Odin Business Automation Standard 4.5
  • Odin Business Automation Standard 4.3


We run PBA-S version 4.3 or 4.5 and MySQL server on a separate container. To improve MySQL performance I would like to migrate MySQL server to 64-bit system. How to do this the best way?


  1. Create a container with 64-bit OS, install the latest available MySQL 5.0.xx template.

  2. Stop PBA-S and all its services (hspcd, httpd, pdns, pdns_recursor, postfix, servicemon, taskmand, vzcoll).

  3. Migrate all MySQL databases (not only aspc) to new container with built-in MySQL tools mysqldump and mysql (important).

  4. Reconfigure IPs, services runlevel, firewall, etc. on new 64-bit container, verify access from PBA-S.

  5. Start main PBA-S services (hspcd, httpd), validate PCC/CP/Store.

  6. Start the rest of PBA-S services (pdns, pdns_recursor, postfix, servicemon, taskmand, vzcoll), validate PCC/tasks/DNS/Email.

Important notes

Before doing that, read the following documentation:

Upgrading MySQL

mysql_upgrade — Check Tables for MySQL Upgrade

Upgrade to MySQL 5.1.xx within PBAS 4.3.x is not recommended. After upgrade to PBAS 4.5 you can upgrade MySQL to latest available template of MySQL 5.1.xx. Before processing please read Upgrading MySQL.

Upgrade to further versions of MySQL, i.e. 5.5.xx, 5.7.xx is not recommended as well both for PBAS 4.3.x and PBAS 4.5.

Additional information

How to upgrade PBA-S database to MySQL 5.0

Move PBA-S database to separate server (MySQL5)

Search Words

migrate mysql to 64-bit

mysql database

upgrade mysql

remote mysql database


400e18f6ede9f8be5575a475d2d6b0a6 caea8340e2d186a540518d08602aa065 807e9c1dc97aefd951b912a17e50c428 70a5401e8b9354cd1d64d0346f2c4a3e 624ca542e40215e6f1d39170d8e7ec75

Email subscription for changes to this article
Save as PDF