Lo all, If I have a database with various tables, and I want to upgrade the tables and the data in the tables, will it screw up the permissions assigned to users if I use DROP TABLE / CREATE TABLE (to recreate the changed tables), and then just populate them with the data again?
I'm doing it this way because it's easier for us to dump the data from our development databases and reload them onto our production systems, but I'm worring now that I am going to loose my permissions (there is a TON of users / permissions in place)... Any feedback appreciated. -- me <sql,query> --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
