Re: dbimport problems
"Georg Schlykow" <[email protected]>
| Newsgroups | gmane.comp.lang.4gl.fourjs.user |
|---|---|
| Message-ID | <005401c59da1$9dce84e0$1d8f4e01@sdmd29> |
... you should look in the sql-file and destroy all 'constraint', which are normally generated automatically and have no other use, than to sick the dbimport... ----- Original Message ----- From: Scott Edwards To: 4js Sent: Wednesday, August 10, 2005 1:14 PM Subject: [fourjs-users] dbimport problems Hi everyone, I was trying to do a dbimport today and it will not work for some reason, now to give you a lowdown on what I have done we have a development database called maniac_dev now basically all the tables are totally out of date now to save time and effort all I did was do a export of the main database called maniac, and then changed the .exp and .sql files to match the dev database name. Now obviously I cant overwrite so I dropped the dev database and then ran the import with the following command dbimport -d rootdbsx maniac_dev now it starts running fine and does a lot of tables but then stops and leaves this as the last message on the screen. *** execute sqlobj 625 - Contraint name (n623_178) already exists. I am not sure why this is happening has anyone experienced similar, or anyone know what I need to do in order to get it to work? Many Thanks in Advance, Scott Edwards ------------------------------------------------------------------------------ This email and any attachments are confidential to the intended recipient and may also be privileged. If you are not the intended recipient please delete it from your system and notify John Reid & Sons Ltd on +44 1202 483333. You should not copy it or use it for any purpose nor disclose or distribute its contents to any other person.