按楼上的做是这样的结果: C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqldump -uroot -p -h localhost eho medatabase<D:\zimu.sql; Enter password: ***** -- MySQL dump 10.11 -- -- Host: localhost Database: ehomedatabase; -- ------------------------------------------------------ -- Server version 5.0.51b-community-nt/*!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 */; mysqldump: Got error: 1049: Unknown database 'ehomedatabase;' when selecting the database
qlC:\Program Files\MySQL\MySQL Server 5.1\bin>mysqldump -uroot -p123 test t22 >aa.
sql
mysqldump: Couldn't find table: "t22"C:\Program Files\MySQL\MySQL Server 5.1\bin>[/code]
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -h localhost -uroot -p ehomeda
tabase<D:\zimu.sql;
Enter password: *****
ERROR 1049 (42000): Unknown database 'ehomedatabase;'
确认你的系统里只安装了一个mysql。
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqldump -uroot -p -h localhost eho
medatabase<D:\zimu.sql;
Enter password: *****
-- MySQL dump 10.11
--
-- Host: localhost Database: ehomedatabase;
-- ------------------------------------------------------
-- Server version 5.0.51b-community-nt/*!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 */;
mysqldump: Got error: 1049: Unknown database 'ehomedatabase;' when selecting the
database
source D:zimu.sql导出没什么大错 就是你的命令的最后不应该有分号 去掉就好了
medatabase > D:\zimu.sql;
/*!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 */;
mysqldump: Got error: 1049: Unknown database 'ehomedatabase;' when selecting the
database
打开你的 D:\zimu.sql 贴一下其中的内容,主要是出错语句位置的。
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqldump -uroot -p ehomedatabase < D:\zimu.sql另外不要加分号