Hey all, quick question. I just inherited about 20 sites running MetaTraffic with Access and I would like to move these to MySQL. Is there an easy way to do this? I can easily get the data from the Access DB into MySQL but was not sure about connection strings or other configuration settings with MetaTraffic, as I have never used this package.
Thanks
John
Migrating from Access to SQL
Hi John,
If you move all the data, all you should need to do is edit the conn.asp file to point to the new database. This file should be configured as follows:
<%
Dim aryMTDB(5), objConn
aryMTDB(0) = "MYSQL"
aryMTDB(1) = "localhost" ' IP ADDRESS OR HOSTNAME (CAN BE FOLLOWED BY PORT # OR USES DEFAULT PORT e.g. mysql.domain.com:55555)
aryMTDB(2) = "dbname" ' NAME OF MYSQL DATABASE
aryMTDB(3) = "user" 'MYSQL USERNAME
aryMTDB(4) = "pass" 'MYSQL PASSWORD
aryMTDB(5) = "mt_" 'TABLE PREFIX
%>
If you want all the installs to run on the same database, give them a unique table prefix and rename the tables to correspond to the appropriate table prefixes.
Regards,
~Chad