MES Server Backup Operation
MES服务器可以分成系统备份和数据备份两部分，系统备份保证MES服务可以运行，数据备份的目的有两个，一个是保证正确的基础数据，二是备份历史数据，减少磁盘空间的占用。 MES Server can be divided into system backup and data backup. System backup makes MES service go in normal operation, with two purposes, one is to ensure correct basic data, the other is to backup historical data to reduce occupancy of disk space.
1.系统备份
1. System Backup
整个系统进行备份，无需进行热备份，但建议轮换使用两套系统。比如1月1日至6月30日使用A系统，7月1日至12月31日使用B系统，以便保证两套系统都可以正常运行。
You can backup the whole system without hot backup, but we suggest interchangeably using two systems. For instance, you can use System A from Jan. 1st to Jun. 30th, and System B from Jul. 1st to Dec. 31st to ensure normal operation of these two systems.
1.1.分区备份
1.1. Partition Backup
安装操作系统时，将磁盘分为2个分区，一个分区为操作系统和工作分区（C 盘），一个分区为备份分区（D盘）。
When installing the operating system, pls divide the disk into two partitions, one partition is operating system and working partition (Disk C), and another is backup partition (Disk D).
在调试完成后，所有参数都已经确定时。包括IP地址，MySQL数据库和MES 服务软件的配置文件。将工作盘做一个磁盘分区镜像文件，拷贝到本机的D盘。同时制作一个启动U盘，把镜像文件也拷贝到启动U盘中。当系统崩溃时可以用该镜像文件恢复系统。 After debugging, all parameters are definite, such as IP address, MySQL database and configuration files of MES service software. At this moment, pls create mirror files of disk partition and copy to Disk D on this computer. At the same time, pls make a bootable USB flash disk and copy mirror files to the USB as well. So that you can restore the system with mirror files when it crashes.
但要注意恢复后要用最新的数据库备份文件更新老的数据库。
Note: Pls update old database with backup files of the latest database after restoring the system.
1.2.磁盘备份
1.2. Disk Backup
在调试完成后，所有参数都已经确定时。包括IP地址，MySQL数据库和MES 服务软件的配置文件。
After debugging, all parameters are definite, such as IP address, MySQL database and configuration files of MES service software.
另外拿一个硬盘，重新安装操作系统和所有的软件。调试完成后，拔下该硬盘，妥善保存（实际操作时，可以利用GHOST软件的硬盘备份功能）。当硬盘出现异常时，用备份硬盘替换现有硬盘。
Pls prepare a hard disk to reinstall operating system and all software. After debugging, pls unplug the hard disk and keep it well. (Pls use the backup function of Ghost software.) When an unexpected error occurs on the hard disk, pls substitute existing hard disk with backup hard disk.
但要注意更换硬盘后用最新的数据库备份文件更新老的数据库。
Note: Pls update old database with backup files of the latest database after replacing the hard disk.
1.3.计算机整机备份
1.3. Cloud Server Backup Service (CSBS)
在调试完成后，所有参数都已经确定时。包括IP地址，MySQL数据库和MES 服务软件的配置文件。可以称之为1号MES服务器。
After debugging, all parameters are definite, such as IP address, MySQL database and configuration files of MES service software. Which can be called No.1 MES server.
调换一台计算机进行MES服务系统的安装调试，完成后下线保存。作为整机备份，2号MES服务器。出现异常时，可以将1号服务器下线，2号服务器上线。
Install and debug MES service system by another computer (No.2 MES server),
and then save it offline. When an unexpected error occurs, pls make No. 1 server offline and No. 2 server online.
但要注意上线后要用最新的数据库备份文件更新老的数据库。
Note: Pls update old database with backup files of the latest database after being online.
2.数据备份
2. Data Backup
MES服务依赖基础数据库进行订单小件的解析，因此一旦更新了小件信息，必须立刻进行数据库备份。此外，由于每个订单的信息保存在数据表中，随着时间的积累，数据库可能会变大，影响检索效率。 MES parses small parts based on basic database, so you need to backup database when there is updated information about small parts. In addition, database will become bigger and bigger along with the time, which will affect retrieval efficiency.
2.1.基础数据备份
2.1. Basic Data Backup
基础数据主要可能变化的是小件表，数据表名是t_part。当更新小件信息后，需要对小件表进行备份。
Small part form, which is called t_part, is most likely to change in basic data. When there is updated information of small parts, you need to backup the form.
当恢复系统后，用备份的数据表文件恢复最新的小件信息，保证订单能够正常解析；工位看板能够正常显示小件信息。需要提醒的是，为了减少网络通信负担，加快订单信息的传递，看板软件在启动时会缓存基础信息。因此小件更新后，看板软件需要重新启动。
After restoring system, pls restore the latest information of small parts with backup database files to guarantee the normal parse of orders. Information of small parts can be presented properly on the display board. In order to reduce the burden of network communication and accelerate transmission of order information, the display board software can cache basic information when starting up. Accordingly, you needs to restart the software after small parts update.
备份的过程如下，首先打开MySQL Workbench，选择Management选项卡，如下图左下角红圈中指示。然后再选项卡中选择Data Export（下图左上部红圈所示）。右边的界面切换到Data Export页，如下图所示。在Tables to Export左边对话框里选择mexg20mesdatabase，右边对话框中选择t_part表（注意其余的表一定不要勾选，只选择t_part表）。其余选项不要改动，尤其Tables to Export 框下方的Dump Stored Procedures and Functions，Dump Events和Dump Triggers三个选项要勾选。第三步，在Export Options框中选择Export to Self-Contained File选项，在后面的文本框中输入备份文件的目录和文件名。最点击Start Export按钮，如下图右下角红圈所指示。
The backup process is as follows. Firstly, open “MySQL Workbench”, choose “Management”, as shown in the red circle in the lower left corner. and click “Data Export” (as shown in the red circle in the upper left corner). Then the interface
豫公网安备41160202000603
站长QQ:729038198
关于我们
投诉建议