llmavll Posted October 30, 2008 Posted October 30, 2008 I have accidently upgraded my data base and I now have duplicate entries in numerous databases. ie here is what My Store looks like: (some have 4 entries. My Store Title Value Store Name E-Mail Address E-Mail From Store Owner Info Country Canada Info Zone Ontario Info Zone Florida Info Zone Florida Info Zone Florida Info Expected Sort Order desc Info Expected Sort Field date_expected Info Switch To Default Language Currency false Info Switch To Default Currency false Info Switch To Default Currency false Info Switch To Default Currency false Info Send Extra Order Emails To Info Send Extra Order E-Mails To Info Send Extra Order E-Mails To Info Send Extra Order E-Mails To Info Use Search-Engine Safe URLs (still in development) false Info Use Search-Engine Safe URLs false Info Use Search-Engine Safe URLs false Info Use Search-Engine Safe URLs false Info Display Cart After Adding Product false Info Display Cart After Adding Product true Info Display Cart After Adding Product true Info Display Cart After Adding Product true Info Allow Guest To Tell A Friend false Info Allow Guest To Tell A Friend false Info Allow Guest To Tell A Friend false Info Allow Guest To Tell A Friend false Info Default Search Operator and Info Default Search Operator and Info Default Search Operator and Info Default Search Operator and Info Store Address and Phone Store Name Address Country Phone Info Store Address and Phone Info Store Address and Phone Info Store Address and Phone Info Show Category Counts true Info Show Category Counts true Info Show Category Counts true Info Show Category Counts true Info Tax Decimal Places 0 Info Tax Decimal Places 2 Info Tax Decimal Places 2 Info Tax Decimal Places 2 Info Display Prices with Tax false Info Display Prices with Tax false Info Display Prices with Tax false Info Display Prices with Tax false Info Now my question is how do I get rid of these entries without dropping my entire db and starting over? (Don't want to lose my data) Any help would be great. Cheers Kris
♥yesudo Posted October 31, 2008 Posted October 31, 2008 Export the 'configuration' table, from the database, into a file - open the file - delete the duplicates - save the file - Import the file back into the database. Your online success is Paramount.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.