mysqldump数据库操作命令
Posted by admin on June 30, 2008 in 朝花夕拾, 电脑网络 Views:166 views
数据导出:
mysqldump –opt -u user -p -h hostname DB > file.sql
数据导入:
mysql -u user -p DB < file.sql
导出时设定编码为UTF-8:
mysqldump --default-character-set=utf-8 --opt -u user -p -h hostname DB > file.sql
Last 5 posts in 朝花夕拾
- 经典猴故事 - June 13th, 2008
- 160亿像素的图片!——达芬奇的《最后的晚餐》 - January 2nd, 2008
- 订阅新闻 - November 19th, 2007
- 基于CSS的导航 - November 18th, 2007
- 用CSS实现动态拼图 - November 18th, 2007
Comment
Log in or Register to post a comment.