Knowledge Walls
John Peter
Pune, Maharashtra, India
Dump in mysql with ignore only few table data
2028 Views
First taking all structure of tables.
mysqldump -u root -pmysql db_name --no-data > dumping.sql

Second to take all data's except few table's data.
mysqldump -u root -pmysql db_name --no-create-info --ignore-table=table_1 --ignore_table=table_2 >> dumping.sql

Best Lessons of "MySQL"
Top lessons which are viewed more times.
  Copyright © 2014 Knowledge walls, All rights reserved
KnowledgeWalls
keep your tutorials and learnings with KnowledgeWalls. Don't lose your learnings hereafter. Save and revise it whenever required.
Click here for more details