The mysql command-line client has several different output options. One of these is XML.
Import the ISFDB database as described in the Importing the data exported by mysqldump recipe in this chapter. Create a file called isfdb-001.sql using the following command line:
SELECT * FROM authors LIMIT 100;
We could put whatever commands we want in this file, or give it a different name, but this works for the purposes of this recipe. This file has the same name and contents as the file used in the previous recipe. If we've already completed that recipe, we can just reuse the same file.
Open a terminal and navigate to where we saved the
isfdb-001.sqlfile.Issue the following command on the command line (not from within the
mysqlcommand-line client, but by calling the client with some special options):mysql --xml isfdb < isfdb-001.sql > isfdb-001.xmlExecute either a
dirorlscommand and we'll see that there is now a file namedisfdb-001.xml...