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
On Feb 16, 2012, at 6:18 PM, ManicD wrote: root@server2:/usr# mysqlcheck baruwa -u xxxxx -p Enter password: baruwa.archive OK baruwa.auth_group OK baruwa.auth_group_permissions OK baruwa.auth_hosts OK baruwa.auth_message OK baruwa.auth_permission OK baruwa.auth_user OK baruwa.auth_user_groups OK baruwa.auth_user_user_permissions OK baruwa.django_content_type OK baruwa.django_session OK baruwa.lists OK baruwa.mail_hosts OK baruwa.message_recipients OK baruwa.messages OK baruwa.profiles OK baruwa.quarantine_releases OK baruwa.report_filters OK baruwa.sa_rules OK baruwa.scanner_config OK baruwa.scanner_config_sections OK baruwa.scanners OK baruwa.user_addresses OK i then run a mysqlcheck baruwa baruwa.messages -o -u xxxxx -p to optimise that table anything else i'm missing...if you know the actual commands it would be great!!! Just had great fun figuring out what the hell those commands were, lol -- View this message in context: http://baruwa-users-list.963389.n3.nabble.com/Baruwa-VERY-slow-tp3746553p3752364.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
