Drawing Data from mysql DB to use on app

majika · October 29th, 2006, 09:42 PM

Hi please can some one guide me as to which is the best method for me to use to retrieve sales data from my online shop so I can analyse the data and edit and insert new records of the same and different records once I have in on my internal network servers ?

I am running Apache Mysql PHP setup.

I can connect to server using my script I can query using my scripts but cant resubmit it back to original database which is held remotely out of my internal network structure?

Many thanks in advance

ciderpunx · October 31st, 2006, 07:11 AM

So, you've got SELECT privileges on your remote MySQL server but not UPDATE/INSERT?

If you have administrative rights on the server you could just grant your account UPDATE/INSERT priviliges

Code:

GRANT UPDATE on `my_database`.`my_table` TO 'my_account'@'my_location' IDENTIFIED BY 'secret_password';
FLUSH PRIVILIGES;

If not you'll have to make friends with the admin

--
Don't Stand on your head - you'll get footprints in your hair
http://charlieharvey.org.uk
http://charlieharvey.com

majika · November 1st, 2006, 09:27 AM

Cheers for reply ciderpunx, Just to confirm that it is a shared hosting account that all the data is on But I do believe I have ADMIN PRIVLIGES on will but i'm not root @ hostname, but anyway, The remote site is where I need to get the data from to update my localhost application every 15 mins so it is kind of real time system that I am trying to develop.