tested all above commands and got error messages on all.
below was the last, I replaced some of the reply path and table data with xxxxxxxxx
Control panel message
Script: /home/xxxxxx/xxxx/x/x/xxxxxxxx/html/forums/admin/dodbcommand.php
Line#: 101
SQL Error: Table 'xxxxxxxxxxxxx.ubbt_USER_PROFILE' doesn't exist
SQL Error #: 1146
Query: update ubbt_USER_PROFILE set USER_TOTAL_PM ='0'
Any comment on what I did wrong???