Hello.
On Fri 2002-12-06 at 21:53:40 +0200, [EMAIL PROTECTED] wrote:
> 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?
No, DROP/CREATE TABLE will leave the privileges alone.
> 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)...
This is perfectly fine to do so.
HTH,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
