On 2/23/07, Arturo Perez <[EMAIL PROTECTED]> wrote:
I went directly into the roller database and deleted some users (did NOT want them hanging around as they were a mistake). Now I find that I get hibernate errors about missing rows. Now, my stupidity aside, how can I deal with this?
Oh my. You'll have to deal with this the same way you created the problem -- with SQL fun. I guess there are two ways. Either 1) recreate those users with the exact same ID numbers. Or, 2) update all of the tables that point to those users and make them point to other users -- i.e. those which you have not deleted.
Ideally, I'd like to save the existing blogs, save username & other user settings, drop the whole database and reload the blogs and users. How close can I come to that? Is there a documented procedure?
I'm not sure exactly what you are trying to do, but I guess, if you are using MySQL, you could use mysqldump to dump the database, then use the mysql client to restore it layer. See the MySQL documentation for details. - Dave
