import and export mysql table to xml file in windows command? [duplicate]

Question

am using Mysql server version "MySQL Server 8.0". please help me, how to export and import mysql table to xml file, in windows command prompt.

thanks.

Rajkumar · Accepted Answer · 2019-03-20 06:50:40Z

0

Export $ mysql -uroot -p --xml -e 'SELECT * FROM rajdb.Tablename' > /tmp/raj.xml

Import mysql> LOAD XML /tmp/raj.xml INTO TABLE Tablename;

answered Mar 20, 2019 at 6:50

Rajkumar

1,0679 silver badges12 bronze badges

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

1 Answer 1