[Vtigercrm-developers] importing backup form botched upgrade

[Gregory Machin]

Hi
I had an inst of 5.0.3 that I upgraded and little thing all over seem 
broken like the tax isn't apearing on the invoices etc, so I tries to 
back up the date and restore it to and clean empty 5.0.4  install  but  
I keep running into missing columns and  table  and  other odds and 
ends  .. any  Ideas  how to get backup / export the data form and import 
it into 5.0.4

these are the errors i'm getting and doing manual fixes to try and get 
it to work .
[root at greg-lpt ~]# mysql coltech_vtigercrm < /tmp/backup
backup/                      backup_20080715_143518.sql   
backup_20080715_143518.sql~ 
[root at greg-lpt ~]# mysql coltech_vtigercrm < /tmp/backup
backup/                      backup_20080715_143518.sql   
backup_20080715_143518.sql~ 
[root at greg-lpt ~]# mysql coltech_vtigercrm < /tmp/backup_20080715_143518.sql
ERROR 1136 (21S01) at line 470: Column count doesn't match value count 
at row 1
[root at greg-lpt ~]# mysql coltech_vtigercrm < /tmp/backup_20080715_143518.sql
ERROR 1146 (42S02) at line 940: Table 
'coltech_vtigercrm.vtiger_customfield_sequence_seq' doesn't exist
[root at greg-lpt ~]# mysql coltech_vtigercrm < /tmp/backup_20080715_143518.sql
ERROR 1062 (23000) at line 8: Duplicate entry '2' for key 1
[root at greg-lpt ~]# mysql coltech_vtigercrm < /tmp/backup_20080715_143518.sql
ERROR 1146 (42S02) at line 2749: Table 
'coltech_vtigercrm.vtiger_mail_accounts_seq' doesn't exist
[root at greg-lpt ~]# mysql coltech_vtigercrm < /tmp/backup_20080715_143518.sql
ERROR 1146 (42S02) at line 3038: Table 
'coltech_vtigercrm.vtiger_portal_seq' doesn't exist
[root at greg-lpt ~]# mysql coltech_vtigercrm < /tmp/backup_20080715_143518.sql
ERROR 1146 (42S02) at line 8028: Table 
'coltech_vtigercrm.vtiger_systems_seq' doesn't exist
[root at greg-lpt ~]# mysql coltech_vtigercrm < /tmp/backup_20080715_143518.sql
ERROR 1136 (21S01) at line 8429: Column count doesn't match value count 
at row 1
[root at greg-lpt ~]# mysql coltech_vtigercrm < /tmp/backup_20080715_143518.sql
ERROR 1146 (42S02) at line 8406: Table 
'coltech_vtigercrm.vtiger_timecardtypes' doesn't exist
[root at greg-lpt ~]# mysql coltech_vtigercrm < /tmp/backup_20080715_143518.sql

ERROR 1136 (21S01) at line 8625: Column count doesn't match value count 
at row 1
[root at greg-lpt ~]#
[root at greg-lpt ~]# mysql coltech_vtigercrm < /tmp/backup_20080715_143518.sql
ERROR 1136 (21S01) at line 8625: Column count doesn't match value count 
at row 1

-- 
Gregory Machin
CT-Net 
www.ct-net.org
greg at ct-net.org
phone : +27 12 379 3497
fax   : +27 12 379 4113
Cell  : +27 72 524 8096

humans do not use the address 
below its for trapping spam. 
spamtrap  imasucker at ct-net.org