Q. How do I convert my DMXReady application to use MySQL?
Â
A. You may choose to convert your DMXReady application by following the steps below. Please note that since every server is different, you should contact your webhost provider to confirm all details about using MySQL.
- Setup your MySQL database on your host server
- Import the MySQL database dump file for your respective app (download the MySQL database dump file here OR use a conversion program like: http://www.bullzip.com/products/a2m/info.php)
- Adjust the DSNLESS connection string to connect to the MySQL database. The DSNLESS connection string is located in the "/Connections" folder.
Below is a sample connection script used by the Links Manager to connect to a MySQL database. The same logic would apply to all DMXReady apps. Check with your webhost provider to ensure that this connection string will work with your server.
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
MM_LinksManager_STRING = "driver={mysql};database=*****;server=*****;uid=*****;pwd=*****;option=16386;"
%>
You can learn more about converting your database here:
Â
- http://dmxready.helpserve.com/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=10
- http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_16575&sliceId=2Â
- http://www.kitebird.com/articles/access-migrate.html (includes a self-evaluation to find out if conversion is right for you)
For help with upsizing your database to MS SQL, See here: http://dmxready.helpserve.com/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=10
