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
只講重點的設計教學,立刻學習網頁教學網誌!
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