* biostar_ve is the video database (version 2.5 and above)Ģ1.On the right column Schema Objects, check that all tables are checked.Ģ2.On Objects to Export check all three items.Ģ3.For Export Options select Export to Self-Contained File. * biostar2_ac is the AC database and biostar_tna is the T&A database. * It is recommended to back up the AC and TA database separately. On Object Selection – Schema, select the database you want to back up. The account you configured in the BioStar 2 express installation is root.ġ5.Click Store in Vault … and enter password.ġ6.Click Test Connection and check that it is successful.ġ7.If you see a Connection Warning click Continue Anyway.Ģ0. Visual C++ Redistributable for Visual Studio 2015ĩ.After installing all the prerequisites, run the MySQL Workbench installer again.ġ0.Launch MySQL Workbench with administrator privileges.ġ4.Enter your database administrator id in Username. Click Download Prerequisites.Ĩ.The link will guide you to download the files below.
#INSTALL MYSQLDUMP WINDOWS INSTALL#
If you enable the "Secure Communication with device" option, you will have to back up the cert folder in the path below.Ĭaution: You must stop your BioStar 2 server when backing up and restoring the database.ģ.Click Download Now to download MySQL Workbench.Ĭaution: use the 6.3 version of Workbench, latest versions have issues with backupĤ.Click Looking for previous GA versions then select version 6.3.10 and click download.ĥ.Click No thanks, just start my download.ħ.It will ask you to install the prerequisites. This only applies to version 2.3 T&A and this process is not required for version 2.4
#INSTALL MYSQLDUMP WINDOWS PC#
If you are making a clean uninstall and reinstalling BioStar 2.3 in the server PC or if you are installing and restoring BioStar 2.3 in another PC, you will have to back up the security folder in the path below:Ĭ:\Program Files\BioStar 2(圆4)\ta\securityĬopy the files in the folder and paste it the same path of your new BioStar 2.3 when restoring your T&A. You will have to install MySQL Workbench to back up and restore the database.
MS SQL Database Backup and Restore Instructions
Note: For MSSQL backup, refer to the following link.
Note that the AC database can be backed up easily with a copy and paste after stopping BioStar 2 services because it is a SQLite DB.įor the T&A database, use the option to back up with the instructions shown in 2.3~ Database Backup below.
#INSTALL MYSQLDUMP WINDOWS PDF#
You can use refer to the PDF attachment to back up your BioStar 2.0~2.2.2 database. Refer to the backup instructions in the 2.6 database backup section below. For BioStar 2.6, you must back up the encryption key. If you would like to re-use your BioStar 2 license, refer to the following article: Reactivating the License Refer to the image below to see the changes in the Database in BioStar 2 versions.Īutomatic database backup of AC database is only supported up to version 2.2.1 Hence the backup method has changed as well. Starting version 2.3, both databases became Maria DB by default (express installation). The AC database started out with the SQLite Database and in version 2.2.1, the MariaDB T&A database was released. BioStar 2's database has gone through a few changes since it's release.