0

I need to know, is there any option to skip particular column and take remaining table backup using mysqldump command.

If yes please let me know.

Cristian
  • 198,401
  • 62
  • 356
  • 264
Phanindra
  • 221
  • 1
  • 3
  • 10
  • http://stackoverflow.com/questions/1018669/mysqldump-table-without-dumping-the-primary-key – ArK Nov 22 '10 at 04:58
  • http://stackoverflow.com/questions/541322/dump-mysql-view-as-a-table-with-data – ArK Nov 22 '10 at 05:00

1 Answers1

0

I wanted to move a table from one host to another but only include some of the columns and replace others with dummy data (like password columns). So I made a shell script that makes it possible to run a SELECT query and get INSERT statements as result.

You find the script here: https://gist.github.com/1239299

Mattias Wadman
  • 11,172
  • 2
  • 42
  • 57