Dump MySQL Table Information

This command will dump a table into a file without the data.

mysqldump --opt --user=[username] --password=[password] --no-data [database] [table] > [filename]
.
.

Dump the data in an XML format

mysqldump --opt --user=[username] --password=[password] --no-data --xml [database] [table] > [filename]
.
.

Your rating: None Average: 5 (2 votes)