you were right, i found many so decided to go with your option however when i ran the import command it fails.....
root@server2:/usr# mysqldump -u baruwa -p baruwa messages < /usr/baruwamessages.sql Enter password: -- MySQL dump 10.13 Distrib 5.1.41, for debian-linux-gnu (x86_64) -- -- Host: localhost Database: baruwa -- ------------------------------------------------------ -- Server version 5.1.41-3ubuntu12.10 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `messages` -- DROP TABLE IF EXISTS `messages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `messages` ( `id` varchar(255) NOT NULL, `actions` varchar(255) NOT NULL, `clientip` char(15) NOT NULL, `date` date NOT NULL, `from_address` varchar(255) NOT NULL, `from_domain` varchar(255) NOT NULL, `headers` longtext NOT NULL, `hostname` longtext NOT NULL, `highspam` int(11) NOT NULL, `rblspam` int(11) NOT NULL, `saspam` int(11) NOT NULL, `spam` int(11) NOT NULL, `nameinfected` int(11) NOT NULL, `otherinfected` int(11) NOT NULL, `isquarantined` int(11) NOT NULL, `sascore` double NOT NULL, `scaned` int(11) NOT NULL, `size` int(11) NOT NULL, `blacklisted` int(11) NOT NULL, `spamreport` longtext NOT NULL, `whitelisted` int(11) NOT NULL, `subject` longtext NOT NULL, `time` time NOT NULL, `timestamp` datetime NOT NULL, `to_address` varchar(255) NOT NULL, `to_domain` varchar(255) NOT NULL, `virusinfected` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `messages_from_address` (`from_address`), KEY `messages_from_domain` (`from_domain`), KEY `messages_highspam` (`highspam`), KEY `messages_spam` (`spam`), KEY `messages_isquarantined` (`isquarantined`), KEY `messages_blacklisted` (`blacklisted`), KEY `messages_whitelisted` (`whitelisted`), KEY `messages_to_address` (`to_address`), KEY `messages_to_domain` (`to_domain`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `messages` -- LOCK TABLES `messages` WRITE; /*!40000 ALTER TABLE `messages` DISABLE KEYS */; /*!40000 ALTER TABLE `messages` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2012-02-17 1:18:49 I have created teh table back by running the create table part again as a stand alone command but i have no data, even if i try to import again Not the end of teh world, as its now running much faster, but i would love to know how to get that data back into its rightful table!!! (or in fact i'll prob put it in messages2 to hold onto for the time being!!! Jeremy McSpadden wrote > > 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. > > -- > -- View this message in context: http://baruwa-users-list.963389.n3.nabble.com/Baruwa-VERY-slow-tp3746553p3752456.html Sent from the Baruwa users list mailing list archive at Nabble.com. _______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056
