2005-12-22 12:44:45 by: h4x0r

mysql导入导出

Font Size: Large | Medium | Small
导出:x:\mysql\bin\mysqldump --database 数据库名-u 用户名 -p密码 -r D:\xxxx\yyy.sql
导入:x:\mysql\bin\mysql
mysql>use database;
mysql>source d:/xxx/yy.sql;

更简单的呢,直接用管道

mysqldump -h hostname -u root -p password databasename >xxx.sql
mysql -u root -p password databasename<xxx.sql
Comments Feed Comments Feed: http://www.4evil.org/feed.asp?q=comment&id=400

There is no comment on this article.

Post Comment
Smilies
[smile] [confused] [cool] [cry]
[eek] [angry] [wink] [sweat]
[lol] [stun] [razz] [redface]
[rolleyes] [sad] [yes] [no]
[heart] [star] [music] [idea]
Enable UBB Codes
Auto Convert URL
Show Smilies
Hidden Comment
Username:   Password:   Register Now?
Security Code * Please Enter the Security Code