Re: [hibernate-dev] in.relation.to error when posting a new blog entry

Good questions. I'll wait for a reply... ----- Original Message ----- > From: "Hardy Ferentschik" <hardy(a)hibernate.org&gt; > To: "Sanne Grinovero" <sanne(a)hibernate.org&gt; > Cc: "Gail Badner" <gbadner(a)redhat.com&gt;, "Davide D'Alto" < davide(a)hibernate.org&gt;, "hibernate-dev" > <hibernate-dev(a)lists.jboss.org&gt; > Sent: Friday, February 13, 2015 1:53:21 AM > Subject: Re: [hibernate-dev] in.relation.to error when posting a new blog entry > > On Thu, Feb 12, 2015 at 06:57:55AM +0000, Sanne Grinovero wrote: > > I suspect it's a broken foreign key on MySQL, hopefully the error message > > will have some details? Some table maintenance should do the trick. > > Do you literally talk about the table maintenance commands like > REPAIR TABLE > (http://dev.mysql.com/doc/refman/5.1/en/table-maintenance-sql.html), > or do you have something else in mind? > > Is it not a bit dangerous to let the uninitiated work against the prod > database? > Is there at least a nightly or at least regular copy of the database which > can be > restored in case something goes wrong? And if so where is it and how do I get > hold > of it? > > --Hardy >