Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > PHP/MySQL > MySQL
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
MySQL General discussion about the MySQL database.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the MySQL section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old October 29th, 2006, 09:42 PM
Registered User
 
Join Date: Oct 2006
Location: Llanelli, Crmss, United Kingdom.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to majika Send a message via Yahoo to majika
Default Drawing Data from mysql DB to use on app

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


Reply With Quote
  #2 (permalink)  
Old October 31st, 2006, 07:11 AM
Friend of Wrox
Points: 1,515, Level: 15
Points: 1,515, Level: 15 Points: 1,515, Level: 15 Points: 1,515, Level: 15
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2003
Location: Oxford, , United Kingdom.
Posts: 488
Thanks: 0
Thanked 3 Times in 3 Posts
Default

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
Reply With Quote
  #3 (permalink)  
Old November 1st, 2006, 09:27 AM
Registered User
 
Join Date: Oct 2006
Location: Llanelli, Crmss, United Kingdom.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to majika Send a message via Yahoo to majika
Default

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.

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Retrieve image data from mysql db vermaarun2005 PHP Databases 0 July 14th, 2007 11:12 AM
problem writing listview data to mysql db method Pro VB 6 2 April 10th, 2007 07:17 PM
problem writing listview data to mysql db method Pro VB Databases 0 May 17th, 2006 06:18 AM
problem with uploading blob data to MySQL DB kyle_shea PHP Databases 1 March 8th, 2005 06:15 PM
Storing PHP Session data in a MySQL db? CFerthorney PHP Databases 1 May 10th, 2004 08:33 AM



All times are GMT -4. The time now is 02:26 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.