[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


upload local database to a live database

Posted on 2006-05-27
Medium Priority
Last Modified: 2008-02-26
I had a question for ya...

Hopefully it will be brief...

I have a client that is a mechanic.

He wants to have a worksheet/form that he fills out on every repair he does.

Its basically about 50 yes no or NA questions, that I will set up as radio buttons.

I believe I can handle most everything on the form and the database.

The issue That I have is that I want to set up a Laptop for him that he can use while doing the repairs.

That he can fill the form out and it will store it in a local database.

Then when he is in his office all he will need to do is upload it to his "live" website database...

Any ideas on how I could do that?
Question by:noel4nopun
LVL 50

Expert Comment

ID: 16778725
which Database system are you intending to use...

if it was SQL server then the process could be handled by merge replication...

what is your actual scenario ...

will the mechanic just be acting on "pulled" worksheets
or will he actually be able to create "new" work that will also need to be inserted into the main database?

LVL 16

Expert Comment

ID: 16779186
Generate a flat file or XML file. There are lots of methods to upload flat files to most databases.

Author Comment

ID: 16779260
I want to set it up using php and mysql

not sure about the "pulled" but I would assume it is a new one...

He wants to have a "PM" (which is the form of 50 or so questions), he wants a form for say 5 different types of trucks. and keep these all collected by clients.

I am sure that the database design itself is going to keep me quit busy, But my Main concern for now is...

I was thinking of setting apache + php + mysql on a local laptop for him to use onsite...
And then my hopes are that he would then later be able to upload his "local" databse up to the "live" one.

Not too sure how to approach this.

PS I am new to expert exchange, tis is my first question and I want to thank you for getting back to me...


Accepted Solution

johnsy32 earned 200 total points
ID: 16780061
Copy the local table to a disk, create an update query in the live database to update the corresponding table.

Author Comment

ID: 16780124
I think this idea of coping a table to the hard drive/disc then updating the database is the way to go.

Now on to, how to figure that out.



Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question