Mysql XML table export command line

Question

Maybe I'm not seeing something here but WHY would this command line work perfectly fine and provide a result set when run on a LINUX command line but when executed from a WINDOWS command line it fails dismally and returns nothing?

mysql -hHOSTNAME -uroot -p --xml -e 'SELECT * FROM db.table' > c:\temp\output.xml

What am I missing here?

dbenham · Accepted Answer · 2012-10-29 13:34:58Z

2

Windows command line does not recognize ' as a quote character, so your statement parameter becomes SELECT (truncated at the 1st space).

You must use " instead, as Heena Hussain suggested.

answered Oct 29, 2012 at 13:34

dbenham

132k29 gold badges273 silver badges410 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Brendan Over a year ago

Damn it! Thats the one, the double quote fixed it. Didnt even think that was the issue or to try double quotes. I suppose this is one of those issues of working by yourself, the lack of the extra eyes

dbenham · Accepted Answer · 2012-10-29 13:28:27Z

2

Can you please try this...

C:\>mysql -u <userid> -p<password> -e "SHOW VARIABLES LIKE '%version%'" –-xml

and this...

mysql -u db_user -p db_name --xml -e "SELECT * FROM table_name" > table_name.xml

edited Oct 29, 2012 at 13:28

dbenham

132k29 gold badges273 silver badges410 bronze badges

answered Oct 29, 2012 at 7:05

Heena Hussain

3,7011 gold badge22 silver badges21 bronze badges

Collectives™ on Stack Overflow

Mysql XML table export command line

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related