php-cli and mysql embedded

jsherk

Anybody done any work with mysql standalone or libmysqld deeply embedded?

I am using the php-cli (5.3) on Windows XP Pro with no Apache/server running.

I have spent hours on Google and php.net and mysql.org but just can't seem to grasp what/how to do it!

Thanks

bradgrafelman

Why would you want to embed a MySQL server into an application?

Why not just use SQLite instead?

jsherk

I am using Adobe AIR to build applications, and am able to use php-cli succesfully with it. There a lot php web apps that I want to port over to the Adobe AIR platform and these are full of mysql_ statements.

It should be easier to get MySQL to work, instead of having to go thru hundreds (thousands?) of mysql_ statements and try to rewrite each one to make it compatible with sqlite instead, which would have to be done for each and every php app I want to port.

Hope that makes sense.

VampiChoco

I know this is old but, did you got any solution to this ? Im currently trying to have a minimal php distribution in order to ship it with my CLI PHP tool. I need everything to be static in order for it to be redistributable. What Im needing is curl, mysql and dom support.

jsherk

No I never did figure it out! There is very little information (almost none) on how to set MySQL up as embedded.

I know there is a way to use MySQL Embedded which means you do not have to run MySQL as a service, but have never figured it out.

I did find this program however, which runs MySQL Embedded and Apache and PHP as an exe (not as a service) so you can try this.
http://www.websiteondvd.com/

There is a free trial but unfortunately it is $299 to buy!