473,320 Members | 1,746 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Update remote mysql database from an online mysql database.

I have an online hosted website that uses mysql database.

Now, what I am trying to do was to update my remote database. What I mean was, a different mysql database that is not online.

I used php and mysql in my website and vb.net and mysql on the remote computer.

I needed something of an update button on my vb.net application to synchronize my online mysql database with the remote mysql database.

To give you a clearer scenario:

I have an online grading system wherein the instructors in my school can upload the grades of their students. I also have a kiosk type stand within the school that the students can use to view their grades. The problem arises, how can I update the kiosks' database and gather data from the online database?
Feb 22 '11 #1
3 4362
If the kiosk has web access why not just run the script on the server thru a browser or application? Why have 2 db's?
I have no idea what to suggest since you gave no details on how the kiosk even works.
Feb 22 '11 #2
Hi NetDynamic! Thank you for the reply.

"I have no idea what to suggest since you gave no details on how the kiosk even works."
->The kiosk simply displays the queried grades of the student that logged into it.

"Why have 2 db's?"
->For the speed of querying purposes, I have decided to separate the kiosk database from the online database.

"If the kiosk has web access why not just run the script on the server thru a browser or application?"
->Exactly the thing that I was asking for. Yes, the kiosk has web access to be able to update and synchronize its database from the online database.


Take for example, antivirus in your system will update its database from its online source. How then can it be achieved?

Can I rephrase my question? How can I connect my vb.net application into an online mysql database?
Feb 22 '11 #3
dgreenhouse
250 Expert 100+
I understand that you've invested time in the kiosk vb app, but you'd probably make your life easier if you operate the kiosk in "full screen" browser mode and have a student "read/only" access page running on the webserver.

If you really need to maintain the vb/kiosk app, one possible solution would be...
1- Create periodic csv files on the webserver via a cron job
2- Create a scheduled task on the kiosk to download the csv to a temp location on the kiosk
3- Modify the kiosk database with the downloaded data

Other solutions/scenarios are possible, but would probably be more complicated.

Other thoughts...

I don't know what platform you're running on the webserver (PHP, .NET, etc.), but you could create a database abstraction layer on the webserver that does something like the following:

1- Have a url specific to the update select records that have been updated/created since some defined time period
2- The vb app does a request to a url on the webserver that then return records (probably as xml) to the vb app that then updates its local database.

That way you don't have to worry about sending large volumes of data to the kiosk.
Feb 26 '11 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: jason | last post by:
Products ---> Products|Customer <--Customer With regardst the above many-to-many relationship: Is there any advantage in creating seperate access databases for: - Customer - Products ...
13
by: J.P | last post by:
Hi! Anyone knows if it's possible to do an update if, and only if my condition is TRUE. Example: In MYTABLE I have three columns, like this: ID(INT), PUBLISH(ENUM(Y,N)),...
0
by: bettina | last post by:
I had an Access database and I had always used in my tables (whenever possible) pop up lists to choose elements.. for example, for a column I've wrote in "Datensatzherkunft" SELECT tbl.field1 FROM...
9
by: Daven Thrice | last post by:
If I have a fairly big Access MDB, that is relational, and has, say, 100 objects (forms, reports, modules, etc.), what is the path to get this database "online". Is there a way to put the tables...
4
by: Dan Lewis | last post by:
I've imported a ms access database into a table in a mysql database. The access database contains a field that holds date/time values in 'general date' format. These all show up at 01/01/1970 in...
14
by: mistral | last post by:
Need php script to create mySQL database programmatically; since hosting configuration may not allow create database from script, script also need eliminate/rewrite all restrictions in appropriate...
3
by: John Morgan | last post by:
I have my first small SQl Server 2005 database developed on my local server and I have also its equivalent as an online database. I wish to update the local database (using and asp.net interface)...
2
by: occyink | last post by:
I run a website selling cartridges. My stock on the website is in a MySql database. My accounts package and invoicing software runs on an Access database. In my website databse there is a table...
6
by: markodilore | last post by:
Hey Guys, you helped me once when I tryied to create a database : "Access denied for user ''@'localhost' ". On my Mac OS 10.4, I had no problem creating database and modifying it from the terminal....
6
rizwan6feb
by: rizwan6feb | last post by:
I have to develop a database application in vb.net 2005 with the following rules 1. The application connects with an online mysql database (i.e database resides on a remote machine) 2. The...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.