標(biāo)題: mysqldump 導(dǎo)入數(shù)據(jù)庫問題 db.opt [打印本頁] 作者: hjk857 時間: 2009-07-05 23:00 標(biāo)題: mysqldump 導(dǎo)入數(shù)據(jù)庫問題 db.opt 版本：mysql Ver 14.14 Distrib 5.1.30, for pc-linux-gnu (i686) using EditLine wrapper
安裝：cacti-0.8.7e.tar.gz
里面有一個文件：cacti.sql
在執(zhí)行如下操作的時候提示如下：
[root@localhost cacti]# mysqldump -u root -p cacti < cacti.sql
Enter password:
-- MySQL dump 10.9
--
-- Host: localhost Database: cacti
-- ------------------------------------------------------
-- Server version 5.1.30-log
/*!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 */;
/*!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 */;
/*!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 */;
---------------------------------------------------------------
[root@localhost cacti]# ls -lh /var/mysql/cacti/
total 8.0K
-rw-rw---- 1 mysql mysql 65 Jul 4 14:14 db.opt