a05f20222fff4594fa2f427eca7bb48521ee8eb9
jcasper
  Fri Feb 21 10:04:28 2025 -0800
Removing mariadb sandbox mode lines from hgcentral dumps, no ticket

diff --git src/utils/qa/weeklybld/buildHgCentralSql.csh src/utils/qa/weeklybld/buildHgCentralSql.csh
index 2574246c933..3d0dedb861c 100755
--- src/utils/qa/weeklybld/buildHgCentralSql.csh
+++ src/utils/qa/weeklybld/buildHgCentralSql.csh
@@ -47,34 +47,36 @@
 set CREATE_AND_FILL="defaultDb clade genomeClade targetDb hubPublic" 
 set CREATE_OR_LIST=`echo "${CREATE_AND_FILL}" | sed -e "s/ /|/g"`
 set IGNORE_TABLES=`hgsql -N -h genome-centdb -e "show tables;" hgcentral \
      | egrep -v -w "${CREATE_OR_LIST}" | xargs echo \
      | sed -e "s/^/--ignore-table=hgcentral./; s/ / --ignore-table=hgcentral./g"`
 # --order-by-primary ... to make it dump rows in a stable repeatable order if it has an index
 # --skip-extended-insert ... to make it dump rows as separate insert statements
 # --skip-add-drop-table ... to avoid dropping existing tables
 # Note that INSERT is turned into REPLACE making our table contents dominant, 
 #      but users additional rows are preserved
 hgsqldump ${IGNORE_TABLES} --skip-lock-tables --skip-add-drop-table --skip-extended-insert --order-by-primary -c -h genome-centdb \
         --no-create-db --databases hgcentral  | grep -v "^USE " | sed -e \
         "s/genome-centdb/localhost/; s/CREATE TABLE/CREATE TABLE IF NOT EXISTS/; s/INSERT/REPLACE/" \
     >> /tmp/hgcentraltemp.sql
 
-# get rid of some mysql5 trash in the output we don't want.
+# get rid of some mysql5 trash in the output we don't want, as well as
+# the mariadbdump "sandbox mode" lines.
 # also need to break data values at rows so the diff and cvs 
 # which are line-oriented work better.
 grep -v "Dump completed on" /tmp/hgcentraltemp.sql | \
+grep -v '999999.*enable the sandbox mode' | \
 sed -e "s/AUTO_INCREMENT=[0-9]* //" > \
 /tmp/hgcentral.sql
 
 echo
 echo "*** Diffing old new ***"
 diff hgcentral.sql /tmp/hgcentral.sql
 if ( ! $status ) then
 	echo
 	echo "No differences."
 	echo
 	exit 0
 endif 
 
 if ( "$1" != "real" ) then
 	echo