I have an app that wants read-only access to a fairly small MySQL database held on a remote server. For speed, I want to hold a copy of the database locally. (It only gets updated once a week or so.)
What I'm currently doing is I've got a PHP script on the remote machine that dumps out the database in XML format. My app then reads this in, parses it, and populates the local database accordingly. This is horribly slow, even using a streamlined XML parser of my own rather than the achingly slow built-in one. Given that they both use SQL, there's got to be a better way of doing this. Could I, for example, simply get the remote server to do an SQL dump and throw this at SQLite without horribly compromising security? Are there any streamlined (i.e. fast) replication data formats I could use? Has anyone done anything like this who can suggest anything? -- ┌─── ｄｇ＠ｃｏｗｌａｒｋ．ｃｏｍ ───── http://www.cowlark.com ───── │ │ "All power corrupts, but we need electricity." --- Diana Wynne Jones, │ _Archer's Goon_
signature.asc
Description: OpenPGP digital signature
