Synchronise MySQL database with website database (1 Viewer)

K

Kevola

Guest
Hi,

I am trying to update the stock levels on our company website on a daily basis with those found in our stock system.

Our stock system uses MySQL for the backend and Access 2003 for the front end.

Our website (www.epactrading.co.uk) uses php and a MySQL database. The website was not built by me but is a piece of software that allows me to log into the backend and add products, categories, update stock levels etc. Unfortunately the company we paid the software for will not give me/tell me how to gain direct access to the MySQL database, apart from using the back end provided by them. I am assuming/hoping the the user name and password to log into the back end is the same to access the tables in the database.

Does anyone know how I can find out the table structure or gain access to the tables in the website database?

Also I cannot run my own php scripts on the server, which is how I was originally hoping to update the site.

Thanks for your time
Kevin
 

Users who are viewing this thread

Top Bottom