darcisz Posted June 3, 2011 Share Posted June 3, 2011 database restoreI installed fresh presta 1.4and have backup made few days ago for version 1.4how restore database ? any tool to easy do it ?Server support try do it but they did something wrongget errors:Here are the errors from that import:ERROR 1050 (42S01) at line 8: Table 'ps_access' already existsERROR 1062 (23000) at line 18: Duplicate entry '1-1' for key 1ERROR 1050 (42S01) at line 86: Table 'ps_accessory' already existsERROR 1050 (42S01) at line 93: Table 'ps_address' already existsERROR 1136 (21S01) at line 123: Column count doesn't match value count at row 1ERROR 1050 (42S01) at line 237: Table 'ps_alias' already existsERROR 1050 (42S01) at line 247: Table 'ps_attachment' already existsERROR 1050 (42S01) at line 255: Table 'ps_attachment_lang' already existsERROR 1050 (42S01) at line 264: Table 'ps_attribute' already existsERROR 1050 (42S01) at line 273: Table 'ps_attribute_group' already existsERROR 1050 (42S01) at line 280: Table 'ps_attribute_group_lang' already existsERROR 1050 (42S01) at line 289: Table 'ps_attribute_impact' already existsERROR 1050 (42S01) at line 300: Table 'ps_attribute_lang' already existsERROR 1050 (42S01) at line 309: Table 'ps_block_cms' already existsERROR 1062 (23000) at line 315: Duplicate entry '12-1' for key 1ERROR 1050 (42S01) at line 326: Table 'ps_blocklink' already existsERROR 1050 (42S01) at line 334: Table 'ps_blocklink_lang' already existsERROR 1050 (42S01) at line 342: Table 'ps_carrier' already existsERROR 1136 (21S01) at line 357: Column count doesn't match value count at row 1ERROR 1050 (42S01) at line 393: Table 'ps_carrier_group' already existsERROR 1062 (23000) at line 399: Duplicate entry '2-1' for key 1ERROR 1050 (42S01) at line 404: Table 'ps_carrier_lang' already existsERROR 1062 (23000) at line 411: Duplicate entry '1-1' for key 1ERROR 1050 (42S01) at line 509: Table 'ps_carrier_zone' already existsERROR 1062 (23000) at line 515: Duplicate entry '1-1' for key 1ERROR 1050 (42S01) at line 676: Table 'ps_cart' already existsERROR 1136 (21S01) at line 700: Column count doesn't match value count at row 1etc etcwhat is wrong ? please help me Link to comment Share on other sites More sharing options...
shokinro Posted June 3, 2011 Share Posted June 3, 2011 you need to drop related tables first before run your restore script. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now