Mysql通过查询语句查询得到Mysql安装路径


1、通过MySQL语句得到mysql安装路径:

select @@basedir as basePath from dual  

2、通过dos命令将库导出到mysql安装目录bin下:

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqldump.exe -u root -p test > a.txt