cidb: drop comments from schema.dump
BUG=None
TEST=None
Change-Id: Ib72cf4d89fa9754be5a5d53a5b4772dc21e7afe9
Reviewed-on: https://chromium-review.googlesource.com/219557
Tested-by: Aviv Keshet <akeshet@chromium.org>
Reviewed-by: David James <davidjames@chromium.org>
diff --git a/cidb/schema.dump b/cidb/schema.dump
index d9ff903..2586145 100644
--- a/cidb/schema.dump
+++ b/cidb/schema.dump
@@ -1,8 +1,3 @@
--- MySQL dump 10.13 Distrib 5.5.38, for debian-linux-gnu (x86_64)
---
--- Host: 173.194.253.2 Database: cidb
--- ------------------------------------------------------
--- Server version 5.5.38-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -15,9 +10,6 @@
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
---
--- Table structure for table `boardPerBuildTable`
---
DROP TABLE IF EXISTS `boardPerBuildTable`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
@@ -33,9 +25,6 @@
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
---
--- Table structure for table `buildStageTable`
---
DROP TABLE IF EXISTS `buildStageTable`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
@@ -55,9 +44,6 @@
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
---
--- Table structure for table `buildTable`
---
DROP TABLE IF EXISTS `buildTable`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
@@ -94,9 +80,6 @@
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
---
--- Table structure for table `childConfigPerBuildTable`
---
DROP TABLE IF EXISTS `childConfigPerBuildTable`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
@@ -110,9 +93,6 @@
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
---
--- Table structure for table `clActionTable`
---
DROP TABLE IF EXISTS `clActionTable`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
@@ -134,9 +114,6 @@
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
---
--- Table structure for table `schemaVersionTable`
---
DROP TABLE IF EXISTS `schemaVersionTable`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
@@ -158,4 +135,3 @@
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2014-09-23 14:39:52
diff --git a/cidb/schema.dump.readme b/cidb/schema.dump.readme
index 381db6c..c4cce4b 100644
--- a/cidb/schema.dump.readme
+++ b/cidb/schema.dump.readme
@@ -8,4 +8,5 @@
mysqldump -u `cat user.txt` -h `cat host.txt` --password=`cat password.txt` \
--ssl-ca=server-ca.pem --ssl-cert=client-cert.pem --ssl-key=client-key.pem \
- --no-data --single-transaction cidb > ~/chromiumos/chromite/cidb/schema.dump
+ --no-data --single-transaction cidb | grep -v '^--' \
+ > ~/chromiumos/chromite/cidb/schema.dump