Thanks Bad_Captain!
Those 2 Creates were not in my dump I made of my good server (did a --no-data dump). Made a full dump with --routines and grep'ed it out and see the function creates.
Sourced in the 2 Creates you posted and re-sourced the vgroups and all went well, all the VIEWS are now on the server. Will have to wait until I get home to test it out on the Test Server.
Hopefully I will post a final to this thread when I get home.
Thanks again to all the posters, I for one learn lots reading every thread.
Michael
|