I have on PHP/MySQL application. online and offline.
how do I insert record in the offline MySQL db then update successfully on-line db?
Cann sommes one help me?
how do i work offline db then update successfully on-line db
Moderator: General Moderators
Re: how do i work offline db then update successfully on-line db
Generally that's a bad idea to start with. Usually data should be stored in one place only. You can have back-ups. You can also have several databases that "replicate" each other, that is, synchronize the data on a scheduled basis, but that requires quite a lot of work to set up. You could write your application to write to both databases every time you updated anything, but you should have a very good reason why you want to do that. So it would be a good idea if you told us WHY you think you want to do this.blackbird wrote:I have on PHP/MySQL application. online and offline.
how do I insert record in the offline MySQL db then update successfully on-line db?
Cann sommes one help me?
Re: how do i work offline db then update successfully on-line db
If this is something you only need to do occasionally, you could simply print all the queries to a file and then execute the file on the server using phpMyAdmin or the command line.
We really need to know why you need to do this however to give you a best answer.
We really need to know why you need to do this however to give you a best answer.
Re: how do i work offline db then update successfully on-line db
Thanks to reply to my post.
basically I need my application to be install on USB for those who do not have internet connection. They can work off-line by recording data in the off-line MySQL db through the off-line application.
As soon as they have internet connection they should have the possibilities to upload (Update the on-line MySQL db).
for that purpose I want implement a small interface to help them interact between the off-line and the on-line database tables.
is there some body who can help me?
Thanks for your help
basically I need my application to be install on USB for those who do not have internet connection. They can work off-line by recording data in the off-line MySQL db through the off-line application.
As soon as they have internet connection they should have the possibilities to upload (Update the on-line MySQL db).
for that purpose I want implement a small interface to help them interact between the off-line and the on-line database tables.
is there some body who can help me?
Thanks for your help