Link to home
Start Free TrialLog in
Avatar of EMB01
EMB01Flag for United States of America

asked on

DB Error: Constraint Violation (After Overwriting Files in Horde)

My host suggested I copy and the files that contained my old data from the old directory:
/old/var/lib/mysql/horde/mnemo_memos.MYD
/old/var/lib/mysql/horde/mnemo_memos.MYI
/old/var/lib/mysql/horde/mnemo_memos.frm

To the new files in the new directory:
/var/lib/mysql/horde/mnemo_memos.MYD
/var/lib/mysql/horde/mnemo_memos.MYI
/var/lib/mysql/horde/mnemo_memos.frm

I overwrite these without making a backup and now I need help.

When I overwrote mnemo_memos.MYD I could still add notes via Horde webmail. Then, I overwrote mnemo_memos.MYI and mnemo_memos.frm and I get the following error when I try to add a note in Horde:
There was an error saving the note: DB Error: constraint violation

Can someone please help me just to get this working again. It would be a plus if I could also get my old data saved, too. Thank you.
ASKER CERTIFIED SOLUTION
Avatar of Daniel McAllister
Daniel McAllister
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of EMB01

ASKER

Dude, you're the man! I didn't know I had to shut mysqld off first and the host must not have know either (or they just didn't care to say...). Thanks, man! Now, I've got all my old notes and can add new ones.