dishwara
Legendary
Offline
Activity: 1855
Merit: 1016
|
|
June 26, 2011, 04:56:50 AM |
|
I created auto profile by choosing 7, then i chose wrongly 6 & also 8. since there is no way to come out(windows user, esc gets out), i did some thing wrong & getting 64 instances. Here is the dump. Also mysql asked password & i gave none. Do have to give password or can continue with just enter(no password) DUMP
-- MySQL dump 10.13 Distrib 5.1.54, for debian-linux-gnu (x86_64) -- -- Host: localhost Database: smartcoin -- ------------------------------------------------------ -- Server version 5.1.54-1ubuntu4
/*!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 `current_profile` --
DROP TABLE IF EXISTS `current_profile`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `current_profile` ( `fk_machine` int(11) DEFAULT NULL, `fk_profile` int(11) DEFAULT NULL, UNIQUE KEY `fk_machine` (`fk_machine`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `current_profile` --
LOCK TABLES `current_profile` WRITE; /*!40000 ALTER TABLE `current_profile` DISABLE KEYS */; INSERT INTO `current_profile` VALUES (1,-1); /*!40000 ALTER TABLE `current_profile` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `device` --
DROP TABLE IF EXISTS `device`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `device` ( `pk_device` int(11) NOT NULL AUTO_INCREMENT, `fk_machine` int(11) DEFAULT NULL, `name` varchar(30) DEFAULT NULL, `device` int(11) DEFAULT NULL, `type` varchar(30) DEFAULT NULL, `auto_allow` tinyint(1) DEFAULT NULL, `disabled` tinyint(1) DEFAULT NULL, PRIMARY KEY (`pk_device`), UNIQUE KEY `fk_machine_2` (`fk_machine`,`device`) ) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `device` --
LOCK TABLES `device` WRITE; /*!40000 ALTER TABLE `device` DISABLE KEYS */; INSERT INTO `device` VALUES (1,1,'GPU[0]',0,'gpu',1,0),(2,1,'GPU[1]',1,'gpu',1,0),(3,1,'GPU[2]',2,'gpu',1,0),(4,1,'GPU[3]',3,'gpu',1,0),(5,1,'GPU[4]',4,'gpu',1,0),(6,1,'GPU[5]',5,'gpu',1,0),(7,1,'GPU[6]',6,'gpu',1,0),(8,1,'GPU[7]',7,'gpu',1,0),(9,1,'CPU[8]',8,'cpu',1,1); /*!40000 ALTER TABLE `device` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `machine` --
DROP TABLE IF EXISTS `machine`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `machine` ( `pk_machine` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30) DEFAULT NULL, `server` varchar(100) DEFAULT NULL, `ssh_port` int(11) DEFAULT NULL, `username` varchar(30) DEFAULT NULL, `auto_allow` tinyint(1) DEFAULT NULL, `disabled` tinyint(1) DEFAULT NULL, PRIMARY KEY (`pk_machine`), UNIQUE KEY `name` (`name`,`server`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `machine` --
LOCK TABLES `machine` WRITE; /*!40000 ALTER TABLE `machine` DISABLE KEYS */; INSERT INTO `machine` VALUES (1,'localhost','127.0.0.1',22,'dishwara00',1,0); /*!40000 ALTER TABLE `machine` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `macro` --
DROP TABLE IF EXISTS `macro`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `macro` ( `pk_macro` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30) DEFAULT NULL, `auto_allow` tinyint(1) DEFAULT NULL, PRIMARY KEY (`pk_macro`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `macro` --
LOCK TABLES `macro` WRITE; /*!40000 ALTER TABLE `macro` DISABLE KEYS */; /*!40000 ALTER TABLE `macro` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `macro_map` --
DROP TABLE IF EXISTS `macro_map`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `macro_map` ( `pk_macro_map` int(11) NOT NULL AUTO_INCREMENT, `fk_macro` int(11) DEFAULT NULL, `fk_profile` int(11) DEFAULT NULL, `fk_machine` int(11) DEFAULT NULL, PRIMARY KEY (`pk_macro_map`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `macro_map` --
LOCK TABLES `macro_map` WRITE; /*!40000 ALTER TABLE `macro_map` DISABLE KEYS */; /*!40000 ALTER TABLE `macro_map` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `miner` --
DROP TABLE IF EXISTS `miner`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `miner` ( `pk_miner` int(11) NOT NULL AUTO_INCREMENT, `fk_machine` int(11) DEFAULT NULL, `name` varchar(32) DEFAULT NULL, `launch` varchar(255) DEFAULT NULL, `path` varchar(255) DEFAULT NULL, `default_miner` tinyint(1) DEFAULT NULL, `disabled` tinyint(1) DEFAULT NULL, PRIMARY KEY (`pk_miner`), UNIQUE KEY `fk_machine` (`fk_machine`,`name`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `miner` --
LOCK TABLES `miner` WRITE; /*!40000 ALTER TABLE `miner` DISABLE KEYS */; /*!40000 ALTER TABLE `miner` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `pool` --
DROP TABLE IF EXISTS `pool`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pool` ( `pk_pool` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(32) DEFAULT NULL, `server` varchar(32) DEFAULT NULL, `alternateServer` varchar(32) DEFAULT NULL, `port` int(11) DEFAULT NULL, `timeout` int(11) DEFAULT NULL, `auto_allow` tinyint(1) DEFAULT NULL, `disabled` tinyint(1) DEFAULT NULL, PRIMARY KEY (`pk_pool`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `pool` --
LOCK TABLES `pool` WRITE; /*!40000 ALTER TABLE `pool` DISABLE KEYS */; INSERT INTO `pool` VALUES (1,'DeepBit','deepbit.net',NULL,8332,60,1,0),(2,'Bitcoin.cz (slush)','mining.bitcoin.cz',NULL,8332,60,1,0),(3,'BTCGuild','btcguild.com',NULL,8332,60,1,0),(4,'BTCMine','btcmine.com',NULL,8332,60,1,0),(5,'Bitcoins.lc','bitcoins.lc',NULL,8080,60,1,0),(6,'SwePool','swepool.net',NULL,8337,60,1,0),(7,'Continuum','continuumpool.com',NULL,8332,60,1,0),(8,'MineCo','mineco.in',NULL,3000,60,1,0),(9,'Eligius','mining.eligius.st',NULL,8337,60,1,0),(10,'CoinMiner','173.0.52.116',NULL,8347,60,1,0),(11,'ZABitcoin','mine.zabitcoin.co.za',NULL,8332,60,1,0),(12,'BitClockers','pool.bitclockers.com',NULL,8332,60,1,0),(13,'MtRed','mtred.com',NULL,8337,60,1,0),(14,'SimpleCoin','simplecoin.us',NULL,8337,60,1,0),(15,'Ozco','ozco.in',NULL,8332,60,1,0),(16,'EclipseMC','us.eclipsemc.com',NULL,8332,60,1,0),(17,'BitP','pool.bitp.it',NULL,8334,60,1,0),(18,'BitcoinPool','bitcoinpool.com',NULL,8334,60,1,0),(19,'EcoCoin','ecocoin.org',NULL,8332,60,1,0),(20,'BitLottoPool','bitcoinpool.com',NULL,8337,60,1,0),(21,'X8S','pit.x8s.de',NULL,8337,60,1,0); /*!40000 ALTER TABLE `pool` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `profile` --
DROP TABLE IF EXISTS `profile`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `profile` ( `pk_profile` int(11) NOT NULL AUTO_INCREMENT, `fk_machine` int(11) DEFAULT NULL, `name` varchar(32) DEFAULT NULL, `auto_allow` tinyint(1) DEFAULT NULL, PRIMARY KEY (`pk_profile`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `profile` --
LOCK TABLES `profile` WRITE; /*!40000 ALTER TABLE `profile` DISABLE KEYS */; /*!40000 ALTER TABLE `profile` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `profile_map` --
DROP TABLE IF EXISTS `profile_map`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `profile_map` ( `pk_profile_map` int(11) NOT NULL AUTO_INCREMENT, `fk_device` int(11) DEFAULT NULL, `fk_miner` int(11) DEFAULT NULL, `fk_worker` int(11) DEFAULT NULL, `fk_profile` int(11) DEFAULT NULL, PRIMARY KEY (`pk_profile_map`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `profile_map` --
LOCK TABLES `profile_map` WRITE; /*!40000 ALTER TABLE `profile_map` DISABLE KEYS */; /*!40000 ALTER TABLE `profile_map` ENABLE KEYS */; UNLOCK TABLES;
-- -- Table structure for table `settings` --
DROP TABLE IF EXISTS `settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `settings` ( `pk_settings` int(11) NOT NULL AUTO_INCREMENT, `data` varchar(32) DEFAULT NULL, `value` varchar(255) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, PRIMARY KEY (`pk_settings`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */;
-- -- Dumping data for table `settings` --
LOCK TABLES `settings` WRITE; /*!40000 ALTER TABLE `settings` DISABLE KEYS */; INSERT INTO `settings` VALUES (1,'donation_time','5','Hashpower donation minutes per day'),(2,'donation_start','632','Time to start hashpower donation each day'); /*!40000 ALTER TABLE `settings` 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 2011-06-26 10:25:46
|