Backup and restore

[David A. B. <da...@pa...>]

Hey folks,

Got a question about the backup and restore.

I have one system I've upgraded from like version 1.2 all the way to
current (1.8.2).  Previously I did backups (OK, still do) from a command
line and they worked fine.  Thought I'd give Dieter's backup a try.

So I installed another box, set up the database (empty), and tried to
restore from the backup file (after all, that's what I'd do if the hard
drive crashed).

However, some tables are giving me fits.  Here are the error messages from
the restore (I used a command line \i <filename.db> to restore):
psql:pananix.db:347: ERROR:  copy: line 1, Bad date external
representation '10071' psql:pananix.db:347: PQendcopy: resetting
connection and:
psql:pananix.db:671: ERROR:  copy: line 1, Bad float8 input format
'06-02-2002' psql:pananix.db:671: PQendcopy: resetting connection

I suspect for some reason the columns are being input in the wrong order. 
The specific tables are: DELETE FROM ar;
COPY ar FROM stdin;
10091   1001    21-11-2000      10071   0       502.5   500     502.5  
07-12-2000      20-12-2000      1       FOB David       30      \N      \N
     \N

and:
DELETE FROM parts;
COPY parts FROM stdin;
10264   LS-Desktop      Complete Linux System Installed & Configured    ea
     550     795     \N      06-02-2002      3.5     -1      \N      0    
  0       0       0       10058   10063   10046   \N      0

When I created the original database, it only had the default table, so
that's what I set up via the admin screen with 1.8.2 (Default dataset). I
figured it'd be closest to the original from 1.2 (with all the updates). 

Thoughts, ideas, ???

Thanx,

David A. Bandel
-- 
Focus on the dream, not the competition.
		-- Nemesis Racing Team motto
Internet (H323) phone: 206.28.187.30