Transporting Queries

[wbaker]

I'd like to deploy my database, queries, and forms with associated fields. I copy the MySql data files and the forms in a straightforward way. However, I can't find the rather complex queries I've built. My workaround is to edit the queries, turn off design view and cut/paste the SQL into a text document. Then, when I copy the data files and forms to the next computer, I cut/paste the queries one by one to rebuild the entire set. That's OK but if there's a more elegant or simple way to do this, I'd appreciate a pointer.

Thanks,
Wil

[JamesR]

Many kudos to Daniel Strome who posted this info on the gmane newsgroup:
____________________________________________________
In the file
....../user/registry/data/org/openoffice/Office/DataAccess/xcu

Queries look something like:

<node oor:name="Queries">
<node oor:name="query_save_notes_cat_to_file" oor:op="replace">
<prop oor:name="Command" oor:type="xs:string">
<value>select note_cat_id, description ....

And I guess an administrator could have added queries
to the comparable file in ..../share
so they would be available to other users.
Not sure.