View source for Convert SQLite Database to MySQL

== 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

<span style="color:red">If you get an error about missing tables uninstall any modules that you have installed. Then install them again after converting the database successfully.</span>

== 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 [[Server_Components#Start.2FStop_in_Console_Mode|start the monitor in console]] mode first to make sure it connects to the database correctly.