Difference between revisions of "Convert SQLite Database to MySQL"
Line 6: | Line 6: | ||
* Go to General Settings > Tools. Select "Convert SQLite Database to MySQL". | * Go to General Settings > Tools. Select "Convert SQLite Database to MySQL". | ||
* Enter the required information and click on Execute. | * Enter the required information and click on Execute. | ||
− | * After the process completes | + | * After the process completes run the configuration utility and configure TCAdmin to use the MySQL database and restart. http://x.x.x.x:8880/Interface/Config/Default for MVC and http://x.x.x.x:8880/Interface/Configuration/Default.aspx for ASP.NET |
== Configure Remote Servers == | == Configure Remote Servers == |
Revision as of 20:07, 21 January 2020
Convert your Database
You can convert your SQLite database to MySQL using the tool available at General Settings > Tools.
- Install MySQL on your master server.
- Create an empty MySQL database and user.
- Go to General Settings > Tools. Select "Convert SQLite Database to MySQL".
- Enter the required information and click on Execute.
- After the process completes run the configuration utility and configure TCAdmin to use the MySQL database and restart. http://x.x.x.x:8880/Interface/Config/Default for MVC and http://x.x.x.x:8880/Interface/Configuration/Default.aspx for ASP.NET
Configure Remote Servers
After you have configured your master it is recommended that you enable remote db connections. Go to Server Management > Remote DB Connections. Enter the information required to connect to the database there.
Generate a new ConfigUtility.config for each of your remote servers. Place it in the remote's Monitor folder (/home/tcadmin/Monitor or Program Files\TCAdmin2\Monitor) and restart the monitor. It is recommended that you start the monitor in console mode first to make sure it connects to the database correctly.