谢谢,主要是备份的DZX2的数据库及WRODPRESS的数据库。

解决方案 »

  1.   

    这个工具能备份不能还原吗?
    还原难道不是直接mysql < {sql文件}吗?
      

  2.   

    偶试过MYSQL < .SQL文件,好像不行,也不报错,就挂在那。当然也就没有还原数据。
    这个工具没有还原功能,开始用的时候竟然没有注意。
      

  3.   

    主要的文件有二个:
    haoyujuncom_routines_MySQLServer20110825.sql
    -- Table structure for table `wp_commentmeta`
    --DROP TABLE IF EXISTS `wp_commentmeta`;
    SET @saved_cs_client     = @@character_set_client;
    SET character_set_client = utf8;
    CREATE TABLE `wp_commentmeta` (
      `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
      `comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',
      `meta_key` varchar(255) DEFAULT NULL,
      `meta_value` longtext,
      PRIMARY KEY (`meta_id`),
      KEY `comment_id` (`comment_id`),
      KEY `meta_key` (`meta_key`)
    ) ENGINE=MyISAM AUTO_INCREMENT=196 DEFAULT CHARSET=utf8;
    SET character_set_client = @saved_cs_client;--
    这个好像是用来建表结构什么的。
    haoyujuncom_Alldata_MySQLServer20110825.sql
    --
    -- Dumping data for table `wp_commentmeta`
    --LOCK TABLES `wp_commentmeta` WRITE;
    /*!40000 ALTER TABLE `wp_commentmeta` DISABLE KEYS */;
    REPLACE INTO `wp_commentmeta` (`meta_id`, `comment_id`, `meta_key`, `meta_value`) VALUES (28,193,'akismet_history','a:4:{s:4:\"time\";s:13:\"1293437392.66\";s:7:\"message\";s:42:\"admin changed the comment status to delete\";s:5:\"event\";s:13:\"status-delete\";s:4:\"user\";s:5:\"admin\";}'),(29,194,'akismet_history','a:4:{s:4:\"time\";s:13:\"1293437392.66\";s:7:\"message\";s:42:\"admin changed the comment status to delete\";s:5:\"event\";s:13:\"status-delete\";s:4:\"user\";s:5:\"admin\";}'),(30,195,'akismet_history','a:4:{s:4:\"time\";s:13:\"1293437392.66\";s:7:\"message\";s:42:\"admin changed the comment status to delete\";s:5:\"event\";s:13:\"status-delete\";s:4:\"user\";s:5:\"admin\";}'),(136,232,'akismet_result','true'),(137,232,'akismet_history','a:4:{s:4:\"time\";s:13:\"1302756977.49\";s:7:\"message\";s:32:\"Akismet 认为这是垃圾评论\";s:5:\"event\";s:10:\"check-spam\";s:4:\"user\";s:0:\"\";}'),(138,232,'akismet_as_submitted','a:54:{s:15:\"comment_post_ID\";s:3:\"447\";s:14:\"comment_author\";s:13:\"Live Gay Chat\";s:20:\"comment_author_email\";s:20:\"[email protected]\";s:18:\"comment_author_url\";s:27:\"http://www.gaylivechat.net/\";s:15:\"comment_content\";s:68:\"He\'s not worth your time and don\'t even think about taking him back.\";s:12:\"comment_type\";s:0:\"\";s:14:\"comment_parent\";s:1:\"0\";s:7:\"user_ID\";s:1:\"0\";s:7:\"user_ip\";s:13:\"108.62.167.18\";s:10:\"user_agent\";s:115:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US) AppleWebKit/532.2 (KHTML, like Gecko) Chrome/4.0.221.7 Safari/532.2\";s:8:\"referrer\";s:0:\"\";s:4:\"blog\";s:27:\"http://www.haoyujun.com\";s:9:\"blog_lang\";s:5:\"zh_CN\";s:12:\"blog_charset\";s:5:\"UTF-8\";s:9:\"permalink\";s:34:\"http://www.haoyujun.com/?p=447\";s:9:\"user_role\";s:0:\"\";s:21:\"akismet_comment_nonce\";s:6:\"failed\";s:11:\"POST_author\";s:13:\"Live Gay Chat\";s:10:\"POST_email\";s:20:\"[email protected]\";s:8:\"POST_url\";s:27:\"http://www.gaylivechat.net/\";s:12:\"POST_comment\";s:68:\"He\'s not worth your time and don\'t even think about taking him back.\";s:11:\"POST_submit\";s:14:\"Submit Comment\";s:20:\"POST_comment_post_ID\";s:3:\"447\";s:15:\"SERVER_SOFTWARE\";s:21:\"Apache/2.2.3 (CentOS)\";s:11:\"REQUEST_URI\";s:25:\"/hyj/wp-comments-post.php\";s:16:\"REDIRECT_HANDLER\";s:11:\"cgi-wrapper\";s:15:\"REDIRECT_STATUS\";s:3:\"200\";s:11:\"HTTP_ACCEPT\";s:56:\"image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, */*\";s:12:\"CONTENT_TYPE\";s:48:\"application/x-www-form-urlencoded; charset=utf-8\";s:15:\"HTTP_USER_AGENT\";s:115:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US) AppleWebKit/532.2 (KHTML, like Gecko) Chrome/4.0.221.7 Safari/532.2\";s:9:\"HTTP_HOST\";s:16:\"www.haoyujun.com\";s:14:\"CONTENT_LENGTH\";s:3:\"248\";s:4:\"PATH\";s:28:\"/bin:/usr/bin:/usr/local/bin\";s:16:\"SERVER_SIGNATURE\";s:0:\"\";s:11:\"SERVER_NAME\";s:16:\"www.haoyujun.com\";s:11:\"SERVER_ADDR\";s:13:\"58.215.64.137\";s:11:\"SERVER_PORT\";s:2:\"80\";s:11:\"REMOTE_ADDR\";s:13:\"108.62.167.18\";s:13:\"DOCUMENT_ROOT\";s:23:\"/www/users/sybasecn.com\";s:12:\"SERVER_ADMIN\";s:18:\"[no address given]\";s:15:\"SCRIPT_FILENAME\";s:48:\"/www/users/sybasecn.com/hyj/wp-comments-post.php\";s:11:\"REMOTE_PORT\";s:5:\"55749\";s:12:\"REDIRECT_URL\";s:25:\"/hyj/wp-comments-post.php\";s:17:\"GATEWAY_INTERFACE\";s:7:\"CGI/1.1\";s:15:\"SERVER_PROTOCOL\";s:8:\"HTTP/1.0\";s:14:\"REQUEST_METHOD\";s:4:\"POST\";s:12:\"QUERY_STRING\";s:0:\"\";s:11:\"SCRIPT_NAME\";s:25:\"/hyj/wp-comments-post.php\";s:20:\"ORIG_PATH_TRANSLATED\";s:48:\"/www/users/sybasecn.com/hyj/wp-comments-post.php\";s:16:\"ORIG_SCRIPT_NAME\";s:25:\"/hyj/wp-comments-post.php\";s:8:\"PHP_SELF\";s:25:\"/hyj/wp-comments-post.php\";s:12:\"REQUEST_TIME\";s:10:\"1302756975\";s:4:\"argv\";s:0:\"\";s:4:\"argc\";s:1:\"0\";}'),(32,197,'akismet_history','a:4:{s:4:\"time\";s:13:\"1293437392.67\";s:7:\"message\";s:42:\"admin changed the comment status to delete\";s:5:\"event\";s:13:\"status-delete\";s:4:\"user\";s:5:\"admin\";}'),(37,199,'akismet_history','a:4:{s:4:\"time\";s:13:\"1294453621.68\";s:7:\"message\";s:42:\"admin changed the comment status to delete\";s:5:\"event\";s:13:\"status-delete\";s:4:\"user\";s:5:\"admin\";}'),(45,201,'akismet_history','a:4:{s:4:\"time\";s:13:\"1295768906.57\";s:7:\"message\";s:42:\"admin changed the comment status to delete\";s:5:\"event\";s:13:\"status-delete\";s:4:\"user\";s:5:\"admin\";}'),(31,196,'akismet_history','a:4:{s:4:\"time\";s:13:\"1293437392.67\";s:7:\"message\";s:42:\"admin changed the comment status to delete\";s:5:\"event\";s:13:\"status-
    .....太长了,中间省掉
    UNLOCK TABLES;--
    这个好像是存储的表数据
      

  4.   

    DROP TABLE IF EXISTS `wp_commentmeta`;
    SET @saved_cs_client = @@character_set_client;
    SET character_set_client = utf8;
    CREATE TABLE `wp_commentmeta` (
       `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
       `comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',
       `meta_key` varchar(255) DEFAULT NULL,
       `meta_value` longtext,
       PRIMARY KEY (`meta_id`),
       KEY `comment_id` (`comment_id`),
       KEY `meta_key` (`meta_key`)
    ) ENGINE=MyISAM AUTO_INCREMENT=196 DEFAULT CHARSET=utf8;
    SET character_set_client = @saved_cs_client;
    LOCK TABLES `wp_commentmeta` WRITE;
    /*!40000 ALTER TABLE `wp_commentmeta` DISABLE KEYS */;
    REPLACE INTO `wp_commentmeta` (`meta_id`, `comment_id`, `meta_key`, `meta_value`) VALUES (28,193,'akismet_history','a:4:{s:4:\"time\";s:13:\"1293437392.66\";s:7:\"message\";s:42:\"admin changed the comment status to delete\";s:5:\"event\";s:13:\"status-delete\";s:4:\"user\";s:5:\"admin\";}'),(29,194,'akismet_history','a:4:{s:4:\"time\";s:13:\"1293437392.66\";s:7:\"message\";s:42:\"admin changed the comment status to delete\";s:5:\"event\";s:13:\"status-delete\";s:4:\"user\";s:5:\"admin\";}'),(30,195,'akismet_history','a:4:{s:4:\"time\";s:13:\"1293437392.66\";s:7:\"message\";s:42:\"admin changed the comment status to delete\";s:5:\"event\";s:13:\"status-delete\";s:4:\"user\";s:5:\"admin\";}'),(136,232,'akismet_result','true'),(137,232,'akismet_history','a:4:{s:4:\"time\";s:13:\"1302756977.49\";s:7:\"message\";s:32:\"Akismet 认为这是垃圾评论\";s:5:\"event\";s:10:\"check-spam\";s:4:\"user\";s:0:\"\";}'),(138,232,'akismet_as_submitted','a:54:{s:15:\"comment_post_ID\";s:3:\"447\";s:14:\"comment_author\";s:13:\"Live Gay Chat\";s:20:\"comment_author_email\";s:20:\"[email protected]\";s:18:\"comment_author_url\";s:27:\"http://www.gaylivechat.net/\";s:15:\"comment_content\";s:68:\"He\'s not worth your time and don\'t even think about taking him back.\";s:12:\"comment_type\";s:0:\"\";s:14:\"comment_parent\";s:1:\"0\";s:7:\"user_ID\";s:1:\"0\";s:7:\"user_ip\";s:13:\"108.62.167.18\";s:10:\"user_agent\";s:115:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US) AppleWebKit/532.2 (KHTML, like Gecko) Chrome/4.0.221.7 Safari/532.2\";s:8:\"referrer\";s:0:\"\";s:4:\"blog\";s:27:\"http://www.haoyujun.com\";s:9:\"blog_lang\";s:5:\"zh_CN\";s:12:\"blog_charset\";s:5:\"UTF-8\";s:9:\"permalink\";s:34:\"http://www.haoyujun.com/?p=447\";s:9:\"user_role\";s:0:\"\";s:21:\"akismet_comment_nonce\";s:6:\"failed\";s:11:\"POST_author\";s:13:\"Live Gay Chat\";s:10:\"POST_email\";s:20:\"[email protected]\";s:8:\"POST_url\";s:27:\"http://www.gaylivechat.net/\";s:12:\"POST_comment\";s:68:\"He\'s not worth your time and don\'t even think about taking him back.\";s:11:\"POST_submit\";s:14:\"Submit Comment\";s:20:\"POST_comment_post_ID\";s:3:\"447\";s:15:\"SERVER_SOFTWARE\";s:21:\"Apache/2.2.3 (CentOS)\";s:11:\"REQUEST_URI\";s:25:\"/hyj/wp-comments-post.php\";s:16:\"REDIRECT_HANDLER\";s:11:\"cgi-wrapper\";s:15:\"REDIRECT_STATUS\";s:3:\"200\";s:11:\"HTTP_ACCEPT\";s:56:\"image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, */*\";s:12:\"CONTENT_TYPE\";s:48:\"application/x-www-form-urlencoded; charset=utf-8\";s:15:\"HTTP_USER_AGENT\";s:115:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US) AppleWebKit/532.2 (KHTML, like Gecko) Chrome/4.0.221.7 Safari/532.2\";s:9:\"HTTP_HOST\";s:16:\"www.haoyujun.com\";s:14:\"CONTENT_LENGTH\";s:3:\"248\";s:4:\"PATH\";s:28:\"/bin:/usr/bin:/usr/local/bin\";s:16:\"SERVER_SIGNATURE\";s:0:\"\";s:11:\"SERVER_NAME\";s:16:\"www.haoyujun.com\";s:11:\"SERVER_ADDR\";s:13:\"58.215.64.137\";s:11:\"SERVER_PORT\";s:2:\"80\";s:11:\"REMOTE_ADDR\";s:13:\"108.62.167.18\";s:13:\"DOCUMENT_ROOT\";s:23:\"/www/users/sybasecn.com\";s:12:\"SERVER_ADMIN\";s:18:\"[no address given]\";s:15:\"SCRIPT_FILENAME\";s:48:\"/www/users/sybasecn.com/hyj/wp-comments-post.php\";s:11:\"REMOTE_PORT\";s:5:\"55749\";s:12:\"REDIRECT_URL\";s:25:\"/hyj/wp-comments-post.php\";s:17:\"GATEWAY_INTERFACE\";s:7:\"CGI/1.1\";s:15:\"SERVER_PROTOCOL\";s:8:\"HTTP/1.0\";s:14:\"REQUEST_METHOD\";s:4:\"POST\";s:12:\"QUERY_STRING\";s:0:\"\";s:11:\"SCRIPT_NAME\";s:25:\"/hyj/wp-comments-post.php\";s:20:\"ORIG_PATH_TRANSLATED\";s:48:\"/www/users/sybasecn.com/hyj/wp-comments-post.php\";s:16:\"ORIG_SCRIPT_NAME\";s:25:\"/hyj/wp-comments-post.php\";s:8:\"PHP_SELF\";s:25:\"/hyj/wp-comments-post.php\";s:12:\"REQUEST_TIME\";s:10:\"1302756975\";s:4:\"argv\";s:0:\"\";s:4:\"argc\";s:1:\"0\";}'),(32,197,'akismet_history','a:4:{s:4:\"time\";s:13:\"1293437392.67\";s:7:\"message\";s:42:\"admin changed the comment status to delete\";s:5:\"event\";s:13:\"status-delete\";s:4:\"user\";s:5:\"admin\";}'),(37,199,'akismet_history','a:4:{s:4:\"time\";s:13:\"1294453621.68\";s:7:\"message\";s:42:\"admin changed the comment status to delete\";s:5:\"event\";s:13:\"status-delete\";s:4:\"user\";s:5:\"admin\";}'),(45,201,'akismet_history','a:4:{s:4:\"time\";s:13:\"1295768906.57\";s:7:\"message\";s:42:\"admin changed the comment status to delete\";s:5:\"event\";s:13:\"status-delete\";s:4:\"user\";s:5:\"admin\";}'),(31,196,'akismet_history','a:4:{s:4:\"time\";s:13:\"1293437392.67\";s:7:\"message\";s:42:\"admin changed the comment status to delete\";s:5:\"event\";s:13:\"status-
    .....太长了,中间省掉
    UNLOCK TABLES;COPY出来生成TXT文件,用
    mysql -uroot -p<R:\TEMP\123.TXT
    导入试试
      

  5.   

    下了1个,看了看,还是调用MYSQLDUMP来备份的,测试 了一下,可以用
    mysql -uroot -p<R:\TEMP\123.TXT可以导入的