Page 1 of 1

Running an "offline" version of mysql

Posted: Tue Oct 03, 2006 2:00 pm
by mfcurry
I've been asked to take a php/mysql web app and somehow make the database available to the client on their laptop, when they don't have an internet connection.

They want some sort of Windows front end for editing the data. Not simply the control center, since the client isn't very computer literate. Something more like Filemaker.

Even worse they want to be able to merge the "offline" database back into the online database, which probably has changed since "offline" version was captured.

Anyone have any ideas...preferably something pre-canned and quick to implement, since the boss believes "this is a simple task and shouldn't take more than an hour or two to throw together".

I'm leaning towards just intstalling the whole web app on their laptop (apache/mysql/php), but I have no idea how to merge the data.

Posted: Tue Oct 03, 2006 2:43 pm
by MrPotatoes

Posted: Tue Oct 03, 2006 9:11 pm
by waradmin
I havent ever used that, but I have used apache2triad (http://www.apache2triad.net) and it works great. Also it has a web-based control panel built in (localhost/apache2triadcp) that allows server configuration without needing to go and find config files and touch them. Also includes a mail server and ftp server if you want to ftp data to the laptop, etc.

Its worth a look as well.

Posted: Tue Oct 03, 2006 10:41 pm
by nickvd
You'd still need php/apache, but you could probably get away with mysqli on the laptop. Write an export from web, and an import to web set of functions to move stuff back and forth.

Though, if you're already going to install php/apache, you may as well just use mysql to keep everything on the same page...