creating an ap CD

[adavis]

😕 I've developed a web based set of scripts in php with a mySQL database. Someone actually wants to "buy" it. They want me to send them a CD so they can demo it to several different groups. I'm the only one who developes in PHP/mySQL in my office, so no one here can advise me on what I need to do and actually they don't know how to do it in their language either (ASP & MS-SQL or Oracle).

However, one of my office mates says that in MS-SQL you can de-attach, re-attach a database which will carry over all the structure and files. Can you do this in mySQL and how would I go about doing it?

If this takes care of the database, is there a way to create the CD so my application will run from the CD or will they need to load the files to their server?

Does anyone know of a website that explains how to do this or can someone just explain it to me?

Thanks,
Alisa

[AstroTeg]

An interesting problem...

The requirement of the CD would be the user would need a working copy of Apache plus PHP plus MySQL. Without any one of those and you're scripts are stuck.

You could export all your MySQL data to a text file. PHPMyAdmin does an excellent job. Have it export the data and structure. To be nice, you will want to edit this text file to include some SQL to create the database and set it so the created SQL will import into that database. You'll also want to create the same user your script uses for this database. Doing this is also a great way to ensure your PHP scripts will be using the correctly named database with user info).

Then its a matter of putting your site files out on the CD and maybe passing off instructions on how to copy them to their new home.

Another alternative might be to check out some of the live Linux CDs that are out there (such as Knoppix). Web servers do not do very well in a read only environment, but maybe someone has a work around...