[thelist] generating XML from MySQL tables

[Garrett Coakley]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Mon, 11 Nov 2002 12:58:34 -0300 Diego Barcia wrote:

> does anyone know how to generate XML automatically from a MySQL table,
> or tables, or database, under Win98, or if is that possible?

[snip]

> mysqldump --xml databasename [tables]

[snip]

> to do that, but I get a syntax error from MySql (ERROR 1064)... Also,
> I don't understand the syntax [tables] in that command. I guess if you
> have a db called 'db' and a table called 'sales' you should write:
> mysqldump --xml db [sales]? Or [tables] is optional?


You're close.

The general rule when looking at command line tools is that anything in
[]'s is an optional parameter (well, thats the way it is for a lot of
the GNU stuff). So if you wanted to dump out an xml feed of the 'user'
table from the 'mysql' database you would do:

mysql --xml -u <username> -p mysql user

Here that returns:

<?xml version="1.0"?>
        <user>
                <Host>localhost<Host>
                <User>martin<User>
                <Password>nottellinya<Password>
                <Select_priv>N<Select_priv>
                <Insert_priv>N<Insert_priv>
                <Update_priv>N<Update_priv>
                <Delete_priv>N<Delete_priv>
                <Create_priv>N<Create_priv>
                <Drop_priv>N<Drop_priv>
[snip]

HTH

G.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.0 (GNU/Linux)

iD8DBQE9z+bl4AAXt40rqS4RAq5ZAJkB0h7Szz4Nhysi91l/cJZW1LY32gCfTb89
lVU6eTDXczi4Q0NNfiFU5Tg=
=Ormb
-----END PGP SIGNATURE-----