Exporting data to share with client

wmcelwee

If I have a CMS with news articles posted to it and a client of mine decides to part ways and wants their content (articles, photos), what is the best way to give them their data that is usable by them (not necessarily the easiest way for them but something that is usable) and protects our database structure?

It is a concern to want protect the structure of our database? Is it ok to just export an XML file out of PHPmyAdmin which uses the table/field names for the tags? If not, should I create a function that will create a custom XML file with just the fields I want and rename them? What would be an acceptable method to do this?

Saviola

Exist lots of ways to do this.
I think you don't have to export XMl file directly from PHPmyAdmin. Just, that isn't the best way to do this.
You can write/create some script to export and import these data in diferent file formats (XML, CSV) and structures. PHP provides a rich set of tools to do this.
So you can chose which fields from database to give to your customers. So you can choose what data and what field names to be give to your customers. It will also keep secret information on the organization of your database.

edited by admin: commercial links and advertising copy not permitted on the forum.