title: Mysqldump: create column names for inserts when backing up
body: <p>How do I instruct mysqldump to backup with column names in insert statements?<br>
  In my case I didn’t a normal back up with insert sql’s resulting in  </p>
  
  <pre><code>LOCK TABLES `users` WRITE;
  /*!40000 ALTER TABLE `users` 
  INSERT INTO `users` VALUES (1
  </code></pre>
  
  <p>structure.  </p>
  
  <p>Now I went ahead and <strong>removed a column</strong> from the schema in users. After this when I run the backup sql’s I get a <strong>column number mismatch error</strong>.  </p>
  
  <p>To fix this how do I go about instructing mysqldump to write column names too? 
  Here is how I do it now</p>
  
  <pre><code>mysqldump --host=${dbserver} --user=${dbusername} --password=${dbpassword} \
            --no-create-db --no-create-info --extended-insert --single-transaction \
            --compress tablename  
  </code></pre>
  
  <p>On a broader level, what’s the best practice to manage these schema changes? </p>