running php and mysql on cdrom

[Anon]

hi,
searched the archive, found some discussion on this topic but no concrete solutions posted.

once again, has anyone tried running php and mysql from a cdrom? search utility shld be incorporated as well. basically, the objective is to have a catalog pressed onto a cdrom so that user can browse and search from the cdrom, without internet connection.

thanks!

[tasistro]

Well on my Linux box I have the dbases on

/var/lib/mysql

each dir is a dbase. You could mount your cdrom on say /var/lib/mysql/mycatalog and start the mysql deamon. Mysql and php would probably have to be installed on the computer though.

The other option is to have a special script on the CD which starts mysql off it. You have to consider that mysql will try to log errors and look for touched files and pid files. You will have to have access to a writable filesystem with enough rights to do that.

/safe_mysqld --datadir=$datadir --pid-file=$pid_file

starting something like the above with $datadir=/mnt/cdrom/mycatalog
should work

As for php, well are you going to use some stand alone implementation I believe. Web based wouldn't work to well 🙂

Saludos
Gerardo

[Anon]

well, i guess the user will need to have some sort of config on the PC.

any idea how to jus run the catalog off the cdrom without installing any stuff on the PC?

side track, if it aint possible with PHP and mysql, wat other open-source languages can?

[tasistro]

I never tried running mysql of a cdrom, though I think it is possible. Just consider the rights to create files.

check out

http://gtk.php.net/

it is another way to use php.

Aside from that I would recommend python as a language.

Saludos
Gerardo

[greg252]

how much data are we talking about.
Is mySQL necessary?

Might be worth it, and please don't yell at me, to use a flat-file system and write the whole thing in Java. The reason being, modern OS's have the ability to work w/ Java without any install.