The userpref hosts column in the MySQL database most likely says localhost for each user preference. Now that the MySQL DB and the webmail are on different machines, it should be the address (or name?) of the webmail server instead. Simply login to webmail and change some prefs or address book, look at the database to see what it put in for the host column (now that they are on different machines), then delete all the records that have the new host info (to revert back to before the move), then run an update query to change the hosts column from localhost to whatever it puts in there now (either IP address of webmail server or name of webmail server).. Good Luck! David > -----Original Message----- > From: v-webmail-bounce@xxxxxxxxxxxxx > [mailto:v-webmail-bounce@xxxxxxxxxxxxx]On Behalf Of Marius Herea / MCD > Sent: Friday, November 07, 2003 10:42 AM > To: v-webmail@xxxxxxxxxxxxx > Subject: [v-webmail] external mysql > > > Hi, > > I have moved my mysql on another machine and suddenly, all user lost their > preferences. > Their mail rules, external account .. etc.. > > And another thing.. they got subscribed to send-mail, deleted-mail, drafts > > Where did I did wrong? > > Marius > > -- > V-webmail Support Mailing List (http://www.v-webmail.org) > Archives: //www.freelists.org/archives/v-webmail/ > To unsubscribe, send mail to: v-webmail-request@xxxxxxxxxxxxx > with "unsubscribe" in the subject > > -- V-webmail Support Mailing List (http://www.v-webmail.org) Archives: //www.freelists.org/archives/v-webmail/ To unsubscribe, send mail to: v-webmail-request@xxxxxxxxxxxxx with "unsubscribe" in the subject