Win32 PennMUSH and MySQL

While we cannot distribute precompiled Windows binaries of PennMUSH with MySQL support compiled in and enabled, I have written a README for building your own binary of PennMUSH using the Windows installation of MySQL available from the MySQL website. The README.MySQL is currently available as a part of the 1.7.7p34 tarball, in the win32 directory.

My instructions were primarily drawn from using MSVC++ to compile the binaries, but they should work with little to no changes in a MSys + MinGW environment and a more standard unix-like build process (./Configure -d ; make ; make install ).

With that said, the MySQL support is still relatively new, and as such hasn't received extensive testing upon Windows by me. I will attempt to provide what support I can for issues that arise.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Documentation?

Hi,

Do you have a link to documentation about the MySQL features, please? Does the MySQL build completely replace the flat database files?

Thanks in advance,
EricT.

MySQL support

SQL support (Penn now has MySQL, PostgreSQL and SQLite) doesn't affect the way Penn saves it's own data - the normal game (and mail and chat) databases are saved the same as ever. It just enables the @sql command (and sql() function) so you can write code that accesses data stored in an SQL database. It's mainly used to provide a simpler way to store and query data than keeping things on objects in attributes, and also to make certain bits of data available both in and out of the MUSH (character bios, player's mail or bb posts, news files, etc).

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.