Hi Peter,
Thanks for the response! I'm still getting to know the waters of different databases/connections, thanks for the note about the ODBC being the connector. I had actually read that before, but it slipped my mind when I typed my message.
I'm pretty sure the database we are connecting to is MYSQL as well. Is there a way to check what databases are running across a network and get the information about what database they're running. I've tried searching for a command to use but am coming up short on how to select and retrieve info on a database that's on our network in linux. The information I DO have about it is below (slightly altered for security, etc.)
More Connection Information
Work Database
db.ourserver.local
10.215.xx.xxx
Port:1234
Server Name: DB
user:USER
password:PASSWORD
encryption method: simple
I also have a connection file that we had used with excel:
<title>Query from DB1</title>
<xml id=docprops><o:DocumentProperties
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns="
http://www.w3.org/TR/REC-html40">
<o:Name>Query from DB1</o:Name>
</o:DocumentProperties>
</xml><xml id=msodc><odc:OfficeDataConnection
xmlns:odc="urn:schemas-microsoft-com:office:odc"
xmlns="
http://www.w3.org/TR/REC-html40">
<odc:Connection odc:Type="ODBC">
<odc:ConnectionString>DSN=DB</odc:ConnectionString>
<odc:CommandText>SELECT v_Discounts.FOX_DIS_FK, v_Discounts.DIS_Description FROM ecrs.v_Discounts v_Discounts</odc:CommandText>
</odc:Connection>
</odc:OfficeDataConnection>
</xml>
<style>
I don't know if this is helpful. I guess I am trying to - in a sense - reverse-engineer the connection from this info so we can set up a synced database in MYSQL. My first thought was creating a connection string or use the method referred to here:
http://toyhouse.cc/profiles/blogs/synchronize-databases-by-phpmyadmin, but I wanted to get a stronger sense of where I am before I start just doing things.
If you or anyone else has a suggestion on where to start, Peter, that would be appreciated!
Kind Regards,
BD