Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- pi@raspberrypi ~ $ cat getsingleSQLline.sh
- #!/bin/bash
- my_host="localhost";my_port="3306";my_user="tester";my_pwd="tester";
- my_db="tester";my_tbl="users";my_fld="username";
- my_stat="select $my_fld from $my_tbl\G;";
- my_slist="/tmp/userlist";
- my_dlist="/tmp/db_userlist";
- # do no change unless you know what you do
- mysql -ss -N -h $my_host -P $my_port -u $my_user -p$my_pwd -D $my_db -e "$my_stat" > /tmp/GETSQLUSERS.TXT
- cat /tmp/GETSQLUSERS.TXT | grep -v row | sort > $my_dlist
- rm /tmp/GETSQLUSERS.TXT
- diff -u $my_slist $my_dlist > /tmp/userlist.patch
- if [ -s "/tmp/userlist.patch" ]
- then
- echo "Userlist needs patching"
- #patch $my_slist < /tmp/userlist.patch
- else
- echo "Userlist is up2date"
- fi
- rm /tmp/userlist.patch
- exit 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement