Last active
December 16, 2015 16:40
-
-
Save baijian/5464990 to your computer and use it in GitHub Desktop.
mysqldump
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
命令导出数据库表or数据: | |
>mysqldump -u用戶名 -p密码 -d 數據库名 表名 脚本名; | |
导出数据库所有表结构 | |
>mysqldump -uroot -password -d dbname > db.sql | |
导出数据库table表接口 | |
>mysqldump -uroot -ppassword -d dbname table > table.sql | |
导出数据库所表结构及数据 | |
>mysqldump -uroot -ppassword dbname > db.sql | |
导出数据库table表结构及数据 | |
>mysqldump -uroot -ppassword dbname table > table.sql | |
查看软件版本: | |
aptitude show xxx | |
也可用apt-show-versions (要先安装sudo apt-get install apt-show-versions) | |
查看软件安装位置: | |
dpkg -L xxxx | |
查看软件是否安装: | |
dpkg -l | grep filename |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment