I have a 750 MB vb 3.8 .SQL file. Its 91 MB gzipped. I don't know what method was used for backup.
On restoration (via SSH), its throwing a Duplicate Entry error. Only 30-40 tables of 180 MB import well.
Code:
ERROR 1062 (23000) at line 1187158: Duplicate entry '717215' for key 1
Is there a way of rectifying this problem? I cannot take backup again so I guess I will have to manually rectify this problem in the .SQL file. What should I look for?
__DEFINE_LIKE_SHARE__