mysql 命令

导出mysql -uroot -p databaseName  tableName>file.dump

导入mysql -uroot -p databaseName<file.dump

 

查看索引show index from tableName;

创建索引create index index_name on tableName(column_name);

删除索引drop index index_name on talbeName

 

执行sql脚本 mysql -h 192.168.1.128 -uname -ppasswd database_name < script.sql

LOAD DATA LOCAL INFILE "/folder/myfile.txt" INTO TABLE tablename

mysqldump --skip-lock-tables --extended-insert --set-gtid-purged=OFF --single-transaction -u root -B bi --tables river_talent_corps >  r_test.dump

 

 

sudo apt-get remove --purge mysql-server mysql-client mysql-common
sudo apt-get autoremove
sudo apt-get autoclean


http://askubuntu.com/questions/140246/how-do-i-resolve-unmet-dependencies-after-adding-a-ppa

 

 

libmysqld-dev

libmysqlclient-dev

 

MySQL-python is the right one:

easy_install MySQL-python

or

pip install MySQL-python