Windows下:DOS 窗口:开始->运行-> cmd

打开mysql服务器安装目录的bin目录,比如

\Program Files\MySQL\MySQL Server 5.0\bin

导出为: mysqldump -u 用户名 -p –opt 数据库名 > 数据库名.sql

输入你的数据库密码!

导入为:mysql -u 用户名 -p 数据库用户名 < 数据库名.sql (要在当前目录下操作)

—-2009/11/25

Tags:

Related posts

Tags: .
Home

2 Comments so far

Trackbacks/Pingbacks

Leave a comment

Name(required)
Mail (required),(will not be published)
Website(recommended)

Fields in bold are required. Email addresses are never published or distributed.

Some HTML code is allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>
URLs must be fully qualified (eg: http://hanghang.name),and all tags must be properly closed.

Line breaks and paragraphs are automatically converted.

Please keep comments relevant. Off-topic, offensive or inappropriate comments may be edited or removed.