bash - MySQL foreign_key_checks not staying disabled -


i have script (courtesy https://bash.cyberciti.biz):

#!/bin/bash muser="$1" mpass="$2" mdb="$3"  # detect paths mysql=$(which mysql) awk=$(which awk) grep=$(which grep)  if [ $# -ne 3 ]     echo "usage: $0 {mysql-user-name} {mysql-user-password} {mysql-database-name}"     echo "drops tables mysql"     exit 1 fi  tables=$($mysql -u $muser -p$mpass $mdb -e 'show tables' | $awk '{ print $1}' | $grep -v '^tables' )  t in $tables     $mysql -u $muser -p$mpass $mdb -e "set foreign_key_checks=0" ##aded myself in order disable foreign key checks"     echo "deleting $t table $mdb database..."     $mysql -u $muser -p$mpass $mdb -e "drop table $t" done

i have 2 issues it:

  1. when running via curl remote machine fails errors like: 

    xxx@xxx [~]# bash <(curl -s xxxxxxx.com/s/dbtruncate.sh) db_user db_pass db_name bash: /dev/fd/63: no such file or direct

    when runnig via cli directly, works fine: 

    xxx@xx [~/publichtml/s]# ./dbtruncate.sh db_user db_pass db_name warning: using password on command line interface can insecure. deleting batch table florinba_drp database... warning: using password on command line interface can insecure. deleting block_content table florinba_drp database... warning: using password on command line interface can insecure. deleting block_content_body table florinba_drp database... warning: using password on command line interface can insecure. deleting block_content_field_data table florinba_drp database... warning: using password on command line interface can insecure. deleting block_content_field_revision table florinba_drp database...

  2. second issue despite having foreign key checks turned off every time, prior of deleting table in loop, still shows errors can due constraint:

    error 1217 (23000) @ line 1: cannot delete or update parent row: foreign key constraint fails error 1217 (23000) @ line 1: cannot delete or update parent row: foreign key constraint fails error 1217 (23000) @ line 1: cannot delete or update parent row: foreign key constraint fails


Comments

Post a Comment

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

i've set bento/ubuntu-16.04 vagrant box using php 5.6, , getting following error quite few times when try , run shell script: "uncaught reflection exception: class domdocument not exist". i've tried adding following top of script (not together), each no success: "sudo apt-get install php5.6-xml", "sudo apt-get install php5-xml", "sudo apt-get install php-dom" i've tried resetting server "sudo service apache2 restart". does have suggestions?
Read more

vue.js - Create hooks for automated testing -

Image
qa guys complained can't automate frontend testing. because our html looks same outside. lazy hack did this <template> <div :role="$options.name"> ... </div> </template> <script> export default { name: 'vmcomponentname' } </script> which takes name script , applies html. in browser get: <div role="vmcomponentname"> ... </div> line :role="$options.name" goes in every component. is there dry er solutions? please share. additional details i'll explain in details looking for. imagine have vmusercreate form creates user. test case can create user . to automatically test without role, have use following selector: .wrapper > .wrapper > .wrapper > .submit-button the test extremely brittle (will break lot). if use roles can use [role="vmusercreateform"] .submit-button selector. many folds less brittle. so basically, i'm ...
Read more

Add new key value to json node in java -

i have json file : { "id":1, "name":"abc", "addressdetails": { "city":"newyork" } } i wanted add 1 more key-value ("pincode" : "414141") node 'addressdetails'. i tried using : objectmapper mapper = new objectmapper(); jsonnode root = mapper.readtree(new file("d://test.json")); objectnode node = mapper.createobjectnode(); node.with("addressdetails").put("pincode", "414141"); but it's not getting added, there way can ? you can try you should modify file path objectmapper mapper = new objectmapper(); objectnode nodes = mapper.readvalue(new file("d:\\test.txt"), objectnode.class); nodes.with("addressdetails").put("pincode", "414141"); mapper.writer().writevalue(new file("d:\\test.txt"), nodes);
Read more