Running an "offline" version of mysql

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
mfcurry
Forum Newbie
Posts: 3
Joined: Wed Mar 29, 2006 10:56 pm

Running an "offline" version of mysql

Post 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.
User avatar
MrPotatoes
Forum Regular
Posts: 617
Joined: Wed May 24, 2006 6:42 am

Post by MrPotatoes »

User avatar
waradmin
Forum Contributor
Posts: 240
Joined: Fri Nov 04, 2005 2:57 pm

Post 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.
nickvd
DevNet Resident
Posts: 1027
Joined: Thu Mar 10, 2005 5:27 pm
Location: Southern Ontario
Contact:

Post 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...
Post Reply