best practice for migrating wiki pages, tags, and media between repositories?

[Michael Beller]

I'm developing locally and using Git to manage and push updates to my server (pythonganywhere) via github.

I've excluded databases in gitignore but need to migrate the wiki tables.

I think I could add !databases/*wiki* to the gitignore for the sqlite tables but I'm thinking ahead when I plan to shift to mysql for this app.

Do you create an export and import process for the data?

I also read that I'll need to "regenerate" the wiki html and perhaps can add this to the import script.

[Michael Beller]

Still climbing my initial learning curve, the databases/*wiki* files are the web2py table definition files I believe.  I will need to export the wiki data as part of the migration process.

One option I'm evaluating is to export the wiki data in CSV format.  I've exposed the wiki tables to appadmin so I can easily manage and export the data.  However, import attempts to insert the data rather than update existing data.  Therefore, I could create an empty table for the import and then a migration function to either update or insert the data into the wiki table.

Any advice?