These are some brief notes about the process of creating a help screens SQL dump file that can be used to set up a local help server which can serve help screens for Joomla! 1.5 instances. It is important to note that the help server must be running on Joomla! 1.0 at this time.
Note: These notes were written to document the process required to create a dump file from help.joomla.org. You will need to adapt the process to create a dump file from a different source.
SELECT * FROM mos_categories WHERE section='42'; SELECT * FROM mos_content WHERE sectionid='42' AND state='1'; SELECT * FROM mos_menu WHERE menutype REGEXP '1.5' AND name REGEXP 'Help Screens'; SELECT * FROM mos_modules WHERE name='fakemenu'; SELECT * FROM mos_sections WHERE id='42';
Note: On help.joomla.org the 1.5 help screens menu is part of mainmenu so there is no simple SQL command to export just the help screens menu module. Instead, the "fakemenu" menu is exported. Install it on a Joomla! 1.0 instance, change the fields you need to change, then re-export it, so you get the right SQL command. Alternatively, just use the one already set up as it's really unlikely to change.