You can try, but more than likely their are more than 1 duplicate entry. Install phpmyadmin and try that. you can use that to export the db and back it up offsite as well.
-- Jeremy McSpadden Flux Labs, Inc http://www.fluxlabs.net Endless Solutions Office : 850-588-4626 Cell : 850-890-2543 Fax : 850-254-2955 On Feb 16, 2012, at 6:30 PM, ManicD wrote: Jeremy McSpadden wrote Good .. i don't like holding hands :) If your still getting duplicate keys, you'll need to export table, drop the table. recreate, and re-import. should repack keys on the import .. then try running dbclean again. ... service <MTA> stop; service baruwa stop mysqldump -uUSER -pPASSWORD DBNAME > /tmp/backup.sql drop database DBNAME; create database DBNAME; mysql -uUSER -pPASSWORD DBNAME < /tmp/backup.sql -- Jeremy McSpadden Flux Labs, Inc http://www.fluxlabs.net<http://www.fluxlabs.net/> Endless Solutions Office : 850-588-4626 Cell : 850-890-2543 Fax : 850-254-2955 You scare me!!! - I think some googleing is going to be in order before i run ahead and do that, lol If i enter the table itself find teh duplicate entry and delete both lines....would that sort it??? ....somehow dropping teh whole table is not a nice thought when i currently dont have a backup to this server (yes i'm sorting that out, been trying to figure out how to install it etc) -- View this message in context: http://baruwa-users-list.963389.n3.nabble.com/Baruwa-VERY-slow-tp3746553p3752376.html Sent from the Baruwa users list mailing list archive at Nabble.com<http://Nabble.com>. _______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056
_______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056
