I have tried the following code in the switch.conf.xml file and did not work.  I went ahead and have followed the instructions in the link below, but I can't seem to access the "Compile FreeSWITCH with ODBC Support" section.
We are running freeswitch 1.6.19 and it was originally installed from the Debian repos.  (yes I know it is an old build and we will upgrade, but it shouldn't affect what I am trying to do at the moment)

<param name="core-db-dsn" value="odbc://DRIVER=mysql;SERVER=<ip>;UID=devsca01;PWD=<password>;DATABASE=devsca01">




I have created a remote DB and gave it the proper permissions.  When I tested it, it appears to connect, but not sure where to go from here.

root@dev-sca01a:/etc/freeswitch# isql -v devsca01   
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> 



On Fri, Feb 14, 2020 at 12:36 PM David Villasmil <david.villasmil.work@gmail.com> wrote:
That’s right. You don’t need to do anything else. Just make sure the user you setup in freeswitch has rights to create db, tables, etc.

On Fri, 14 Feb 2020 at 11:59, Joli Martinez <mrjoli021@gmail.com> wrote:
Hello,

So if I understand correctly.  I will create a new mysql DB, update the switch.conf.xml and  restart FS.

Is that correct?

On Fri, Feb 14, 2020 at 10:30 AM Giovanni Maruzzelli <gmaruzz@gmail.com> wrote:
Hello,

you don't need to import anything, all tables are created runtime, and they are for internal FreeSWITCH usage, so FS will populate them, you do not need to do anything. Obviously, you will lose all registrations, until phones re-register.

Do a lab, and experiment a little to get the Knack of it

-giovanni


On Fri, Feb 14, 2020 at 4:03 PM Joli Martinez <mrjoli021@gmail.com> wrote:
Hello,

We have several freeswitch boxes that are running sqlite.  We have outgrown this and need to move the DB to mySQL.  Not sure how to import it, or if there is a procedure already in place for this.  What would be the best option for this?

let me know
_________________________________________________________________________

The FreeSWITCH project is sponsored by SignalWire https://signalwire.com
Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services.
Build your next product on our scalable cloud platform.

Join our online community to chat in real time https://signalwire.community

Professional FreeSWITCH Services
sales@freeswitch.com
https://freeswitch.com

Official FreeSWITCH Sites
https://freeswitch.com/oss
https://freeswitch.org/confluence
https://cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
https://freeswitch.com


--
Sincerely,

Giovanni Maruzzelli
OpenTelecom.IT
cell: +39 347 266 56 18

_________________________________________________________________________

The FreeSWITCH project is sponsored by SignalWire https://signalwire.com
Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services.
Build your next product on our scalable cloud platform.

Join our online community to chat in real time https://signalwire.community

Professional FreeSWITCH Services
sales@freeswitch.com
https://freeswitch.com

Official FreeSWITCH Sites
https://freeswitch.com/oss
https://freeswitch.org/confluence
https://cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
https://freeswitch.com
_________________________________________________________________________

The FreeSWITCH project is sponsored by SignalWire https://signalwire.com
Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services.
Build your next product on our scalable cloud platform.

Join our online community to chat in real time https://signalwire.community

Professional FreeSWITCH Services
sales@freeswitch.com
https://freeswitch.com

Official FreeSWITCH Sites
https://freeswitch.com/oss
https://freeswitch.org/confluence
https://cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
https://freeswitch.com
--
Regards,

David Villasmil
email: david.villasmil.work@gmail.com
phone: +34669448337
_________________________________________________________________________

The FreeSWITCH project is sponsored by SignalWire https://signalwire.com
Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services.
Build your next product on our scalable cloud platform.

Join our online community to chat in real time https://signalwire.community

Professional FreeSWITCH Services
sales@freeswitch.com
https://freeswitch.com

Official FreeSWITCH Sites
https://freeswitch.com/oss
https://freeswitch.org/confluence
https://cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
https://freeswitch.com